Automate report export (to PDF)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SF - 29 Nov 2006 00:57 GMT

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

Reply to this Message

Steve Schapel - 29 Nov 2006 07:49 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> Hi,
>
[quoted text clipped - 7 lines]
>
> SF

Reply to this Message

Mark Andrews - 30 Nov 2006 19:15 GMT

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

> Hi,
>
[quoted text clipped - 7 lines]
>
> SF

Reply to this Message