Open Report and output to file VBA - assistance

[newbee2]

Hi,
Sorry to bother.
Using the following code snippet,I was hoping to test an application to output a report for later e-mail.
The code runs but stops with no indication of error but there is one. Where am I going wrong?
'open the Database
With accessApp
.OpenCurrentDatabase ("D:\My Documents\WORKS CARD.mdb&quot
End With

'open the report and print
DoCmd.OpenReport "MarketUnionConvertReport", acViewPreview
Visible = False
'Output the Report to file
DoCmd.OutputTo acOutputReport, "MarketUnionConvertReport", acFormatRTF, "C:\My Documents\Test", "MarketUnionConvertReport.rtf"
'Close access session
accessApp.Quit
Set accessApp = Nothing
Thanks in advance
Bill

 

[FoxProProgrammer]

Hi Bill,

I see one potential issue that might be causing this problem.

The command: DoCmd.OutputTo acOutputReport, "MarketUnionConvertReport", acFormatRTF, "C:\My Documents\Test", "MarketUnionConvertReport.rtf"

should be?:

DoCmd.OutputTo acOutputReport, "MarketUnionConvertReport", acFormatRTF, "C:\My Documents\MarketUnionConvertReport.rtf"

Also, why are you opening the report in Preview mode and then hiding it? The report doesn't need to be open for the OutputTo Action to work.

dz
dzaccess@yahoo.com

 

[newbee2]

Thanks,

I was on the wrong belief that you had to open the object B4 you outputed. Don't know enough about the method.
Thanks agian
Regards
Bill

 

[FoxProProgrammer]

No problema...I was just curious why you opened the Report. I don't think that is actually causing the problem unless the report must be closed when you output it. The problem is more likely a result of the extra parameter in the DoCmd.OutputTo statement. Hopefully that will solve your issue.

Best, dz
dzaccess@yahoo.com

 

[newbee2]

DZ,
Success, mission accomplished.
Kind Regards
Bill