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

Posted on 2012-08-20
Last Modified: 2012-09-03
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.
Question by:AutomateMyOffice
    LVL 75

    Accepted Solution

    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.


    Author Closing Comment

    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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    728 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now