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!

Output To Command - VB 6.3

Status
Not open for further replies.

TryTryAgain

Programmer
Mar 17, 2005
15
US
I recently converted from Access 2000 to Access 2003. I have a database that uses the VB action OutputTo:

DoCmd.OutputTo acOutputReport, "rpt_statusdetail", acFormatRTF, "I:/Land/Capital Projects/Variance - 2005 Closed Projects/2005 Closed Detail Variance Report.rtf", False

This code no longer works, e.g., my reports are not being output although there are no error messages, and the code executes and appears to work.

I've tried using the OutputTo command in a macro, and see the "Now Outputting page...." window but have the same problem, the report is not there.

Any assistance would be greatly appreciated.
 
Try to replace this:
"I:/Land/Capital Projects/Variance - 2005 Closed Projects/2005 Closed Detail Variance Report.rtf"
with this:
"I:[!]\[/!]Land[!]\[/!]Capital Projects[!]\[/!]Variance - 2005 Closed Projects[!]\[/!]2005 Closed Detail Variance Report.rtf"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
YES, that fixed it! Thanks, you're wonderful!
I didn't have the same issue when outputting to Excel, I wouldn't never known to change the "/" to "\".
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top