CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: record sets

  1. #1
    Guest

    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



  2. #2
    Join Date
    May 1999
    Posts
    3,332

    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.


  3. #3
    Guest

    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
  •  





Click Here to Expand Forum to Full Width

Featured