Burt

B

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
 
A

Allen Browne

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

What's wrong with the toolbar buttons?
 
B

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
Click to expand...
option to print or cancel.

Burt
 
A

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.
 
B

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
Click to expand...
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
 
A

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.
 
B

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.
Click to expand...

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

Burt
 
S

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
 
Top