Solved

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

Posted on 2010-11-17
7
558 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
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.

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

All of my custom menus are created in this manner.

mx

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

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

mx
0
 

Author Comment

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

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 ?

mx
0
 

Author Comment

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

Accepted Solution

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

Author Closing Comment

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

738 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