Specify Printer Destination

[ICCIIT]

In a module I have a standard Docmd to print a suite of reports using

DoCmd.OpenReport "rptMyReport"

If I run this code it naturally outputs to my default printer or the "Specified" printer within the report page options.

Is it possible to adapt the Docmd or add some code in the module to specify a printer but still leave the main report page settings as default printer?

Thanks

 

[genomon]

If you are using Acc2002 or greater, see here:

http://msdn2.microsoft.com/en-us/library/Aa139946(office.10).aspx

An làmb a bheir, ‘s i a gheibh.

 

[assets]

Yes you can us VB to select the printer and tray.

Never give up never give in.

There are no short cuts to anything worth doing

 

[ajrimmer]

This is getting old but shows how to change printer.

http://www.members.shaw.ca/AlbertKallal/msaccess/printch2k.zip