How do I join more than 1 report with OutputTo?

[jlk]

Hello,

I have a few reports in Access 2007 that I would like to export to PDF together (as a joined PDF file). My code is working perfectly well with 1 report, however I have not been able to work out how to join the reports when exporting to pdf.

Private Sub cmdCentreCosts_Click()


DoCmd.OutputTo acOutputReport, "rptCentreCosts", acFormatPDF, , , , , acExportQualityScreen


End Sub



I am fairly new to VBA, any assistance would be greatly appreciated.

Thanks,
jlk

[June7]

Can't.

It is possible to use VBA to merge the PDF files. Review https://www.accessforums.net/access/...pdf-25574.html

[jlk]

Thanks for your fast reply. I'll give the vba for the pdf files a go.

I have another question about the reports.

What about being able to load 2 reports together in Access? I have a form where selections are made and then a report runs based on these parameters. Would it be possible to join 2 reports together to present as 1 one in access. If that makes sense???

Or should I be considering adding a subform onto the first report? I have not produced a report with a subform before, however if this would work i will give it a go.

Thanks
jlk

[June7]

Report objects cannot be 'joined' except as a subreport.

A subreport might accomplish what you want.