Multiple reports to same PDF file

[cascot]

I have previously written code to generate PDF files from Access reports (using Distiller), but does anyone know if it's possible to create (say) a 4 page PDF document, where page 1 is AccessReportA, page 2 is AccessReportB, etc?

 

[impulse24]

You can use the same code. If the reports to be printed are the results of a query, you just send the entire result to your program, and will write out all the reports to a single pdf file.

 

[cascot]

Hi impulse24,

Thanks for your reply. I may not have explained things very well. I am talking about (say) two Access reports (A & B). Report A (let's say 3 pages long) gets it's data from queryA and presents it in one format. Report B (let's say 2 pages long) get's it's totally different data from queryB and presents it in a very different format. Is it possible to in some way send both reports to Adobe so that only a single 5 page PDF file gets created?

 

[TedGrier]

Could you show me an example of the code? If the user has full version of Acrobat 4.0, then you simply added reference to their OXC and then inserted as an ActiveX control?

 

[Nitronomus]

I have the same problem. There is a prog called PDF-Append but I didn't get this tool correct to work.

But here is my Codepiece:

Dim stDocName As String

stDocName0 = "Ber 25 Übersicht Fahrzeuge"
stDocName1 = "Ber Diagr 290 Gemischadaption additiv"
stDocName2 = "Ber Diagr 290 Gemischadaption multiplikativ"
stDocName3 = "Ber diagr 300 Verlustmoment adaption"
stDocName4 = "Ber Diagr 280 Start1"
stDocName5 = "Ber Diagr 280 Start2"


DoCmd.OpenReport stDocName0, acNormal
DoCmd.OpenReport stDocName1, acNormal
DoCmd.OpenReport stDocName2, acNormal
DoCmd.OpenReport stDocName3, acNormal
DoCmd.OpenReport stDocName4, acNormal
DoCmd.OpenReport stDocName5, acNormal

The standart printer is the PDF-Distiller (Acrobat 4.0)

Bye

 

[Nitronomus]

I've forgotten something, I can't use OCX cause this code has to work from different workstations with different OSs. But maybe there is another way to solve the problem.

 

[StarPassing]

I had about 15 reports to combine into one report. I created a new report and added each of the 15 reports as sub-report. Now I get all 15 together, each report starts on a new page. Page numbers at the bottom are 1 to 15.

Tom

 

[mvpacc]

You may want to check out our PDF and Mail library for Access. It can not only output the PDF files, but also merge multiple files into one file on the fly from within Access.

HTH

http://ourworld.compuserve.com/homepages/attac-cg