CraigLazar
asked on
How do i Search for record ?
Hi
I am using VB3 and access 2
How do i search for a record ?
Thanx
Craig
I am using VB3 and access 2
How do i search for a record ?
Thanx
Craig
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Im not sure , if VB3 support object Recordset and
constant dbOpenDynaset. (maybe it's from VB4 or VB5)
Try :
Dim rs as Dynaset
set rs = db.CreateDynaset("Select * from log")
constant dbOpenDynaset. (maybe it's from VB4 or VB5)
Try :
Dim rs as Dynaset
set rs = db.CreateDynaset("Select * from log")
You can try creating a recordset! Its been a while since I used VB3, but I a am sure you can do this.
Alternatively, try creating a snapshot. You can even create a Query in Access 2 with your search critiera and create a snapshot of it from VB3 by just specifying the querydef - this is certainly possible. If you can wait for a while I will try to look for some code that demonstrates this (it should all be in the VB3 Help File)
Alternatively, try creating a snapshot. You can even create a Query in Access 2 with your search critiera and create a snapshot of it from VB3 by just specifying the querydef - this is certainly possible. If you can wait for a while I will try to look for some code that demonstrates this (it should all be in the VB3 Help File)
ASKER
VB3 does not allow me to do this
dim rs as recordset
set rs = db.opnerecordset("Select * from log",dbopendynaset)
gives me an error on line one saying rs is type not defined