How To print Access reports in a desired printer

[AJ]

Hi Guys,
I have to print access reports in acrobat distiller but it is not
my default printer.So when i use docmd.openreport the report is fired
on some other (default) Printer. I cannot change the default printer
settings. So how do i fire the report so that it uses acrobat
distiller.

Thanx
AJ

 

[UpRider]

AJ, if you're using Access 2000 or greater, try this:

DoCmd.OpenReport "YourReportName, acViewPreview
Application.Reports("YourReportName").Printer =
Application.Printers("PDFprinterName")

Substitute appropriate names for "YourReportName" and "PDFprinterName".

HTH, UpRider

 

[AJ]

thanx a ton uprider i will try this

AJ, if you're using Access 2000 or greater, try this:

DoCmd.OpenReport "YourReportName, acViewPreview
Application.Reports("YourReportName").Printer =
Application.Printers("PDFprinterName")

Substitute appropriate names for "YourReportName" and "PDFprinterName".

HTH, UpRider