January 25th, 2011, 04:07 PM
How do I concatenate / merge / join snapshot reports (Access 2000 VBA)
I have many individual snapshot reports (customer invoices) that I would like to concatenate/merge into one big report.
Does anyone have any code examples on how to do this?
I'm thinking that when the individual report is created...
...that another report (I'll called it the "merged report") would be opened and appended with the individual report.
DoCmd.OpenReport REPORTNAME, acViewPreview
outputFilename = "P" & Reports(REPORTNAME).Pages & "_" & outputFilename
fileToSave = SAVEPATH & outputFilename
DoCmd.OutputTo acOutputReport, REPORTNAME, acFormatRTF, fileToSave, False
If there is a better way, I am open to suggestions.
My other option is to somehow concatenate/merge the RTF files. Does anyone have any VBA examples of this?
Many Many Thanks, Gurus!
Tags for this Thread
Click Here to Expand Forum to Full Width
This is a CodeGuru survey question.