Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / December 2007

Tip: Looking for answers? Try searching our database.

Toolbars Hide

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
learning_codes@hotmail.com - 31 Dec 2007 00:37 GMT
Hi,

I would like to hide all toolbars.  How many toolbars that Access XP
has?

DoCmd.ShowToolbar "Menu Bar", acToolbarNo
DoCmd.ShowToolbar "Database", acToolbarNo,
...
...
...
...
DoCmd.showtoolbar "My Menu", acToolbarYes

Is there a way to have all toolbars hide for one line code except my
own toolbar?

Thanks
Albert D. Kallal - 31 Dec 2007 00:45 GMT
You most certainly can, and should hide all of the ms-access interface. The
options to complete hide and keep people out of the ms-access interface can
easily be done using the tools->start-up options. Using those options allows
you to complete hide the ms-access interface (tool bars, database window
etc). Also, using these options means you do not have to bother setting up
security.

Try downloading and running the 3rd example at my following web site that
shows a hidden ms-access interface, and NO CODE is required to do
this....but just some settings in the start-up.

Check out:

http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm

After you try the application, you can exit, and then re-load the
application, but hold down the shift key to by-pass the start-up options. If
want, you can even disable the shift key by pass. I have a sample mdb file
that will let you "set" the shift key bypass on any application you want.
You can get this at:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

derek - 31 Dec 2007 14:41 GMT
Hi --

I use this code in my application --

    For Each cmdBar In CommandBars
       If cmdBar.Visible Then
           sTemp = cmdBar.Name
           DoCmd.ShowToolbar sTemp, acToolbarNo
       End If
   Next
   DoCmd.showtoolbar "My Menu", acToolbarYes

Make sure you have the Microsoft Office 10.0 object library declared as a
reference in Tools/References.

--Derek

> Hi,
>
[quoted text clipped - 13 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.