Solved

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

Posted on 2010-11-17
7
556 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
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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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