Build Menu with VBA

[DaveyEdgar]

Greetings Friends

Is it possible to create a module that will build a menu bar and set it as the default startup and hide all the other menu and toolbars?

I've done it manually, but I have to recreate it everytime I rebuild the front end database.

Thanks heaps!

 

[Remou]

You can import menubars. See the Options button on the Import form.

Some notes:
Startup options

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acstartupoptions.asp

Add, operate and delete a command bar

http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaro97ta/html/ofcmdbar.asp

 

[TheAceMan1]

How are ya DaveyEdgar . . .

in VBA help, have a look at the [blue]CommandBars Collection[/blue] . . .

See Ya! . . . . . .

 

[DaveyEdgar]

sweeet thanks that looks like it will help alot!!!

 

[DaveyEdgar]

Has anyone done this to their database? Would you mind pasting your code so I have an example to follow?
Thanks a million!!!

 

[TheAceMan1]

DaveyEdgar . . .

Its my opinion its a waste of time to build a menu/command bar in code. [blue]Espcially since its so easy to make the bar manually and set it as the default in startup! . . .[/blue]

See Ya! . . . . . .