|
-
Jun 3rd, 2002, 02:11 AM
#2
Junior Member
You don't have to create another recordset just to obtain a resultset that has a name starting from 'A'. All you have to do is to pass a query the filters your previous recordset --'rstNames'-- to display all names starting from 'A'.
Try this code:
rstNames.Open "Select * from [table name] where name like 'A%',cn,adLockReadOnly,adCmdText
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
|