Print a report to a specific printer from VBA

[myhnews]

I have a report theta I would like to print to a specific printer, but I don’t want to select the printer from the dropdown each time I print this report.

Can anyone please help me with this?

Thanks
Joe

 

[___]

The easiest way would be to select the printer from the reports page setup. Goto file >> page setup, select the page tab and check 'use specific printer'. Select the required printer.

HTH

 

[myhnews]

Thanks

Is there a way to have this done in code (VBA)??

 

[robthedog]

Have a look at the following which may help

http://www.access-programmers.co.uk/forums/showthread.php?p=344568#post344568