locking the mouse

[buggy2]

I would like to lock 'the right click' button on the mouse while a form is open.

The reason for this is that if the user right clicks on the form when it is active, the design view option is still available and I dont want this to happen. I need the user to be forced to address my screen and have no option but to do so. (i.e. a modal screen) but this option will not work in the properties.

 

[Dugantrain]

I'm not sure about locking the mouse, but it sounds like you should convert your database to a MDE file. That way, the database is read-only and the user can only insert, update, and delete data and write queries.

 

[DRB]

To disable the right click on a form go to the Other tab of Properties and select No for Shortcut Menu. :P

You will also need to remove it from any toolbar that might show up. Or better yet disable all the built in toolbars in Access and create your own custome ones with only the buttons you want to make available.