Editing Custom Toolbars

I am using Access 2K7 to support an Access 2003 database (the user has only
A2K3). The database has a custom toolbar/menu which shows up in my A2K7 as
an "Add In".

I need to modify the choices on the toolbar/menu, but have been unable to
figure out how to get the toolbar into an edit mode. I'm beginning to think
that the only answer is to uninstall A2k7 and replace it with A2k3. Is there
any less traumatic way of editing the tool bar items?
Thanks...Papa Behr

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/ac...CH100621911033

using code, some examples he
http://blogs.msdn.com/access/archive...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.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada