Re: Systemically OutPut Access Report To PDF

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: dgs5150 (dgs5150_at_yahoo.com)
Date: 07/19/04 

Date: 19 Jul 2004 07:55:34 -0700

"Mark C" <hereinde@yahoo.com> wrote in message news:<zNadnfBqe7DhU2TdRVn-vA@comcast.com>...
> All,
>
> I have exhaustingly been looking through the newsgroups in search of a way
> to systemically output an Access 97 report to a pdf file using the full
> version of Adobe Acrobat. I want the user to be able to click a button and
> have the Access report saved as a pdf in a directory specified by me the
> programmer.
>
> I have seen a posting by John Baker promoting a web-sight that has an mde
> that one can reference in any database but after 30 days requires a
> registration fee. Someone must have done some automation of this type. Any
> help would be much appreciated.
>
> Regards,
>
> Mark C.

Mark - I do have a sample access 97 database where I have put together
and automated the different components necessary to programattically
send an Access 97 report to a PDF file. This does require the full
version of Adobe Acrobat installed as custom because you need the
Acrobat PDFWriter printer that is not installed by default (at least
it was this way in Acrobat 5.0)

Here is an overview of what it does,
1. determine the current default printer
2. change the current printer to Acrobat PDF Writer
3. Modify the registry to save PDF to supplied path and document name
so PDF writer does not prompt for file name and location
4. change back to the default printer

If you are interested I can send you a copy.

Quantcast