Printing from Print Preview

N

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
 
F

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

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

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
 
V

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)
 
M

mscertified

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
 
V

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

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
 
V

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