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.
LVL 1
mlcktmguyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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....

;-)

JeffCoachman
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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.

mx
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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
http://office.microsoft.com/en-us/access-help/create-custom-menus-and-shortcut-menus-by-using-macros-HA010282509.aspx

[Edited by SouthMod to remove invalid link]
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
"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.

mx
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
MX,

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.
0
Gustav BrockCIOCommented:
I had the exact same question:

Access 2010: Create custom popup menu to run custom functions

/gustav
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Yep ... that's pretty much it :-)
0
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
@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
http://msdn.microsoft.com/en-us/library/office/ee336038%28v=office.12%29.aspx

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?
0
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.