Access Reports to PDF

TLW

Registered User.
Local time
Today, 16:32
Joined
Aug 27, 2001
Messages
22
When I open a certain report, I would like to print that report and at the same time create a pdf file and save the pdf file in a specified directory. Does anyone know where to begin with this task. I have been told that VB code is the way to go. Can I create a macro that could accomplish this task? Any help is greatly appreciated.
 
The way I do it is I have Adode Distiller ( PDF Writer ) and after my report is created, I go in print and Distiller is listed as a printer, you select print in file and your report is now a pdf. I don't know how to automate it since PDF is Adode propriety format. Which makes it kinda of hard. Apart from that you could look into RTF which is more easy to work with.
 
Or you could use the Report Snapshot plug-in for Access, which saves a copy of the report with all formatting intact in its own file. However (much like PDF), your user will have to have the Snapshot viewer to read the report. Search the archives for 'report snapshot' for more information.

HTH,
David R
 

Users who are viewing this thread

Back
Top Bottom