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.
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..
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.
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.
To resolve this issue, upgrade to the 2007 Office suite Service
Pack 2. With Access 2007 Service Pack 2, you can export a report to an Excel
format in Access 2007.
If
you cannot install the 2007 Microsoft Office suite Service Pack 2, you
may use one of the following workarounds, depending upon the symptom you receive.
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
- 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
- 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
- In the VBA procedure, change the value of the
ObjectType argument to one of the following:
- acSendTable
- acSendQuery
- acOutputTable
- acOutputQuery
- Change the value of the ObjectName
argument to the record source of the report.
Method 2
- 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
- Change the value of the OutputFile
argument to the correct file name extension.
Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
in the "Applies to" section.
This issue was fixed in the 2007 Microsoft Office suite Service Pack 2.
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:
Collapse this tableExpand this table