Andy Lacey
andy at minstersystems.co.uk
Sat May 15 05:37:26 CDT 2004
I'm a bit rusty here but I think Acrobat (v5 last time I used it) allowed you to setup in Distiller a port which was a folder. When you printed an Access report to the Distiller printer it created PDF named after the caption of the report (I think) in that folder. -- Andy Lacey http://www.minstersystems.co.uk > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of > Christopher Hawkins > Sent: 14 May 2004 18:55 > To: accessd at databaseadvisors.com > Subject: RE: [AccessD] Printing to file as PDF w/specific path? > > > I'm not really married to any particular PDF driver, I'm just > looking for code that will let me use that driver to print to > file, and specify a path. > > -C- > > ---- Original Message ---- > From: mikedorism at adelphia.net > To: accessd at databaseadvisors.com, > Subject: RE: [AccessD] Printing to file as PDF w/specific path? > Date: Fri, 14 May 2004 13:43:17 -0400 > > >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 > > > >-- > >_______________________________________________ > >AccessD mailing list > >AccessD at databaseadvisors.com > >http://databaseadvisors.com/mailman/listinfo/accessd > >Website: http://www.databaseadvisors.com > > > > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >