Deactivating Main Menu Bar

[Rusty]

Hey Guys,

Is there any way of deactivating the main Menu Bar ("File","Edit","Insert","Format") when a form opens?

I need to implement this for a single form to stop an idiot user from trying to break the system! He's not doing it on purpose - he's just ignorant and doesn't listen or understand when I try to explain to him NOT to add a record by using the "Insert - new record" command, but to use the command button on the form which has some built in safety features (such as password protection).

I've managed to get rid of some of the other ones by using the coding below:

Application.CommandBars("Form View").Enabled = False
Application.CommandBars("Formatting (Form/Report)").Enabled = False
Application.CommandBars("Formatting (Page)").Enabled = False

Any help would be greatly appreciated.

Cheers,

Rusty

 

[Rich]

Why not just hide it?
DoCmd.ShowToolbar "Menu Bar", acToolbarNo

 

[Rusty]

Yeah, nice one Rich. That'll keep the buggers out!!

 

[ghudson]

tool bar, toolbar, menu bar

Check this out for a few more tricks... hide all Access tool bars and menu bars