Printer selection

[News]

Hi,

Does anybody know how to select a different printer then the default
printer when using the 'Print Report button wizard'

My form works fine, the button also, but i have several printers
installed on my pc. However the report i need to print from my
form needs to be printed on another printer.
When i now use the 'print report button' on my form, it directly
prints to my 'default-printer'.

Any idea's, solutions, suggestions are very much welcome.
Thanks in advance,

Arthur

 

[Allen Browne]

Method 1: Choose a specific printer as needed
==================================
Change your button so it opens the report in preview:
DoCmd.OpenReport "Report1", acViewPreview
Then choose Print from the File menu, and choose a printer.

Method 2: Make the report always to do a specific printer
=========================================
Open the report in design view.
Choose Page Setup from the File menu.
On the Page tab, choose Specific Printer.
Save the changes.
The report will remember to print to that printer.

Method 3: Have the report remember the printer it used last.
===========================================
See:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html

 

[News]

Great, Thanks for your Help,
Arthur.

Method 1: Choose a specific printer as needed
==================================
Change your button so it opens the report in preview:
DoCmd.OpenReport "Report1", acViewPreview
Then choose Print from the File menu, and choose a printer.

Method 2: Make the report always to do a specific printer
=========================================
Open the report in design view.
Choose Page Setup from the File menu.
On the Page tab, choose Specific Printer.
Save the changes.
The report will remember to print to that printer.

Method 3: Have the report remember the printer it used last.
===========================================
See:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html