Microsoft KB Archive/142477

= ACC: "Microsoft Access Can't Find the Field" Error Message =

Article ID: 142477

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q142477



Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you preview a report in Microsoft Access 7.0 or Microsoft Access 97, you may receive the following two error messages:

Microsoft Access can't find the field ' ' referred to in your expression.

An error occurred while referencing the OLE Automation object. You tried to run a Visual Basic procedure that improperly references a property or method of an OLE Automation object.



CAUSE
The report's record source contains a field with the same name as one of the following reserved words in Microsoft Access:   AddRef Application Assistant GetIDsOfNames GetTypeInfo GetTypeInfoCount Invoke Parent QueryInterface References Release



RESOLUTION
There are two ways to resolve this issue:  You can rename the field by opening its table in Design view and assigning a unique name that is not a reserved word in Microsoft Access. If your report is based on a query, you can alias the field. For example, for a field named Release (a reserved word), you can open the query in Design view, and then change the field name in the query grid from

Field: Release

to:

Field: MyReleaseField: Release





Steps to Reproduce Behavior
 Open the sample database Northwind.mdb.  Create a new table with the following fields: <pre class="fixed_text">     Table: Table1 Field Name: Release Data Type: Text Field Name: Invoke Data Type: Text Field Name: GetTypeInfo Date Type: Text </li> Close and save the table as Table1.</li> Create a report based on the Table1 table by using the AutoReport: Columnar Wizard.</li> Preview the new report. Note that you receive the error messages listed in the "Symptoms" section.</li></ol>

<div class="references_section">