Printing from Print Preview

[nChicago]

I have a button that prints a report to print preview.
Is there a way to put a button or icon on the report's preview window to
allow the user to print it?

Thanks for you help.

N

 

[fredg]

I have a button that prints a report to print preview.
Is there a way to put a button or icon on the report's preview window to
allow the user to print it?

Thanks for you help.

N

There already is one. It's the tool button with the icon that looks
like a printer.

 

[nChicago]

Thanks, Fred.
I'm trying to avoid adding the extra button.
Is there a way to add the print function to the actual print preview window?

Thanks.

N

 

[Van T. Dinh]

Extra button???

What Fred advised is that there is a Print command (with Printer icon)
already built into the *standard* "Print View" Toolbar (which normally
appears when you preview a Report). It is inbuilt, ready for use without
you having to do anything ... This sounds like the easiest and most
efficient to me so I am not sure why you want to do something else.

HTH
Van T. Dinh
MVP (Access)

 

[Guest]

You might want to do something else since that button does not allow the
selection of a printer. You can create a custom print preview toolbar that
does allow this.

Dorian

 

[Van T. Dinh]

Fair enough if there is a need to select the printer but the O.P. didn't say
so.

I also use a Pop-up Form on top of the Report for the custom Print button.

 

[nChicago]

Van, and MSC, what great ideas!!

How do I create a pop-up form on top of the report?
For that matter how do I create a custom tool bar?
Do I need to know VBA to do these things?

Thanks.

N

 

[Van T. Dinh]

(VBA is certainly the way to go but I guess it is possible with Macros).

Create a Pop-up Form with 2 CommandButtons: Print and Close.

In the code to open the Report (after the OpenReport statement), add the
code:

DoEvents
DoCmd.OpenForm ...

to open the CommandForm (Modal if you like). The Close Button should close
the Report *and* the CommandForm.

If you don't use Modal (and hence, the user can close the Report without
using the Close button on the CommandForm), you should code the Report_Close
Event to check whether the CommandForm is open and if it is, close it.