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.
Access Reports to PDF
- Thread starter TLW
- Start date
bleakcabal
Registered User.
- Local time
- Today, 16:19
- Joined
- Mar 19, 2002
- Messages
- 12
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.
David R
I know a few things...
- Local time
- Today, 10:19
- Joined
- Oct 23, 2001
- Messages
- 2,633
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
HTH,
David R
Similar threads
