Disable save?

[tylerg11]

I'd like to disable the Save button on my form for a compiled Access file. So the user would not be able to right-click on the form and click 'Save'. This is so that my customized save button on the form is forced to be used instead (there is certain code that needs to run when saved). Unless there is an event for this?

[June7]

You can disable the right click shortcut menu and ribbon tabs through database properties.

Office button > Access Options > Current Database > Ribbon and Toolbar Options

When you want to open the development db for modification, hold down the shift key while opening to override the above settings.

[ItsMe]

If you feel ambitious you can create custom menus from Tools\Customize from the main window.

Once you have a custom menu created, named, and saved you can assign it to a specific form. In the form's properties on the Other tab, there is a field for Shortcut Menu Bar. Your custom named tool bar should appear in the pull down. Because it is a Shortcut menu, this is your right mouse click menu.

Downfall is this custom menu is stored within Access as a macro. It does not transfer when you export your form to another DB. You have to recreate the menu, using the same name or remove the option from the properties within the form.

[June7]

Access 2007 and up don't have Tools/Customize. A bit more complicated to customize the ribbon.

[ItsMe]

Didn't know that. Thanks June7