atljarman
asked on
Access 2010 VBA Enable Right Click for Form Filter
I've developed an access database for a friend; I've attached a stripped down version to focus on the area. In the past when making access databases, I've like to hide all of the ribbons and database window from the user. I think it looks a little more professional and sometimes has security reasons (for those who are honest and just like to play around with things they are not supposed to) in doing so.
For this application, however, I need to make the right click available so that the user can filter the database values based on the form. If you hold shift down while opening the database, which in this case I want to allow, the toolbars and database window appear, you can open the form, and you can right click on the "title" field of the form and filter the data.
If you just double-click the application icon opening the database, the user can not filter the data. I have a macro in the background shutting down all of the toolbars and the database window. I have no idea however to skip the functionality to allow the form filter in this process.
I'm sure this is a fairly easy fix, but 3 days of googling and revising the VBA has not yet been successful. I realize now that I should have just asked here.
rightclickenabledneeded.accdb
For this application, however, I need to make the right click available so that the user can filter the database values based on the form. If you hold shift down while opening the database, which in this case I want to allow, the toolbars and database window appear, you can open the form, and you can right click on the "title" field of the form and filter the data.
If you just double-click the application icon opening the database, the user can not filter the data. I have a macro in the background shutting down all of the toolbars and the database window. I have no idea however to skip the functionality to allow the form filter in this process.
I'm sure this is a fairly easy fix, but 3 days of googling and revising the VBA has not yet been successful. I realize now that I should have just asked here.
rightclickenabledneeded.accdb
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
"For this application, however, I need to make the right click available so that the user can filter the database values based on the form. "
In A2010, you have two options (neither satisfactory):
1) Create your own custom Right Click menu (aka context aka PopUps) via VBA code using the CommandBars collection)
2) Create custom menus (right click, menu & tool bars) in A2003 first - using the Customize Dialog, then Import these into A2010. Custom menus will show up on the Add-Ins Ribbon, and Right Click will show up normally.
I've created 1000's of custom menus/toolbars/popups with the Customize Dialog - soooooo eash.
There is *no* built in tool in A2010 to create Right Click menus OR custom Ribbons for that matter.
This is the de-facto standard tool for creating custom Ribbons:
http://www.ribboncreator2010.de
I have this tool
In A2010, you have two options (neither satisfactory):
1) Create your own custom Right Click menu (aka context aka PopUps) via VBA code using the CommandBars collection)
2) Create custom menus (right click, menu & tool bars) in A2003 first - using the Customize Dialog, then Import these into A2010. Custom menus will show up on the Add-Ins Ribbon, and Right Click will show up normally.
I've created 1000's of custom menus/toolbars/popups with the Customize Dialog - soooooo eash.
There is *no* built in tool in A2010 to create Right Click menus OR custom Ribbons for that matter.
This is the de-facto standard tool for creating custom Ribbons:
http://www.ribboncreator2010.de
I have this tool
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Good ideas provided, but a working solution made available in the end so other users can download and repeat for their purposes as needed.
Maybe this helps
http://www.access-programmers.co.uk/forums/showthread.php?t=204203
Regards