Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Trouble 1

Status
Not open for further replies.

blindlemonray

Technical User
Nov 24, 2003
130
GB
I have had this problem now for two days. I need to export a single page of a report in RTF format to an external file. Any ideas greatly appreciated?
 
I asked a similar question a few days ago and received this reply from CosmoKramer:
In a new module, add a function similar to this example of mine, of course adapting it to your situation:

Function Xferdoc_MonthStat()

Dim strFileName As String
strFileName = "c:\SMH Monthly Statistics Report - " & Forms!frmMain!txtStats
DoCmd.OutputTo acOutputReport, "rptMonthlyStats", acFormatRTF, strFileName
End Function


Hope this helps.....

I was able to adapt this for my use. I run the function from a command button to output the report.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top