Short cut menu in Access 2007 application migrated from Access 2003

Posted on 2012-08-16
Last Modified: 2012-08-16
Hello together,

I have a problem with an Access 2007 application. Some time ago the application were migrated from Access 2003 to Access 2007.

All works well, but I have following problem:

On some forms there are several shortcut menus. By click on  a item of the short cut menu, specific vba code is executed. The code is executed, but I can't find it. (and I want (have to) have a look at the code.

If I look in the properties of the form, I can found in tab "Others" at "Short Cut Menu Bar" then name of the menu bar: "MyCustomMenuBar", but if I search for it in the vba project I cannot find any peace of the code which is executed.

I can rember that I have seen that code in Access 2003. But unfortunately I have no computer with 2003 installed.

Please can you help me? Thanks a lot in advance and best regards

Question by:Hattl
    LVL 47

    Accepted Solution

    In the immediate window try this (all on one line)

    for each ctrl in commandbars("MyCustomMenubar").controls : debug.print ctrl.caption, ctrl.Onaction : next

    That should give you a list of the menu items and the functions which are being called when each item is clicked.

    Author Closing Comment

    Hi fyed,

    thank you very much for your help! That works for me.

    Best regards


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    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…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    745 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

    20 Experts available now in Live!

    Get 1:1 Help Now