Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multiple Filters on the same recordset
Hello All! I have this rst3. I have filters and want to apply them 1 by 1. rst3.filter = filterstr1 if rst3.recordcount = 1 then exit rst3.recordcount= filterstr2 if rst3.recordcount =1 then exit suppose there are 4 records after the filterstr1 is applied. The program doesnot apply the next...- jamjam007
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Filter not valid
Hello! I have this recordset rst. I am filtering it using a criteria. rst.filter = "Filterstring" But when the filter doesnt work, i.e. no records filtered, it gives Rum-time error 3265 Item cannot be found in the collection corresponding to the required name or cardinal. How can I test this...- jamjam007
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
