outputTo method

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have implimented the function with the following arguements:

DoCmd.OutputTo acOutputQuery, "subQry_ALL_appealDecisions",
"RichTextFormat(*.rtf)",
"\\comp-san-2\xxx\yyy\Planning_Performance\uniform\appeals_report", True, ""

I receive an error when I try to execute, stating:

"Can't save the data output file you've selected"

Does anyone have any ideas why I receive this error?

I have changed the file path to the C:\ and the error is still the same, so
I know this is not a permissions issues.
 
Try putting an extension on the file you're trying to save:

DoCmd.OutputTo acOutputQuery, "subQry_ALL_appealDecisions", _
"RichTextFormat(*.rtf)", _
"\\comp-san-2\xxx\yyy\Planning_Performance\uniform\appeals_report.rtf", _
True, ""
 
That seems to work, thank you.

Is their any way I can either.

* output to a pre formteed document
OR
* change the paper layout/ font size during execution of the function?
 
OutputTo doesn't doesn't print, so I'm confused as to what you're looking
for.

You should create a report that sets the paper layout and size, and use that
to print to a preformatted document.
 
Back
Top