Software

Ask something
Question Locked

Automate creating an adobe report from Access 2003

0 helpful
3 replies

by rrrycraft

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am using MS-Access 2003 and have Acrobat 8 Professional (and Distiller8). 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"?

3 replies

by clarkd038

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

by rrrycraft

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.

This discussion is closed to new replies.