Automate creating an adobe report from Access 2003

By rrrycraft ·
I am using MS-Access 2003 and have Acrobat 8 Professional (and Distiller. I have several reports that I open and convert to Adobe PDF files. I want to use code to automate this process. I know the names of the reports and I know the folder where I want them. The default name for the report(s) is fine. Can it be done "EASILY"?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -


by clarkd038 In reply to Automate creating an adob ...

You could create a macro, that opens the report after it is created, using the "OpenReport" command in the Action tab. Then down below you can see it gives you the report name, enter the report that you want to change to PDF, and below that go to the view, and enter Print.
From there when you run the macro it will allow you to choose a printer, and just choose the Adobe PDF printer.

Hope this helps

Collapse -

Did not work

by rrrycraft In reply to Print

It did not ask me what printer I wanted, it just used the default. Thanks very much for trying!. What I really want to do is have it run unattended, thats why I wanted to use code.

Related Discussions

Related Forums