Re: Systemically OutPut Access Report To PDF

From: Mark C (hereinde_at_yahoo.com)
Date: 07/23/04 

Date: Thu, 22 Jul 2004 22:17:00 -0700

I would differently like a copy of that sample database. I have talked to
the big bosses at my company and we have decided to go with the
http://ourworld.compuserve.com/homepages/attac-cg/acgsoft.htm method. I
downloaded and tested the Access 2000 version and it works wonderfully with
no user interaction other then them clicking a button. Sometimes you just
have to admit defeat.

Regards,
Mark C.
hereinde@yahoo.com

"dgs5150" <dgs5150@yahoo.com> wrote in message
news:526ed05a.0407190655.35d8046d@posting.google.com...
> "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.