Access 2003 Legacy DB - Custom VBA Menu Won't Run in 2010

Posted on 2010-11-17
Medium Priority
Last Modified: 2013-11-05
I have an Access 2003 application that has a custom main menu created in the VBA code.  I'm trying to get it to run in Access 2010.  The menu usually comes up at startup in a main page.  It does come up, but I cannot click or do anything.  

This is not an app I wrote and the people who wrote the app have gone away.  I support it and know some about how it was put together, but not everything.

I have tried a few things such as adding the database location as a trusted directory, told it to trust all macros.enabled active-x and took it out of safe mode.
Question by:Methos
  • 4
  • 3
LVL 75
ID: 34157659
Not sure vba generated A2003 menus are going to work in A2010, since the entire menu paradigm is now the Ribbon/XML.  IF ... you create menus (in A2003) using the concept of the link below, those *will* appear on the Add-In Ribbon in A2010.


All of my custom menus are created in this manner.


LVL 75
ID: 34157670
Also, this appears to be one of the more popular A2010 Ribbon tools:



Author Comment

ID: 34157983
How would I know if they used that method - opening the mdb in Access 2003?

From what I can tell from the design view of the main form that comes up, this form basically runs off VBA code running from the "OnLoad" and "OnActivate" event procedures that call things like:

DoCmd.RunMacro "Program Startup" and DoCmd.ShowToolbar "Program Toolbar" acToolbarYes

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

LVL 75
ID: 34158040
ok ... well, I assumed they were manipulating the CommandBars object.  The code above implies that a 'Program Toolbar' exists, most likely created by the method in the article.  

So, you 'see' this toolbar?  But you cannot click anything on it ?


Author Comment

ID: 34158083
That's right - it shows up but nothing can be clicked on.

Is a toolbar held in a separate file outside Access?

When I look at Current Database Options, Ribbon & Toolbar Options... I see the Menu Bar named "Program Main Menu".

Accepted Solution

Methos earned 0 total points
ID: 36230111
Solved by creating my own interface instead of fixing legacy code.

Author Closing Comment

ID: 36253558
Didn't get an answer that worked, so I created my own solution.

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

600 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