Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2010-11-17
7
Medium Priority
?
576 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
Industry Leaders: 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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

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…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

971 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