Help with Output file in Rich Text format

[Guest]

I had a database that was created in Access 97 and I have imported it into
Access 2003. My macro that used to work in Access 97 no longer works in
2003. This is what is in the module:

DoCmd.OutputTo acOutputReport, "rptGrp224", acFormatRTF,
"U://CCS-GROUP-REPORTS/2006/OctGrp224.rtf", False

Can someone tell me why this is not working?

Thanks.

 

[Steve Schapel]

Lisa,

This is a VBA code, not a macro. Anyway, I can't immediately see what
the problem might be, but it looks strange with the two /s after the
drive letter. I imagine that "U:/CCS-GROUP-REPORTS/2006/OctGrp224.rtf"
might be more usual path.

Other than that, can you say what "no longer works" means. Nothing at
all happens? Error message? Something else?

 

[bob]

if that does not work, try "U:\CCS-GROUP-REPORTS\2006\OctGrp224.rtf"
...this assumes the U: drive actually exists.

If it does not use the UNC path \\servername\sharename\........


Bob