If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Editing Custom Toolbars
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 |
Thread Tools | |
Display Modes | |
|
|