Report to RTF file doesn't work

[hvtran]

The file is not created and I got no error when I run the Access report to output the file is as follows:
objDB.DoCmd.OutputTo acOutputReport, "report name", acFormatRTF, "C:\Dest Name.rtf. I recently moved to Access 2003 from Access 2000.

Thanks

 

[boblarson]

I think you need to put the file in a folder on C:\

I could be wrong but I don't think you can send to the root directory (operating system limitation).

 

[hvtran]

RTF file doesn't work

Hi Bob,

The file is in C:\Dest Name.rtf. I checked the permission and it is ok to write. Why VB doesn't give you any warning message.

Thanks

 

[Destiny]

Would it not be better to do it with a macro? Unless the report will always be the same name and should overwrite the existing one with no questions asked.

 

[boblarson]

Try taking this part OFF

objDB.

and just use

DoCmd.OutputTo...etc.