How to disable MSAcess Menu items

The attached is a simple technique on how to prevent users from clicking on any of the MSAccess menu items.

I use this technique in all my applications since I can then control the flow of the program and what users can/cannot click on.

It basically involves just opening a 'background' form, maximizing it, and then opening a popup/modal type form after that.

Notice in the example that you cannot click on any of the MSAccess menu items. You can thus control the flow of how user's open forms and what they can/cannot click on by designing popup/modal type forms.


Simple but effective.

.

Thank you for sharing pkstormy. Readers might want to know that probably don't want to set forms to modal in early stages of developing project. Modal forms can interfere with debugging VBA. I don't use macros so can't say if is an issue with them.

If you don't even want users to see the menu/ribbon, check out this thread http://forums.aspfree.com/microsoft...qat-303789.html

Good point June7.

I've always used msgbox's in my code to return values/troubleshoot code and don't really use the debug. Didn't realize this example protects from debugging as well.