I am trying to generate PDF files using Access and VBA. I am close but am not sure if there is an easy way to do this?
Thanks
Bill

You can probably do it easily using the Print and Printer methods and by selecting Adobe Acrobat Distiller as your printer ID.

Basically, if you define your printer object and know the name of your Adobe Acrobat Distiller printer, you can set that name to strPrinter and do something like this:

rptReport.Printer = Application.Printers(strPrinter)

Then the DoCmd.OpenReport will print to the PDF.

You'll have to have Adobe Acrobat (the writer, not the reader) or your PDF-making software installed for this to work. Search help on the .Printer and .Printers methods for more details on syntax.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks for the reply Greg.
With your help I was albe to solve the problem
Bill

Have you found a method to send the desired filename to the pdf software so that the pdf file can be "printed" and saved from VBA, without user interaction?

Thanks.