Buttons on a report

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

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

Robert
 
Robert said:
Is there any way to put a command button on the toolbar of a report (or
anywhere else on the report)?
Click to expand...


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.
 
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.
 
Thanks. I will give it a try.


Marshall Barton said:
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]


Robert said:
Thank you. How do I create the custom tool/menu bar?
Click to expand...
Click to expand...
 
Thanks. I'll give it a try.
Marshall Barton said:
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]


Robert said:
Thank you. How do I create the custom tool/menu bar?
Click to expand...
Click to expand...
 
Back
Top