MS Access Default Menu Bar

[rhonda11]

I hide all the menu bar from startup. After doing that, I realized that I need to make some changes to the database at the designed view. How can I get "allow full menu" again (restore the default menu)

Note: I did do any customize menu bar, I only hide it, so no one can go into design view to screw up my design.

Please help....thanks

 

[Lightning]

If all you did was hide the menu bars, and you did not disable the Access special keys, then hold down the [SHIFT] key while you open the database. This will bypass the startup settings and take you straight to the database window

HTH
Lightning

 

[rhonda11]

Thank you very much!!

 

[glrpfi]

If you are going to need to get into the database innards regularly to perform maintenance, etc., have the db recognize the network login of the user via :

dim pcuser as string
pcuser = fOSUserName

then if pcuser = {whomever you are}

insert code to activate the tools menubar.

 

[RickSpr]

glrpfi,

The fOSUserName() function is not part of Access, so this won't work without first defining that function.

Also, if the built-in menus and toolbars were excluded using the Startup properties, as Rhonda said, then there is no way to reactivate them with code, because Access doesn't even load them into memory. They're not just invisible, they don't exist! Rick Sprague

 

[rhonda11]

Thanks guys, holding down the SHIFT key while opening the database works! I was able to get my menu bar and do some changes. Thank you, Ligtning