-
1
- #1
I have an Access2000 database where the user can choose to run multiple reports at once. When the user clicks "Run", I use a "For Each" statement to print a report for each record selected in a multiselect listbox on the users form.
One problem I had was that the same report may be used more than once, so I had to avoid using print preview feature and just send each report to the printer.
I could add another button to my form that the user could click to preview/e-mail one report at a time, but that will not be too usefull.
I want to know if it is possible to combine (or batch) multiple reports. I am trying to add the
previewing/e-mailing capability. If I could combine all my reports into one, then the user could send one snapshot via e-mail, (as opposed to multiple e-mails, each with one snapshot).
(I don't want to export the reports to Word because my lines and logo do not get exported, and I want to keep everything in Access for tracking purposes)
Is this possible, or is there a better way to solve this problem?
Please let me know,
Thank you
Blair
One problem I had was that the same report may be used more than once, so I had to avoid using print preview feature and just send each report to the printer.
I could add another button to my form that the user could click to preview/e-mail one report at a time, but that will not be too usefull.
I want to know if it is possible to combine (or batch) multiple reports. I am trying to add the
previewing/e-mailing capability. If I could combine all my reports into one, then the user could send one snapshot via e-mail, (as opposed to multiple e-mails, each with one snapshot).
(I don't want to export the reports to Word because my lines and logo do not get exported, and I want to keep everything in Access for tracking purposes)
Is this possible, or is there a better way to solve this problem?
Please let me know,
Thank you
Blair
