How can I append an Access report to an existing PDF file? - Powered by Kayako Help Desk Software

Knowledgebase

Knowledgebase: Developer

How can I append an Access report to an existing PDF file?

Posted by Sue Lebakken on 04 December 2006 08:53 PM

This code sample will append the MS Access report "rpt_ReportToAppend" to the existing PDF file "c:\OriginalPDF.pdf"

resulting in the new PDF file "c:\FinalPDF.pdf"

'set the output file name for the merged file
SaveSetting "Dane Prairie Systems", "Win2PDF", "PDFFileName", "c:\FinalPDF.pdf"

'set the PDF file to append to
SaveSetting "Dane Prairie Systems", "Win2PDF", "PDFPrependFile", "c:\OriginalPDF.pdf"

'Print report. This code assumes that Win2PDF is set as the default printer.
DoCmd.OpenReport "rpt_ReportToAppend", acNormal

(2 vote(s))

Helpful

Not helpful

Comments (1)

JOE TETI

20 July 2016 02:39 PM

THIS WAS VERY VERY HELPFUL TO US.

Thanks