The above is correct. If you have a mix of 2003, and 2007 users, then you
have to stick to using menus.
Just like a form in design mode, there is no code for that form (just a
bunch of numbers that hold the position of a text box on the screen...code
reads that information and displays the text boxes...so, there not code, but
only saving values that represent the form.
The same occurs for the menus. There is not code, but only entries in a
object that has those menu bars...
It is possible that the original developer did use code to create the custom
menu bars, but you would be easily able to see that code in the application
now. So, the developer might be using code now, but you would easily see
that code in the VBA code editor for a form or in the application startup
code that runs. So, I would just check/look at the startup code that runs
when the application starts up..if there is no menu bar code, then the
developers used the "customize" menus option and did not write code. Both
approaches were common, but if no code was used to create the menu bars,
then again for 2007 you not be able to use/modify that code because no code
So, to modify existing menu bars, or add, or remove buttons...you have to
resort back to using VBA code to make those changes. So, there is no
modify that particular object in question.
For 2007, to modify menu bars you have no other choice but to write code....
For example, you can write some VBA code to open a form up in design mode,
and add or remove a text box, however it is far more easy to use the form's
design tools and make the changes with the mouse in form's design mode.
In 2007, the menu bar design tools do not exist anymore, so you have to write
code to make changes to menu bars.
Since you supporting both 2007, and 2003, you really have to stick to the
lowest common system for development. There is tons of features in 2007 that
2003 does not have yet. (the ribbon is only one of many features new to
I think the best solution here would be to do all development in 2003 since
that is the lowest common system that you can expect users to have.
While going forward is easy for for most software systems, going back is
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada