Buttons on a report

[Robert]

Is there any way to put a command button on the toolbar of a report (or
anywhere else on the report)?

Robert

 

[Marshall Barton]

Is there any way to put a command button on the toolbar of a report (or
anywhere else on the report)?

Not on the report.

But you can create a custom tool/menu bar and put whatever
you want on it. Set the report's ToolBar or MenuBar
property to the tool/menu bar's caption to make it appear
whenever the report preview opens.

 

[Robert]

Thank you. How do I create the custom tool/menu bar?

 

[Marshall Barton]

Right click on an existing tool/menu bar and select
Customize...

Then create a ***new*** bar (don't mess with the existing
tool/menu bars) and play around with adding commandbar
controls to achieve the effect you want. VBA Help on Create
a toolbar should get you started.

To run your own code from a toolbar button, put the code in
a public function in a standard module and set the button's
OnAction property to the function name.

 

[Robert]

Thanks. I will give it a try.

Right click on an existing tool/menu bar and select
Customize...

Then create a ***new*** bar (don't mess with the existing
tool/menu bars) and play around with adding commandbar
controls to achieve the effect you want. VBA Help on Create
a toolbar should get you started.

To run your own code from a toolbar button, put the code in
a public function in a standard module and set the button's
OnAction property to the function name.
--
Marsh
MVP [MS Access]

Thank you. How do I create the custom tool/menu bar?

 

[Robert]

Thanks. I'll give it a try.

Right click on an existing tool/menu bar and select
Customize...

Then create a ***new*** bar (don't mess with the existing
tool/menu bars) and play around with adding commandbar
controls to achieve the effect you want. VBA Help on Create
a toolbar should get you started.

To run your own code from a toolbar button, put the code in
a public function in a standard module and set the button's
OnAction property to the function name.
--
Marsh
MVP [MS Access]

Thank you. How do I create the custom tool/menu bar?