How do I export multiple reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to export multiple reports in rich text format. I can do this in
snapshot (snp) format, but can't figure out how to do it in rich text. I am
not an experienced Access user, so I need something that I can understand. I
have figured out how to do this using a macro and OutputTo, but that is only
doing 1 report at a time and I have 8 reports that I would like to do at
once. Any suggestions?

Thanks.
 
Hi,
try to adapt VBA (visual basic for applications). Macros are very limited
and cannot handle error handling. Therfor you can use vba on the on click
event of a button on a form with some code which just repeats several
outputto commands e.g.:

DoCmd.OutputTo acOutputReport,"ReportName", acFormatRTF,"c:\path to
file\file.rtf", False
DoCmd.OutputTo acOutputReport,"ReportName01", acFormatRTF,"c:\path to
file\file01.rtf", False
DoCmd.OutputTo acOutputReport,"ReportName02", acFormatRTF,"c:\path to
file\file02.rtf", False
....
HTH
Good luck
 
Back
Top