Program a toolbar button

[Guest]

I've created an application within Access that on opening shows just a
switchboard form and the most basic menu and buttons available in Access.
When selecting a report (from a switchboard item, performing the OpenReport
method) it opens the reports in preview mode. The built-in buttons in the
toolbar only allow for "export to word" and "analyze with excel." I'd like
to add a button that would export to a "snapshot" version of the reports. Is
this possible since I've set the application to open with the bare-bones
menus and toolbars?

 

[Guest]

Sounds like you need to create a custom toolbar. First you need to create a
macro that will perform the action you want. After that's done
Click View, Toolbars, Customize, go to the Toolbars tab, click on New, name
it, it should show up on your screen as a blank toolbar. With the toolbar
customize menu still open, go to the Commands tab,choose All Macros, then
click and drag the macro you created onto your toolbar. To make changes to
the toolbar button, click on it so taht it has a box around it, on the
commands tab of the customize menu click on Modify Selection. After you 're
done with the toolbar close it. GO to your report in design mode, go to
report properties, set the Toolbar property to the name of your new toolbar.
You can add other buttins to the toolbar thru the customize menu. Hope this
helps.

Jim Burke

 

[Guest]

Thanks so much, Jim, it worked. These were great step-by-step instructions!