how to filter from ADODB.Recordset in vba

Question

I am using ADODB.Recordset in my vba program, loading all record from table to recordset and want to filter record inside the loop based on loop(i value).

I am using below code to filter record from recordset:

for (dim i as integer = 1 to 10)
    rsContacts.Filter = "Name = '" & Cell(i,1) & "' and Id = '" & Cell(i,2)& "'"
next

It's filtering properly returning one record when i = 1 but when i = 2 recordset doesn't have any record. How can filter record but want to keep full recordset so that it will filter properly?

Before anyone would be willing to read your question and try to help, please format it properly. — FDavidov
– FDavidov, Commented Dec 26, 2016 at 11:27
for (dim i as integer = 1 to 10) is a syntax error in VBA. — John Coleman
– John Coleman, Commented Dec 27, 2016 at 4:47

Storax · Accepted Answer · 2016-12-27 07:48:43Z

1

Maybe you need to add code to move to the first record. rsContacts.MoveFirst

Another suggestion would be to clear the filter beforehand rsContacts.Filter = adFilterNone

answered Dec 27, 2016 at 7:48

Storax

12.7k3 gold badges21 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Himanshu · Accepted Answer · 2022-12-16 06:33:05Z

0

Before the next step in the For - Next cycle, try clear filtering by

rsContacts.Filter=""

or

rsContacts.Filter=adFilterNone

edited Dec 16, 2022 at 6:33

Himanshu

32.8k32 gold badges117 silver badges137 bronze badges

answered Dec 12, 2022 at 15:49

Ara Proshyan

1

Collectives™ on Stack Overflow

how to filter from ADODB.Recordset in vba

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related