Hey all,
I'm doing some modifications on an old VB 5.0 application.
The current code to access an MSAccess DB is :
rsName.Index = Field1
cSeek = Something
cSeek = Trim(cSeek)
rsName.Seek "=", cSeek
This table hasn't got no Primary Key. Now I want to do a Seek on two fields
in this table, but I can't get the code working. I tried something like :
rsName.Index = Field1, Field2
cSeek = Something
cSeek = Trim(cSeek)
cSeek2 = SomethingElse
cSeek2 = Trim(cSeek2)
rsName.Seek "=", cSeek, cSeek2
But that doesn't seem to be the right syntax. Any help is appreciated.
Eddy
I'm doing some modifications on an old VB 5.0 application.
The current code to access an MSAccess DB is :
rsName.Index = Field1
cSeek = Something
cSeek = Trim(cSeek)
rsName.Seek "=", cSeek
This table hasn't got no Primary Key. Now I want to do a Seek on two fields
in this table, but I can't get the code working. I tried something like :
rsName.Index = Field1, Field2
cSeek = Something
cSeek = Trim(cSeek)
cSeek2 = SomethingElse
cSeek2 = Trim(cSeek2)
rsName.Seek "=", cSeek, cSeek2
But that doesn't seem to be the right syntax. Any help is appreciated.
Eddy