[AccessD] Report to PDF using CutePDF

Hi Rich

We have used FreePDF from:

  http://freepdfxp.de/fpxp.htm

The site is in German but FreePDF can be set to display English once
installed. It pops up a dialog window about what to do with your PS
file(s) to PDF creation. 

However, the greatest advantage of this utility is that it wraps the
Apple Postscript driver, which guarantees a 100% compatible Postscript
output file, and feeds this to Ghostscript for conversion to PDF.

I have had some problems with the various PDF printers around - free
or not - but this combination works just fine.

As Ghostscript basically is command line driven, I guess it somehow
should be possible to print to the Apple writer, output to PS file(s),
and convert PS file(s) to PDF by Ghostscript - all under control from
Access. 

Unfortunately, I have no time for playing with this now ...

/gustav


> Environment is Access 2002 (XP), Windows 2000 and Windows XP Pro mixed
> environment.

> I was wondering if anyone out there has any tips or tricks on how to
> automate the creation of a report into a PDF document using CutePDF.  We
> also have PDF-XCHANGE but we do not have the SDK version.  
> I've seen code to use PDFWriter from Adobe, however I don't have that
> luxury.  

> I downloaded CutePDF and GostScript, which works great as a printer to
> convert any document to PDF via a printer and is totally free without
> watermarks or ads.  I would like to use this as part of an email
> distribution of reports.  I know this has been talked about on the lists but
> has there been any solutions that use CutePDF, or does anyone out there know
> the workings behind CutePDF that they could share where I could either alter
> some registry changes or ini file to automate the creation of a PDF and then
> simply pick it up and send it via an email.

> Thanks in advance,
> Rich