[AccessD] Make pdf report

Kaup, Chester Chester_Kaup at kindermorgan.com
Mon Oct 10 12:40:53 CDT 2016


Here is an excerpt of a function to send a report to a pdf file

ReportDate = ReportMonth & " " & ReportYear
    ReportTemplate = "rpt Cisco Sands Monthly Well Count"
    ReportName = "Cisco Sands Well Count " & ReportDate & ".pdf"
    Path = "C:\Files\Access\Well Counts"
    FileName = Path & "\" & ReportName
    DoCmd.OutputTo acOutputReport, ReportTemplate, "PDFFormat(*.pdf)", FileName, False, "", , acExportQualityPrint

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Monday, October 10, 2016 12:24 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Make pdf report

Dear List:

 

I developed some code to create a report as a pdf and attach it to an email many years ago in A2003.  It doesn't work any more.

 

Is there a 'moderne' way to accomplish this? Sending the attachment by email is, I think the less important part of the task - getting the report output in pdf form is the sticker.

 

MTIA

 

 

Rocky Smolin

Beach Access Software

760-683-5777

 <http://www.bchacc.com> www.bchacc.com

 <http://www.e-z-mrp.com> www.e-z-mrp.com

Skype: rocky.smolin

 

 

--
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