New Forum | Previous | Next | (P-PDF) Developers
Topic: Automate report to PDF file save, name to directory (Via Email)
Conf: (P-PDF) Developers, Msg: 32691
From: Deleted User
Date: 1/12/2002 03:00 AM
This is my first time using the list and I'm hoping that someone can please
I am working on a reporting system built in Access 2000 (VBA) on a Windows
2000 machine, it prints or previews over 10 different reports based on
The code programatically opens each report as below:
DoCmd.OpenReport "rptDom_SXM", acViewPreview, , strWhere
DoCmd.OpenReport "rptDom_SXM", acViewNormal, , strWhere
I want to automate running Access reports,
saving each one run to a adobe .pdf file (using Acrobat Distiller)
I know that I can manually print to the acrobat distiller driver, type in
the file name and directory to save it to but I want this automated.
*** depending on the report that I run, and other criteria
(i.e. client name, account) I need to save each report, to a .pdf
file in a specified folder, and given a unique file name.
I've received some from initial help with examples using PDFWriter on
Windows 95 however I would like to use Distiller for .eps files that the MS
Access reports may need to use in the future (maybe I could change them to
..bmp - if it doesn't make a huge difference .. anyway). There seems to be a
variety of ways to accomplish what I want to do but nothing that is very cut
and dry. Should I use a windows api or acrobat distiller api for this? Am
I overcomplicating things? What is the best way to do this?
Any help would be much appreciated!
If it would help, you can also contact me on
AIM screen name is lorin1life