How do you merge Multiple Access Report to Single PDF ?
- Thread starter shimul
- Start date
HiTechCoach
Well-known member
- Local time
- Today, 15:04
- Joined
- Mar 6, 2006
- Messages
- 4,357
See you original post.
http://access-programmers.co.uk/forums/showthread.php?t=162686
PS: AFAIK, it is consider good forum manners to post your question in a single forum and not cross/double post at the same time. If you have not had a redponse in days, you may want post again in a different forum and probably rephrase your question.
http://access-programmers.co.uk/forums/showthread.php?t=162686
PS: AFAIK, it is consider good forum manners to post your question in a single forum and not cross/double post at the same time. If you have not had a redponse in days, you may want post again in a different forum and probably rephrase your question.
Last edited:
Stephen Lebans does a brilliant job.
Download the zip file from his site and it has all of the DLLs required as well as sample code.
In essence you import his modReportToPDF module into your app, copy 2 DLLs into your %systemroot%\system32 folder and call his function as follows:
MergePDFDocuments(varMaster, varChild)
The varChild PDF will be merged into the varMaster PDF when the routine is over.
To create the PDF in the first instance can be done with Stephen's utils, but I personally prefer the following command:
DoCmd.OutputTo acOutputReport, varRpt, acFormatPDF, varChild, False
This works only because of the fact that I am using Access 2007 with the Save As PDF/XPS util from MS installed.
Download the zip file from his site and it has all of the DLLs required as well as sample code.
In essence you import his modReportToPDF module into your app, copy 2 DLLs into your %systemroot%\system32 folder and call his function as follows:
MergePDFDocuments(varMaster, varChild)
The varChild PDF will be merged into the varMaster PDF when the routine is over.
To create the PDF in the first instance can be done with Stephen's utils, but I personally prefer the following command:
DoCmd.OutputTo acOutputReport, varRpt, acFormatPDF, varChild, False
This works only because of the fact that I am using Access 2007 with the Save As PDF/XPS util from MS installed.
Similar threads
