Methos
asked on
Access 2003 Legacy DB - Custom VBA Menu Won't Run in 2010
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.
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.
Also, this appears to be one of the more popular A2010 Ribbon tools:
http://www.accessribbon.de/en/
mx
http://www.accessribbon.de/en/
mx
ASKER
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
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
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
So, you 'see' this toolbar? But you cannot click anything on it ?
mx
ASKER
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".
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".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Didn't get an answer that worked, so I created my own solution.
http://www.jamiessoftware.tk/articles/menubars.html
All of my custom menus are created in this manner.
mx