Using ADODB .Find instead of DAO .Seek
Posted on 2009-04-02
Hi. I just upgraded everybody's PC to Office 2007, only to find that all the DAO stuff I had written in MS Access no longer works. I have a camp sales table with a composite primary key composed of a 2 byte integer and a 7 byte session id. I used to do:
Sales.Seek "PrimaryKey", sess & Id
If Sales.Nomatch ...
Neither .Seek or .Nomatch work any more
I was trying searchstr = "PrimaryKey = " & sess & Id, and then checking for EOF, but this doesn't seem to be the right syntax when I do:
Sales.Find searchstr, , adSearchForward
Can someone help, please?