ACC2000: Error Message Using OutputTo to Output a Report to Another Format

ID: Q226526


The information in this article applies to:

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).


SYMPTOMS

When you use the OutputTo action or method to output a report to another format, you receive one of the following errors:

Run-time error '2024':

The report snapshot was not created because you do not have enough free disk space for temporary work files.
-or-
Run-time error '2302':

Microsoft Access can't save the output data to the file you've selected.
-or-
Run-time error '2282':

The formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing from the Windows Registry.


CAUSE

You did not specify a file name in the Output File argument of the OutputTo action or method. If you enter just a path and do not include a file name, you may receive one of the errors mentioned in the "Symptoms" section.


RESOLUTION

Modify the Output File argument of the OutputTo action or method to include a file name.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.


  2. Create a new module and type the following procedure:
    
    Sub OutputSnapshot()
       DoCmd.OutputTo acOutputReport, "Alphabetical List of Products", _
        acFormatSNP, "C:\My Documents", True
    End Sub 
    NOTE: This procedure assumes that you have a "My Documents" folder on the drive C.


  3. Press F5 to run the procedure.

    Note that you receive the first error listed in the "Symptoms" section.



REFERENCES

For more information about the OutputTo action, click Microsoft Access Help on the Help menu, type "OutputTo action" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: prb


Keywords          : kberrmsg kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb 

Last Reviewed: May 13, 1999