Selasa, 03 April 2012

Re: [MS_AccessPros] Help Hiding Document Tabs using VBA

 

Hi Crystal

Yup, Allen has lots of unique code. But sometimes it's hard to find what you want.

And his site is the go-to site for reading up on Access bugs. It seems he has them published long before anyone else does.

Bill

--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> you're welcome, Pablo :)
>
> nice link, Bill -- Allen has such great code! And so much of it posted!
>
> Warm Regards,
> Crystal
>
>  *
>    (: have an awesome day :)
>  *
>
>
>
> ________________________________
> From: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, April 3, 2012 9:24 AM
> Subject: Re: [MS_AccessPros] Help Hiding Document Tabs using VBA
>
> Pablo
>
> The tab setting affects only the database that you set it for. All others will use the default tab view.
>
> There is a nice module written by Allen Browne that lets you prep a database so the user has less control. It's at http://www.allenbrowne.com/ser-69.html
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "Pablo" <psanchez95@> wrote:
> >
> > Thank you Crystal. I realised that you have to decide if your database will use "Overlapping Windows" or "Overlapping Documents" before the database loads (in VBA, through a module) and unfortunately I can't switch back and forth while the database is open. But this is the next best thing. Thanks.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@> wrote:
> > >
> > > Hi Pablo,
> > >
> > > use Overlapping Windows instead of Overlapping Documents as your interface -- then you have a lot more control :)
> > >
> > > Switch from tabs to overlapping windows (2007)
> > > http://office.microsoft.com/en-us/access/HA012292811033.aspx
> > >
> > > ~~~ 2007
> > > (1) Click the Microsoft Office Button Button in the upper left corner
> > > (2) choose --> Access Options command button in lower right
> > >
> > > ~~~ 2010
> > > (1) Click the File menu option in the upper left
> > > (2) choose --> Options from the bottom of the left sidebar menu
> > >
> > > The Access Options dialog box appears.
> > >
> > > (3) choose --> Current Database
> > >
> > > (4)  In the Application Options section, under Document Window Options:
> > >
> > > check 'Overlapping Windows' or 'Display Document Tabs'
> > >
> > > Overlapping Windows is what Access 2003 and previous versions use
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > Microsoft MVP, Access
> > > remote training and programming
> > >
> > > www.AccessMVP.com/strive4peace
> > >
> > > www.YouTube.com/LearnAccessByCrystal
> > > www.YouTube.com/LearnByCrystal
> > >
> > > * (:  have an awesome day :) *
> > >
> > >
> > >
> > >
> > >
> > > ________________________________
> > >  From: Pablo <psanchez95@>
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Sent: Saturday, March 31, 2012 1:25 AM
> > > Subject: [MS_AccessPros] Help Hiding Document Tabs using VBA
> > > 
> > > Hi folks, can anyone tell me if they know how to hide the document tabs of a form using VBA? I have uploaded a picture of the problem in the "2-Assisted Needed" folder. FILE NAME: PS-03.31.2012
> > >
> > > Thank you.
> > > Pablo
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
> [Non-text portions of this message have been removed]
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar