ACC2: Incorrect FindFirst Example in "Building Applications" (121838)
The information in this article applies to:
This article was previously published under Q121838
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
Page 256 of the Microsoft Access version 2.0 "Building Applications" manual
contains an example of using the FindFirst and FindNext methods to locate
all records satisfying a particular criterion. However, if you re-create
and run this example, you will receive the following error message:
Invalid Operation.
CAUSE
This error occurs because the example contains an error. The example uses
the OpenRecordset method to open the Employees table as a table-type
Recordset object, but the FindFirst method is not available with table-type
Recordset objects.
RESOLUTION
Change the line in the example that reads
Set MySet=MyDB.OpenRecordset("Employees")
to the following line:
Set MySet=MyDB.OpenRecordset("Employees",DB_OPEN_DYNASET)
STATUS
This behavior no longer occurs in Microsoft Access version 7.0.
REFERENCES
For more information about the OpenRecordset method, search for
"OpenRecordset," and then "OpenRecordset Method (Data Access)" using the
Microsoft Access Help menu.
Microsoft Access "Building Applications," version 2.0, Chapter 11, "Working
with Sets of Records," pages 256-257
For more information about documentation corrections, view the topic
"Documentation Updates" in the Microsoft Access 2.0 ACREADME.HLP file.
Modification Type: | Major | Last Reviewed: | 7/5/2002 |
---|
Keywords: | kbusage KB121838 |
---|
|