Printing reports

R

Robert Ellis

Hi,

Using MS Access 2003 on Windows XP

Opening report with DoCmd.OpenReport syntax

This always prints to my default printer (as set in Windows). How do I open
the printer dialog to allow the user to print to a specified printer?

Thanks,

Robert
 
D

Douglas J. Steele

You could open the report in Preview mode, and the Printer Select dialog
will appear when you select Print from the menu:

DoCmd.OpenReport "MyReport", acViewPreview
 
D

Dennis

In one application, I populated a listbox with available printers from the
client's O/S. He selectes the desired printer, and the report is printed to
that printer via a VBA statement. No other selections are part of the dialog
(page setup, etc). JUST the printer name.
 
Top