Solved

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

Posted on 2010-11-17
7
554 Views
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.
0
Comment
Question by:Methos
  • 4
  • 3
7 Comments
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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.

http://www.jamiessoftware.tk/articles/menubars.html

All of my custom menus are created in this manner.

mx

0
 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
Also, this appears to be one of the more popular A2010 Ribbon tools:

http://www.accessribbon.de/en/

mx
0
 

Author Comment

by:Methos
Comment Utility
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

0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 
LVL 75

Expert Comment

by:DatabaseMX (Joe Anderson - Access MVP)
Comment Utility
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 ?

mx
0
 

Author Comment

by:Methos
Comment Utility
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".
0
 

Accepted Solution

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

Author Closing Comment

by:Methos
Comment Utility
Didn't get an answer that worked, so I created my own solution.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server functions 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 Microsoft Ac…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

743 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