Please describe the exact steps required to use a compiled Access 2003 mdb with the Access 2007 runtime and retain my custom menus and toolbars so that they look the same as they did with the 2003 runtime. I've tried following the various incomplete instructions around the web, but I either end up with my menus/toolbars on the ribbon's ugly looking Add-ins tab, or they fail to appear altogether.
views:
102answers:
1
+2
A:
See Jeff Conrad's page How do I get my existing legacy menu bars and toolbars to work in Access 2007? Right now they all show up on the Add-Ins tab.
BTW the probably two best sites on converting to Access 2007 are http://allenbrowne.com/Access2007.html and http://accessjunkie.com/faq2007.aspx
Tony Toews
2009-10-07 20:25:26
This is one of the suggestions I already tried. It doesn't work. What you get from this is four copies of the toolbar and any menu option that matches an old Access menu option (like 'file') doesn't work when you click on it.
Ned Ryerson
2009-11-02 19:23:04
Something wierd is going on because that's worked fine for me. Mind you I don't use built in menus much so what I do is quite ismple.
Tony Toews
2009-11-02 20:01:57
I experimented with this a bit more. I have some startup code that enables or disables commandbar controls depending on user preferences and permissions. Accessing the Enabled and Visible properties of the Commandbar or its child controls causes duplicate menus and/or toolbars to appear. if I disable all of my startup logic related to the Commandbar object the instructions in the link you provided Do work. My apologies. Still, changing Commandbar Visible or Enabled properties should not cause my menus to duplicate. One problem solved and on to the next. Curse this wretched ribbon.
Ned Ryerson
2009-11-02 22:13:38
Excellent, glad to see you're making progress. As far as curses go, well, I had to chuckle, sorry.
Tony Toews
2009-11-02 22:40:17