Printing reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Robert Ellis - 01 Apr 2006 17:01 GMT

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

Reply to this Message

Douglas J. Steele - 01 Apr 2006 17:15 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> Hi,
>
[quoted text clipped - 9 lines]
>
> Robert

Reply to this Message

Dennis - 03 Apr 2006 22:11 GMT

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.

> You could open the report in Preview mode, and the Printer Select dialog
> will appear when you select Print from the menu:
[quoted text clipped - 14 lines]
> >
> > Robert

Reply to this Message