Need Code to Export a report in RTF format 2

[Dylan]

I have an existing report that I want to automate creating an external rtf file. can this be done using an event procedure behind a command button.

Thanks for any help

Tom



Tom Moran
Lansing, Michigan

 

[DoubleD]

DoCmd.OutputTo acOutputReport,"ReportNameHere",acFormatRTF,"FileToSaveTo"

I am what I am based on the decisions I have made.

DoubleD

 

[mp9]

Sure can, the VBA you need for your command button takes the form:

DoCmd.OutputTo acOutputReport, "YourReportNameHere", acFormatRTF, "C:\temp\demo.rtf"

Search Access VBA help for OutputTo Method for more explanation and some interesting optional parameters.

Hope this helps.

http://www22.brinkster.com/accessory/

 

[DoubleD]

mp9,
Good solution. hehehe

I am what I am based on the decisions I have made.

DoubleD