Hi there

Has anyone out there figured out how to automate the process of printing Access reports to pdf (Acrobat Reader) format?

Cheers
Anish

If you install Adobe Acrobat, it will install "virtual" printers named Acrobat Distiller and PDFWriter. Sending report output to either of these "printers" will create a PDF file. Note that PDFWriter is for use with reports that contain only text, while distiller will handle images as well.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks for that Jeff. I've got the virtual drivers setup. I somehow need to automate the report printing to pdf in VBA.

I've got a report setup up where I pass a ClientID as a parameter to generate a report. I've got about 50 clients and was thinking of writing code that could save the pdf file under each client name, and loop through all 50 clients.

keshavan01,
I'm just wonder if you have the solution of how to do this. I am having the same problem. I couldn't automatically sending the Access report to the PDF virtual printer. It asked me to enter the file nam every time. if you could send me the solution I would very appreciated
thanks

I have exactly the same problem - if anyone comes up with the solution - I will be thrilled !. At present I generate them as .snp reports and then when you one those and print to a Virtual printer it has the name there with the directory which you have to change - not ideal but a stop gap measure.

Well, I know that these registry settings can be used with some versions, but I don't think all. You can change them each time you print based on your reports:

Names the file:
HKCU\Software\Adobe\Acrobat\PDFWriter, PDFileName, C:\YourReport.pdf

Prevents file naming dialog from appearing:
HKCU\Software\Adobe\Acrobat\PDFWriter, bExecViewer, 0

Also, this will prevent the dialog in V6:
HKCU\Software\Adobe\Acrobat\PDFMaker\6.0\Global\Se ttings\PromptForPDFFilename, 0

You can make registry settings from within Access. Don't forget to set them back when you are done printing.

Then if you want to name your files, you could capture all your client IDs, then use the UBound for a loop counter, and then loop through all their names, use their names to name the files, and then maybe append a date as part of the filename, etc.

I hope this will get you started. In can be done.


mmcdonal