Print multiple reports to one PDF

[ben.hornshaw]

Hi All

My first problem is that i am making a database to store and print out health and safety information. due to this i need to create different parts, ie Risk assesments (RA) and Method statements (MS).

What i want to do is allow my user to fill in all the different parts and then hit print and access created one PDF. this PDF will have all the pages of the RA followed by all the pages of the MS. One PDF!!

The second problem which i currently from searching arround the internet i dont think is possible is that i have a few other word documents, they could be PDF's i suppose, that i also need to add into the created PDF so in reality access would create one PDF which would include a front page and index from one file, the RA and then the MS from access and the the H&S Policy afterwards.

I hope tis makes sence.

Thanks for your help

 

[Atomic Shrimp]

You could try inserting them as subreports in an otherwise blank container report, then print that to PDF

 

[ben.hornshaw]

Erm i dont know im trying that now butwhat i am doing is quite big so maybe the three page limit of a report isnt enough