Allowing Right Click Menus As Needed

[NEWSGROUPS]

I have a very large Access 2000 database that for security reasons years ago
I had disabled all right click menus at start up. I now have a need to
develop a form front end were I want the user to be able to use all the
mouse right click filter options (I.e. filter for, filter by selection, sort
ascending, sort descending etc...). Is there a way to turn this right click
menu on just for this form only? Any help would be greatly appreciated.



Best regards,
Mark

 

[boblarson]

Yes, you can and you can see how to do it right here:

http://www.btabdevelopment.com/main...rtcutmenuAccess20002003/tabid/62/Default.aspx


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________

 

[NEWSGROUPS]

Bob,
Thank you this is exactly what I needed. One other quick question if I may.
If I develop this in a test region and want to move this shortcut menu into
production how do I do this without moving all custom menus in the test
region to production?

Regards,
Mark

 

[Rick Brandt]

I have a very large Access 2000 database that for security reasons years ago I
had disabled all right click menus at start up. I now have a need to develop a
form front end were I want the user to be able to use all the mouse right click
filter options (I.e. filter for, filter by selection, sort ascending, sort
descending etc...). Is there a way to turn this right click menu on just for
this form only? Any help would be greatly appreciated.

Create your own shortcut menu containing the items you want on it then enter its
name in the shortcut menu property of either the form or on individual controls
on the form.

 

[Albert D. Kallal]

Bob,
Thank you this is exactly what I needed. One other quick question if I
may. If I develop this in a test region and want to move this shortcut
menu into production how do I do this without moving all custom menus in
the test region to production?

Unfortunately the importing of menus is an all or nothing deal. What this
means is that you either have to import all menus into the application, and
the delete everything. Often that's hard to know what to delete since you
might have existing menus already.

I would suggest that you simply create a blank the database and import all
the menus and then delete what you need, and *then* import that mdb with the
*one* into the new application. Not a very pretty solution, but it's about
the only one I have handy right now....