Appending mutiple reports to PDF using VBA.

  • Thread starter Thread starter The Flash
  • Start date Start date
T

The Flash

I have 2 separate reports in the same database that I want merged together in
a PDF file as opposed to creating 2 separate PDF documents and then coping
and pasting the pages in Adobe.

I have 1804 pages on each report and manually copying each pdf document
would take for ever. The order would be (Report 1 Pg 1, Report 2 Pg 1),
(Report 1 pg 2; Report 2 pg 2) and so on.

Could anyone or everyone please give me an code example of how to append
multiple Access reports to one PDF file? Any help would be greatly
appreciated.
 
Is there a reason why you wouldn't simply make a report which combine your 2
reports for you that way you don't need to mess around with automating PDF
software?
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.
 
Well the first report contains the related data from my database. The Second
report is simply a document stating the purpose of the first record. I used
all of my headers and footers on the first document so i'm out of page space
for the second.
 
Back
Top