Automate report export (to PDF)

[SF]

Hi,

I have about 150 contracts in Access report form to be exported to PDF.
Normally, I have to click on the Contract Number on the form, Preview it and
then Print to Adobe PDF, type the Contract Number and specified where to
Save this file.


I am looking for a way to automate this process above where I can save those
PDF file in a specified folder and given a name using Contract Number.

SF

 

[Steve Schapel]

SF,

I use PDF995. This has an option to save all files produced to a
default file path/name, so you don't have to enter it at the time.
Maybe Adobe has something similar, I don't know. But with this type of
option, the proces can be completely automated. Via the File|Page Setup
menu, set the PDF driver as the printer for the report. Then you can
just use code with DoCmd.OpenReport method to print to the default file,
and then Name method to rename the pdf file just produced to the
contract number-based name. This can be enclosed within looping code to
process all the contracts in one hit.

 

[Mark Andrews]

We sell a batch reporting module to create batches of reports to PDF files.

http://www.rptsoftware.com

We give you the source code. It basically wraps up everything into nice
little functions to create a pdf file where you pass in the filename,
report, criteria or sql for report etc.... and it makes the pdf. Works best
with win2pdf printer driver.

Mark
RPT Software
http://www.rptsoftware.com