In Microsoft Office Access 2007, you may experience one or more of the following symptoms.
Symptom 1
Consider the following scenario. You try to export a report to a Microsoft Excel format. To do this, you right-click the report in the navigation pane, and then
you point to
Export. In this scenario, you may find that the
Excel
option is unavailable.
See workaround 1 in the "Workaround" section.
Symptom 2a
Consider the following scenario. You try to export a report to an Excel format by using
the
OutputTo macro action or the
SendObject macro
action. In the macro action, the value of the
Object Type argument is
Report. In this scenario, the option to export the report to the Excel format does not appear in the
Output Format list.
See workaround 2 in the "Workaround" section.
Symptom 2b
Consider the following scenario. You run a macro that was created in an earlier version of Access. The macro has the
OutputTo action or
the
SendObject action. In the macro action, the value of the
Object Type
argument is
Report, and the value of the
Output
Format argument is
Microsoft Excel 97-2003. In this scenario, you may
receive the following error message:
The format in which
you are attempting to output the current object is not available. Either you
are attempting to output the current object to a format that is not valid for
its object type, or 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. Run Setup to reinstall Microsoft office Access or, if you're familiar
with the settings in the Registry, try to correct them yourself. For more
information on the Registry, click Help.
When you click
OK in the
Action Failed dialog box, error 2950 is displayed.
See workaround 2 in the "Workaround" section.
Symptom 3
Consider the following scenario. You run a Microsoft Visual Basic for Applications (VBA) procedure that contains the
SendObject method. In this method, the value of the
ObjectType argument is
acSendReport, and the value of the
OutputFormat
argument is
acFormatXLS. Alternatively, you run a VBA procedure that contains the
OutputTo method. In this method, the value of the
ObjectType argument is
acOutputReport, and the value of the
OutputFormat argument is
acFormatXLS. In this scenario, you may receive the following error
message:
Run-time error '2282': The format in which you
are attempting to output the current object is not
available.
See workaround 3 in the "Workaround" section.
Workaround 1
To work around symptom 1 in the "Symptoms" section, use one of the following methods.
Method 1
In the navigation pane,
right-click the table or query that is bound to the report, point to
Export, and then click
Excel. Then, follow the
wizard to finish the export.
Method 2
In the navigation pane,
right-click the report that you want to export, point to
Export, and then select another format. For example, select one of the following formats:
| Word
RTF file |
| PDF or XPS |
| Access
Database |
| Text File |
| XML File |
| Snapshot Viewer |
| HTML Document |
Workaround 2
To work around symptom 2a and symptom 2b in the "Symptoms" section, use one of the following methods.
Method 1
In the macro action, change the value of the
Object Type
argument to either
Table or
Query. Additionally, change the value of the
Object Name argument
to the record source of the report.
Method 2
| 1. | In the Action Arguments for the
OutputTo macro action or SendObject macro
action, select another format in the Output
Format list. For example, select one of the following formats: | HTML | | Rich
Text Format | | Snapshot Format | | Text
Files |
|
| 2. | Change the value of the Output File argument to
the correct file name extension. |
Workaround 3
To work around symptom 3 in "Symptoms" section, use one of the following methods.
Method 1
| 1. | In the VBA procedure, change the value of the
ObjectType argument to one of the following: | acSendTable | | acSendQuery | | acOutputTable | | acOutputQuery |
|
| 2. | Change the value of the ObjectName
argument to the record source of the report. |
Method 2
| 1. | In the VBA procedure, change the value of the
OutputTo argument to another value. For example, change the value of the OutputTo argument to one of the following values: | acFormatPDF | | acFormatRTF | | acFormatSNP | | acFormatTXT | | acFormatXPS |
|
| 2. |
Change the
value of the OutputFile argument to the correct file name
extension. |
This
behavior is by design. You cannot export reports to the Excel format in Access 2007. Microsoft has disabled this
functionality.
To use one of the following file formats in the 2007
Microsoft Office system, download the corresponding 2007 Microsoft Office add-in:
The following table lists these file formats, their corresponding add-ins, and the Microsoft Web sites for downloading the add-ins:
