Add a Customised ToolBar to a Report in Access97 1

[jojones]

Having problems adding a customised toolbar to an Access report and form. Does anyone have some code that will create a toolbar with at least one button on it, perhaps one standard Print button and one customised macro button.

Cheers
Jo

 

[tomschafer]

You have to first create the toolbar by going to the View menu, then toolbars then customize. Click new, give it a name and then drag some commands on to it from the commands window. Then you can use DoCmd.ShowToolbar "NewToolbarName", acToolbarYes

 

[jojones]

Thanks Pezamystik

What if I want to add my own buttons which run procedures or functions I have written?

Cheers
Jo Cheers
Jo Jones

 

[tomschafer]

You'd have to have a macro first. You can add macros to your new custom toolbar. But not VBA code directly. So create a new macro that uses the RunCode function to call your VBA. Then under the commands tab of the customize window there is a menu called All Macros click that and search for your macro. Good Luck!