Rusty
Registered User.
- Local time
- Today, 15:59
- Joined
- Apr 15, 2004
- Messages
- 207
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:
Any help would be greatly appreciated.
Cheers,
Rusty

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!

I've managed to get rid of some of the other ones by using the coding below:
Code:
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

Last edited: