2003 Access menu bar disappears

[Carol Grismore]

For some of the people on our network, the Access menu bar disappears, and in
order to get it back the tech desk has been starting over with a whole new
profile. There must be an easier way, or a service pack or workaround or
something. Help!

 

[KC-Mass]

Hi Carol,

I seem to recall that if you hold the shift key down when you start Access,
the menu bar will reappear.

I believe the menu bar is just another tool bar in Access and can be
programmed. The only difference is I think the menu bar is stored in the
registry. When you get your menu back look under view.


Regards

Kevin

 

[KC-Mass]

By the way, if your IT folks want to get to the keys in the registry, they
are at
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Settings\CommandBars
That is for Access 2003. That is signified by the "11.0". Other versions
would have a different number.

Regards

Kevin

 

[dymondjack]

In addition to Kevin's suggestions, you can programmatically access the
command bar from vba. This requires the Microsoft Office 11.0 Object Library
reference to be set (for 2003 anyway), so that you can access the CommandBars
collection.

I forget the exact syntax, but something along the lines of:

Application.CommandBars("Menu").Visible = True

should active the standard access menu bar.

I'll look around when I get home later and see if I can locate the line I've
used in the past to accomplish this.

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill

 

[dymondjack]

The correct line is:

Application.ComandBars("Menu Bar").Visible = True


You might also want to look at the startup properties of the database, most
options for menubars are set here.

--
Jack Leach
www.tristatemachine.com

- "Success is the ability to go from one failure to another with no loss of
enthusiasm." - Sir Winston Churchill