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@comcast.net>
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]
Tidak ada komentar:
Posting Komentar