VirtualKansas
asked on
Access 2013: Customize sub-menu for reports
Reworking a legacy Access database. Found the opportunity to improve performance of many reports. One change was to set the reports to pop up = yes. Makes them easier to see and work with; many are several hundred pages long.
Challenge is the right click menu has functions we don't want exposed to user and functions we used to get on the ribbon are not available in ribbon or right click menu. Best example is the Save As option in right click menu of a pop up style form. The default in Save As is to save a copy of the Access report, not a copy of the report info. for example save as a .pdf which is something we use regularly.
How to either customize the right click memo in pop up report, or alternatively get the ribbon functions operating on the pop up view, to allow print and save as .pdf functions back in front of users?
Challenge is the right click menu has functions we don't want exposed to user and functions we used to get on the ribbon are not available in ribbon or right click menu. Best example is the Save As option in right click menu of a pop up style form. The default in Save As is to save a copy of the Access report, not a copy of the report info. for example save as a .pdf which is something we use regularly.
How to either customize the right click memo in pop up report, or alternatively get the ribbon functions operating on the pop up view, to allow print and save as .pdf functions back in front of users?
Scott McDaniel (EE MVE )
Is this the web app you've been working on? Or a desktop database?
ASKER
Desktop
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did find this article, and another: http://msdn.microsoft.com/en-us/library/office/ff194247%28v=office.15%29.aspx using VBA instead of macros.
Got stumped on the initialization of the CommandBar, just a bit out of my league, I guess. Had to drop back after a day and get back to other tasks.
This one is a minor nicety that we will value, when we crack the code. Other pressing matters came up with the web app. back end. I'll get back to this one with your advice and my thanks...
Got stumped on the initialization of the CommandBar, just a bit out of my league, I guess. Had to drop back after a day and get back to other tasks.
This one is a minor nicety that we will value, when we crack the code. Other pressing matters came up with the web app. back end. I'll get back to this one with your advice and my thanks...
Trouble with using VBA is there is no GUI for doing this, which can be troublesome for novice developers. Long as it works, however ...