[AccessD] print to pdf without popup

Brad Marks BradM at blackforestltd.com
Thu May 24 14:24:17 CDT 2012


John,

I have a number of Access reports that are automatically generated at
night.  The Output is pushed to PDF files which are then attached to
e-mails.  This process has been in place for about 2 years and has
worked nicely.

Below is the code that I use (Access 2007)


Brad

~~~~~~~

DoCmd.OutputTo acOutputReport, _
str_Report_Name, _
"PDFFormat(*.pdf)", _
str_Generated_Report_File_Name, _
False, _
"", _
0, _
acExportQualityPrint

~~~~~~~



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Thursday, May 24, 2012 2:13 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] print to pdf without popup

I need to print to PDF from Access without user interaction.  I will
generate the filename and 
location, print, then attach to an email and mail.

I am looking at various pdf printer drivers but most want to pop up a
"save as" kind of dialog. 
Google is not my friend on this.

Is anyone doing this, can you point me to a web page or something?

Thanks,
-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

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

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.




More information about the AccessD mailing list