Help with Output file in Rich Text format

L

LisaK

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.
 
S

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?
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top