There not a way to edit the menu bars from the UI in 2007.
However, you can certainly write code to manipulate the menu bars. In fact,
a good deal of the examples posted always did use code, and I always for one
generally used the menu bars and UI to create mine.
However, in 2007 you can write macros that will create menu bars for you.
This feature is most useful for creating right click menu bars.
So, if this is just a simple menu bar, then I would just delete it
from the debug window you can go:
commandbars("name of command bar to delete").Delete
I would then simply re-create these features using a ribbon. Once you built
one ribbon, then creating and modifying it is easier then what it was in
previous versions..
And, if you don't want a ribbon,, you could still delete the above menu bar
and use code to create a new menu bar at load time.
Using macros, how is explained here
http://office.microsoft.com/en-us/access/HA102825091033.aspx?pid=CH100621911033
using code, some examples here:
http://blogs.msdn.com/access/archiv...t-menu-for-a-form-form-control-or-report.aspx
The above is for shortcut menus, but the code examples are useful for
standard menus also.
If you're in a situation where you have to support previous clients are
previous versions of access, probably that case it makes a lot of sense to
just simply go ahead and install access 2003 on your machine. note that you
can have multiple versions of access on your machine installed, and they
coexist quite well together.
A good many developers have 2, 3 or even 4 versions of access installed on
their computers. For example I'm currently running both access 2003 and 2007
on my computer. I don't see any need a reason to uninstall 2007, but if you
need features of previous versions of applications that you don't have, then
do consider installing the appropriate software you need to get your job
done.
At the end of the day, however I think I would spend the time and create a
ribbon, once you've created one ribbon, then after that ribbon creating
becomes a simple cut + paste affair. In fact your find that you can
generally you can create ribbons faster than menu bars by this means.
