[AccessD] Printing to file as PDF w/specific path?

Mike & Doris Manning mikedorism at adelphia.net
Fri May 14 12:43:17 CDT 2004


We use PDF995 on a server to accomplish this but there are lots of other PDF
choices out there.

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Christopher
Hawkins
Sent: Friday, May 14, 2004 12:43 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Printing to file as PDF w/specific path?


With the recent thread about manipulatinig printers through code, I decided
tolook into both the Printer API and the newere Printers object.  So far,
I've not figured out how to do what I'm trying to do.

My Challenge:

Let's say all my invoices for the month of March are ready to go out, and I
want to drop a copy in each client's folder.  Rather than Print Preview each
one in order to save it as a pdf, I'd like to click one button that will
kick off a routine looping through all my client records and print their
invoices out to a pdf file, saving the file at the path stored in the
client's record.

Now, looping through each client and opening or previewing the report?
Easy.  I can even set the default printer in code, no sweat. The part I
cannot figure out is how to print to a pdf file, and stick my own path in
there.  I looked ad DoCmd.OutputTo at first, but it only works with the
predefined formats Access ships with.

Surely I'm not the first guy to need to do this?  Any ideas?

-Christopher-

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list