Burt

[Burt]

Hi,

Is it possible to have command buttons come up on a report?

I am trying to give the user a choice of printing the
report or just canceling it without clicking on the close
control box.

Thanks in advance for your answer

Burt

 

[Allen Browne]

No, you cannot have a functioning command button on a report.

What's wrong with the toolbar buttons?

 

[Burt]

-----Original Message-----
No, you cannot have a functioning command button on a report.

What's wrong with the toolbar buttons?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.




.
The user asked if they can view the report and have the

option to print or cancel.

Burt

 

[Allen Browne]

So in report preview mode, do you see toolbar buttons for Print and Close?

That should satisfy the user, and does not require any work on your part.

 

[Burt]

-----Original Message-----
So in report preview mode, do you see toolbar buttons for Print and Close?

That should satisfy the user, and does not require any work on your part.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

"Burt" <[email protected]> replied in message


.
Actually I was explaining the user requirement more basic

then it actually is. The user, once they decide to print,
also wants to create a text file as well. I figured if I
can give them a command button, then whenever they click
it, I can put in whatever code I wanted to produce the
desired objective.

Burt

Burt

 

[Allen Browne]

Okay, so create your own toobar, with buttons that run your own functions or
macros, and do what you want with them.

BTW, if you are copying the built-in buttons onto your toolbar, be sure to
Ctrl+Drag them so as to copy them. If you just drag them over, you are
moving them from the built-in toolbars.

 

[Burt]

-----Original Message-----
Okay, so create your own toobar, with buttons that run your own functions or
macros, and do what you want with them.

BTW, if you are copying the built-in buttons onto your toolbar, be sure to
Ctrl+Drag them so as to copy them. If you just drag them over, you are
moving them from the built-in toolbars.

Thanks for your help and time. I'll look into that.

Burt

 

[Steve Huff]

You can't have it on the report, but what you can do is when the hit a
button to view the report -- have code that turns the report into a SNP file
and then have the SNP viewer show the report in a sub-form and then you can
have your own buttons on the main form doing whatever you want. It's
actually really slick.

--Steve Huff

 

[Arvin Meyer]

No, reports are static objects. What you can fo is open a form at the same
time, and use a dialog from that form to print or close.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access