If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Toolbars Hide
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 |
#2
|
|||
|
|||
Toolbars Hide
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/AlbertKal...s/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/AlbertKal.../msaccess.html -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada |
#3
|
|||
|
|||
Toolbars Hide
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 wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|