Modify Legacy (2003) Custom Menu/Toolbar in Access 2007

[CWestII]

I have a database that was created in Access 2003. I have since switched over to Access 2007. The Menu / Toolbars show under the Add-ins Tab now. That is not a problem.

I need to make changes to these custom Menus / Toolbars. In Access 2007, it is not very clear as how to perform the desired changes.

Does anybody know how to modify these legacy items?

Thanks!

 

[Remou]

Do these items appear in the USysRibbons system table?

http://lessthandot.com

 

[CWestII]

No, I have not created that table. These were existing toolbars that were created when it was a 2003 application. The system automatically put them in the add-ins portion.

 

[Remou]

So, the choices you have for modifying menu bars in 2007 are quite limited.
I suggest you either;

a) use 2003 to change the menus
b) use VBA code to modify the menus
c) replace the menus with ribbons

The above choices are not ideal. However, there is no user graphical
interface in 2007 that lets you edit menus graphically."

--

http://www.eggheadcafe.com/software/aspnet/35479249/access-2007-how-to-edit.aspx

http://lessthandot.com

 

[CWestII]

Thanks! I'll probably have to do it with VBA considering this information.

 

[Lilliabeth]

You can edit the Ribbon in version 2010... Add new tabs, etc.

--Lilliabeth