|
-
Sep 19th, 2000, 03:43 PM
#1
DAO + Index
You can use the index-property of a DAO-recordset only when you have opened the recordset as type "table". Then it would work if you had defined an index in your database for this table (e.g. as primary).
Searching in indexed tables is fast but nearly obsolete. M$-soft wants us to use recordsets which are searchable by SQL-statements (e.g. "snapshot"). Then you would use the FINDFIRST - method to find one or more records: rs.findfirst "title = " & Searchstr
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|