Access VBA OutputTo Report error

B. Hata 1 Reputation point
2022-07-27T19:17:18.877+00:00

I have a long time running program where I am now getting an error trying to output a Report to an RTF. This piece of code ran last month, so it appears something has changed in the last month.

DoCmd.OutputTo acOutputReport, "Report43", acFormatRTF, "c:\tmp\xyz.rtf", False  

I tried changing the file format to Text and XLSX with same error results.
In this code, right before this report output, I output a Query to an XLSX without problems. So it appears that it isn't the destination type but of the source type (Report vs. Query).

I get this error on two different computers, both are Windows 7 Pro.
The Access version/build shows as Version 2002 (build 12527.22183 Click-to-Run)

Any assistance would be appreciated.

0 comments No comments
{count} votes

8 answers

Sort by: Most helpful
  1. Tom van Stiphout 1,696 Reputation points MVP
    2022-08-08T00:47:31.903+00:00

  2. Gary Guillie 1 Reputation point
    2022-08-08T00:55:51.59+00:00

    Does this fix apply to the desktop version of Access 2013?

    0 comments No comments

  3. B. Hata 1 Reputation point
    2022-08-16T18:33:45.33+00:00

    FYI, on my Windows 7 Pro systems, the fix occurred with:
    Version 2002 (Build 12527.22197 Click-to-Run)

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.