Hidden toolbar unable to get to show

[v_fas]

Hi,
I need to make changes to an Access 2003 database. I have been unable to
find a copy of the db where the full toolbar is not hidden; I have tried to
use SHIFT button while openign to get it to reveal, with no luck. I am at my
wits end. Any help appreciated. Thanks in advance.

 

[Jack Leach]

The previous developer may have this turned off... you can change visibility
through VBA.

Open the VBA window, and add a reference to the Microsoft Office Objects
11.0 Library if it is not already referenced (references can be found under
the Tools menu in the VBE).

Go to the immediate window and enter the following:

Commandbars("Menu Bar").Visible = True

this should unhide the main menu for you. Alternatively, you might be able
to unhide ALL menus with a procedure similar to this:

Public Sub UnhideMenus()
Dim cb As CommandBar
For Each cb In CommandBars
cb.Visible = True
Next
End Sub


hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)