[AccessD] Make pdf report

Rocky Smolin rockysmolin at bchacc.com
Mon Oct 10 13:42:42 CDT 2016


Dang!  Seems too easy.  I'll give it spin and report back.

Thank you.

Rocky


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Kaup, Chester
Sent: Monday, October 10, 2016 10:41 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Make pdf report

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

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