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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printer Dialog Box 1
Syntax for number of copies to print? 1
Access change My Default Printer for All the Reports 4
Form Button won't print report 2
Time Delay to Print Report 2
Set Printer Problem 4
Can't get report to print 5
Print Button Code 2

Top