DoCmd OutputTo Appending?

[dandough]

Hi All,

I would like to loop through a list which would output a report to a file for each iteration. How could I append the file instead of having it over written?

Public Sub OutputReport()

DoCmd.OutputTo acOutputReport, "Report1", acFormatRTF, "C:\temp\MyDatabase.rtf"

End Sub

Thanks,
Dan

 

[CCLINT]

dandough,
This is the " Visual Basic(Microsoft) Databases Forum" and not the DBMS Package-Application forum702 for MS ACCESS.
Please post your question there.