Make custom toolbar in Access 2002

[PeDa]

In Access 97 I used the Toolbar Wizard to make my custom toolbars. Access 2002 seems not to have this wizard. Can somebody tell me how to program a toolbar; the so-called Help is fragemented and ununderstandable.

Thanks in advance.

 

[melaniews]

Have you created the toolbar? That's a right click on any toolbar and click on customize. Write back if you need more help there.

Once the toolbar is created, it is assigned on the "other tab" of the form properties. You can also set toolbars to load automatically on database startup.

hth
Melanie

 

[PeDa]

Melanie,

Thanks, but I need to do more than what you can do with that "customise"; the items on my toolbar (a menu) open new forms, generate reports, run module code etc. I need to alter the names of forms, reports or functions, add and remove items etc. I think it will be easiest to make a program which deletes the old menu and makes a new one using commands like ( think)
Set MyButton = CommandBars("MyMenu&quot.Controls.Add
and
CommandBars("MyMenu&quot.Controls("MyButton&quot.OnAction=...

What would be realy helpful is a code fragment to build a menu from scratch.

Best wishes,

 

[gerard1979]

Hi Peda,

I'm not sure what u want but I think you don't need code
Click right mouse btn on the custom bar in top of the access
Make a new one (choosing menu or custom bar, custom = buttons, menu = menu's
Than u can drag and drop all sort of code in it. Can make macro's to drop in it, also can make functions to drop.
U can customize the buttons, and so on and so on.
I build very nice menu's in this way, only when u need to make btn's enabled, invisible, variable then u maybe need a piece of code.
Hope this help u a bit furher
Always come back when i'm not clear, my English isn't very well, but I give another, more detailed try when u need

Gerard

 

[PeDa]

Gerard (and Melanie)

Yes indeed; I hadn't realised what can be done with the "Custom" option on the "Commands" tab of the "Customise" dialog. I found a good decription of how it works at:

http://www.google.com/search?q=cach...cess+2002"+"context-sensitive"&hl=nl&ie=UTF-8

Thanks again, I'm back in action now.

Peter Davis