|
-
January 28th, 2000, 11:30 AM
#1
record sets
I have the following: Dim db as database, Dim rsbiograph as recordset, Sim rsDoNotEmail as recordset, dim rsEmailTracking as recordset.
Set rsbiograph = db.openrecordset("biograph", dbopendynaset)
set rsDoNotEmail = ....
Set rsEmailTracking = ....
when i get to rsBiograph.FindFirst "StuID = '" & strAL_SID & "'" i get the following error message
object variable or with block variable not set (error 91)
Can anyone help me with this?? I woudl really appreciate it..
Thanks a lot
-
January 28th, 2000, 11:50 AM
#2
Re: record sets
if your code is complete,then there is the OpenDatabase call missing for the db variable.
you need to open the database before you can open recordsets.
-
January 28th, 2000, 12:27 PM
#3
Re: record sets
Thanks for replying.
I am aware of the solution you gave me but my current problem is that when I used only one recordset, the program worked. Now
that I added two more recordsets, it gives me an error message (object variable or with block varible not set). Do you know anything
about this error message? If so, please shed some light
Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|