Printing Access Report With PDF-XChange

[Aidy680]

I'm trying to automate the printing of an Access report using PDF-XChange 3.0.

Although the code I have works fine with a "Adobe PDF" printer, if a user has the former on their machine, the code prompts them with a Save dialog on the following line:

DoCmd.OpenReport strReportName, acViewNormal

Does anyone know what I can do so that this dialog doesn't appear???

 

[Aidy680]

By way of a follow-up note that PDF-XChange 3.0 doesn't support automation from Access. I'm using Acrobat Standard v.7 instead which works.

 

[mp9]

You may find this useful, as it discusses programmatically changing default print queues in Access, specifically to facilitate printing to a PDF queue.

http://www22.brinkster.com/accessory/modules/009.shtml