ACC: How to Use Seek Method with Multiple-Field Index (109710)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q109710 SUMMARY
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article shows you how to use the Seek method when your table's primary
key or index includes more than one field. Note that when you use the Seek
method on multiple fields, the Seek fields must be in the same order as the
fields in the underlying table. If they are not, the Seek method will fail.
This article assumes that you are familiar with Visual Basic for
Applications and with creating Microsoft Access applications using the
programming tools provided with Microsoft Access. For more information
about Visual Basic for Applications, please refer to your version of the
"Building Applications with Microsoft Access" manual.
NOTE: Visual Basic for Applications is called Access Basic in Microsoft
Access versions 1.x and 2.0. For more information about Access Basic,
please refer to the "Introduction to Programming" manual in Microsoft
Access version 1.x or the "Building Applications" manual in Microsoft
Access version 2.0
REFERENCES
For more information about the Seek method, search for Seek method, and
then Seek Method (DAO), using the Microsoft Access 97 Help Index.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbhowto kbProgramming KB109710 |
---|
|