Menu bar in customize missing

By the way, I am working in Access 97.  Thanks.

Was this a custom menu, or part of Access's built-in menu?

If it was the built in menu:
Tools -> Customize -> Reset

If it was a custom menu,
- Right click on the database window
- Import...
- Select a database that contains the menu
- Click the Options buton
- Select Menus and Toolbars under Import
- Click OK

Thanks for your help.  It was a built in menu bar named "Menu Bar".  It was checked and I accidently deleted it when I was deleting some custom bars.  
When I go to tool, customize, reset - it only resets the item that is checked.  The menu bar is missing so I can't reset it.  

I tried this, but it only shows toolbars and not menu bars:

Dim varCommandBar

For Each varCommandBar In Application.CommandBars

varCommandBar.Visible = True

Next

Does this help?

  Reset method of CommandBars rebuilds menu bar only
  http://support.microsoft.com/kb/172967

Hello Sacha42,

> It was a built in menu bar named "Menu Bar".  

That is the default menu bar... you can't delete it. I tried to reproduce this problem but was unable to do so. You are saying that when you go to "view / toolbars / customize", you don't see the menu any longer?

If it's simply not active, try "tools / startup..." and choose (default) in the "menu bar" dropdown. [OK], close and reopen your database.

Anyway, if the "menu bar" is really gone, you cannot import it from another database; only custom bars are stored in databases. I suppose I would uninstall Access 97, delete the installation folder, delete any relevant registry entries (optional, try without it first), and reinstall.

Cheers!
(°v°)

p912s - thanks for your help.  

Application.CommmandBars("Menu Bar").Reset

This looks like the fix I need, however, when I run the line of code I get:

Method or Data Member Not Found message and then the word commandbars is selected.

harfang - yes, the menu bar is indeed missing or perhaps it is hidden but it is not listed in Tools, Customize.  When I go to Tools, StartUp all the defaults are selected and it doesn't make any difference.  Shirley, there is a way to correct this without having to reinstall Access.

jimpin - thanks for your suggestion.  When I run it, I get:

Subscript out of range
 
the below is highligted in yellow:

If Access.CommandBars(I).BuiltIn = True Then

Any ideas?  thanks

p912s - thanks so much.

I get 103 menus too.

When I run ResetMenu(), I do not get an error message, but nothing visible happens.  The Menu Bar does not become an option in Customize.  I have tried various combinations of running code and rebooting.  Any other thoughts.  Thanks again.

>>When I run ResetMenu(), I do not get an error message, but nothing visible happens.
Same when I run it...

On a copy of your database what happens when you click Tools --> Customize --> Reset, anything?

On the computer I'm looking at Mennu Bar is the second from the bottom and there are 22 items in the Toolbars list.

Tools, Customize and there is no menu bar option.  Yes, it used to be there.  I counted 21 items in the Toolbar list.  I work in lots of databases and have developed lots of databases, if I reinstall Access 97 are there any problems I should anticipate?

>>if I reinstall Access 97 are there any problems I should anticipate
That was to be my next suggestion.

The only thing I've run into when reinstalling Access is the Font issue:

  "There is no license" error message starting Microsoft Access
  http://support.microsoft.com/kb/141373