CODEWITHSUNDEEP
excelvbafilterrs
Israel Dac
Israel Dac

Reputation: 1

Excel VBA adodb error 3001 using rs.filter

Using Excel 2013 with Access 2013

Using Provider = Microsoft.ACE.OLEDB.12.0;

After rs.open Table, I wrote an rs.filter with

This is my code

myFilter = "sd_am = 'abcd' and sd_h = '' and (sd_k = 'option1' or _ 
     sd_k = 'option2' or sd_k = 'option3') and sd_l = 'kuku'"
rs.filter = myFilter

I get error 3001 ! I tried to change the filter with different syntax - doesn't work !

Upvotes: 0

Views: 223

Answers (1)

Israel Dac
Israel Dac

Reputation: 1

It appears that rs.filter is a weak function !

Using the same syntax with select - did the job !

Upvotes: 0

Related Questions