Alternative Printer

[GUIDO22]

I wish to send a report to the PDF printer driver but DO NOT wish to switch the default printer settings. Having found some helpful code on this forum that changes the default printer to the PDF driver, prints the job and then reverts the default printer back to the original printer device.

I am still using Access '97 and although in the code, the default printer does revert back to what it was originally, the Default Printer status 'tick' no longer appears under Start/Settings/Printers.... Consequently, subsequent print jobs outside of Access go to another device and not my DEFAULT printer.......???

Any ideas would be gratefully appreciated.

Oh - in case I wasnt clear - I want to do this in code NOT using the Print dialog box.... !

 

[Oldsoftboss]

Is it a complex report? If not, create a copy and make that reports default printer the PDF driver. You could then either have 2 buttons on the form (if you have room) or open a popup form asking where to send the report (which report to print)

The reason for the question about the complex report is that changing a simple report twice is quite easy, but a complex form can see you stuffing around forever.

Then, no code at all is required.

Dave