?
Solved

Access 2013: Customize sub-menu for reports

Posted on 2014-09-18
5
Medium Priority
?
482 Views
Last Modified: 2014-09-18
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?
0
Comment
Question by:VirtualKansas
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 85
ID: 40330160
Is this the web app you've been working on? Or a desktop database?
0
 

Author Comment

by:VirtualKansas
ID: 40330508
Desktop
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40330960
Here's a MSFT article about creating rightclick menus in 2007:

http://office.microsoft.com/en-us/access-help/create-custom-menus-and-shortcut-menus-by-using-macros-HA010282509.aspx

Basically, you create a Macro Group for the commands you want to include in your Rightclick menu, then save that Macro group. Then, you create a second macro that calls the AddMenu action, and point that the MacroGroup you created earlier.

Next, you open the Object in Design view, and add the second Macro you created to the "Addins" tab of that item.

Finally, you set the Shortcut Menubar property of the object you want to associate with that right click menu.
0
 

Author Closing Comment

by:VirtualKansas
ID: 40331310
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...
0
 
LVL 85
ID: 40331387
Trouble with using VBA is there is no GUI for doing this, which can be troublesome for novice developers. Long as it works, however ...
0

Featured Post

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question