Popup Menu's in Access 2010

I have been developing in Access for over 10 years but all of the development was done using Access 2003 or older versions.

I use right click popup/shortcut menu's extensively in all of my projects.  They are context sensitive, at least to the form/report level.  They are super easy to put together and I think serve as great navigational tools for the user.  "When in doubt, right click and see what options are available."

Most of my forms have custom menu's in the  'Shortcut Menu' property.

It is my understanding that this feature has been eliminated in any new development done in Access 2010 or higher, maybe even 2007 and higher.  I have also read and seen for myself that the feature is supported on any projects converted to the 2010 format from an older version.  However no changes can be made to existing popup menu's and no new popup menu's can be created.

First of all, is this true?  Have popup menu's been eliminated.

Secondly, if true, I am interested to know what EE developers that have made a similar transition are using in place of these 'right mouse click' popup menu's.
Who is Participating?
Gustav BrockConnect With a Mentor CIOCommented:
I had the exact same question:

Access 2010: Create custom popup menu to run custom functions

Jeffrey CoachmanMIS LiasonCommented:
Not really an answer...
...I never really used custom right-clicks or custom menu bars for that matter.

I tried to build everything I needed on the form directly.
Thus I could hide all the Access toolbars/icons/...etc

This strategy has served me well when I moved to 2007-2013. My apps needed almost no changes.

I know the ribbon is slick, ...but the time I would have to spend learning how to make one work, is time I could spend making a better interface on the form...

Obviously there are always exceptions,...

Lets here the thoughts of other experts....


DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
I am intimately familiar with the subject. All professional applications on the planet make extensive use of popup (aka right click menus, aka context menus and so on).

"Have popup menu's been eliminated."
No. Popup menus are still supported in ALL versions of Access. However, starting in A2007 - because of the Ribbon paradigm, there is no built in tool, like the beloved Customize Dialog in <=A2003.
In >=A2007, the CommandBars collection is still alive and well. Consequently, you are relegated to using VBA to create/add new popups and edit existing popups, which I have been doing for some time now.

I'm am not aware of any tool at this point to create/modify popups in >=A2007.

That's the story ... plain and simple.

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
I agree that the right-click menus are a great UI feature and should be used often.

As MX pointed pout is it still possible with Access 2007 and later. You have to use macros and/or VBA code to create and modify them.

How to use a macro see:

Create custom menus and shortcut menus by using macros

[Edited by SouthMod to remove invalid link]
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"Create custom menus and shortcut menus by using macros'
well, that's true. However, I left that out because I refuse to use macros for this. And VBA code is infinitely more flexible in this regard.

But thanks for pointing that out.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:

I agree that for VBA coders using VBA is infinitely more flexible in this regard.

For the non-coder. Macros can be easier and powerful enough to get the job done.
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Yep ... that's pretty much it :-)
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPConnect With a Mentor Commented:
@SouthMod, There were two link that you removed.

Is this better SouthMod?

Here is a direct link to the  Microsoft MSDN article:

How to: Create a Shortcut Menu for a Form, Form Control, or Report

When you're designing a form or report, you may want to provide a method for a user to easily use a command that applies only to the currect context. One way to do this is to create a custom shortcut menu and apply it to a form report, or control. The shortcut menu appears when the user right-clicks the object to which the shortcut menu is applied.

In earlier versions of Access, you could use the Customize dialog box to create custom shortcut menus. In Microsoft Office Access 2007, you must use Visual Basic for Applications (VBA) code to create a shortcut menu. This article describes you how to create a shortcut menu using VBA.

To create an shortcut menu, you first have to create aCommandBar object. The CommandBar object represents the shortcut menu. Then, you use the Add method to create CommandBarControl objects. Each time that you create a CommandBarControl object, a command is added to the shortcut menu.

I did not realize you could not post links to examples on other sites that are relevant to the subject.  Is it OK to post the example as an attachment?
mlcktmguyAuthor Commented:
Excellent, exactly what I needed.  I'm used to coding in VBA so that is the option I will use but nice to know there is a Macro option.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.