[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2188
  • Last Modified:

In Access 2010, edit existing Shortcut Menu Bar (context menu) carried over from Access 2003

A year or so ago, I converted an Access 2003 (.mdb) database to Access 2010 (.accdb).  I had created a Shortcut Menu Bar (right-click context menu) in the original database that would open and expose a number of processing options when right-clicking on certain text boxes.  That menu works just fine in the new Access 2010 version, and appears in a list (with other similar shortcut menus, under File >> Options >> Current Database >> Shortcut Menu Bar.  The name of the Shortcut Menu Bar is MoveInv (for move inventory).

I now need to edit the MoveInv Shortcut Menu Bar, but, although it is present and functional, I cannot find it anywhere that would allow it to be opened and edited.  Is it somehow now hidden in some kind of compiled, inaccessible, uneditable state?  Do I need to start over from scratch and try to figure out how to code this in VBA?  

Thanks for your help.
1 Solution
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
No can do.  It's absolutely MADDENING that Microsoft did NOT provide a tool to edit existing menu bars, including Right Click menus. Your only option is to do it in A2003, then import the bars.

OR ... create then in VBA code using the CommandBars collection.

AutomateMyOfficeAuthor Commented:
Had to take the approach suggested, modifying the menu bar in an environment where I happened to have A2003 installed.  Sadly, once that goes away, my options will be quite limited.  Thanks.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now