Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    London
    Posts
    73

    Unanswered: Object Variable 91

    Hi

    I get an error message when i run a VBA code see below



    Dim db As Database
    Dim rs As Recordset
    Set db = CurrentDb
    Set rsTable = db.OpenRecordset("tblTest", dbOpenDynaset)

    Call addsplit(rs!CUADDRESS, IIf(IsNull(rs!CUPOSTCODE), " ", rs!CUPOSTCODE))

    (I get a debug message on the bold line above) With the message

    run-time error 91
    Obect Variable or with Block variable not set


    Can you see where i'm going wrong

    Thank you

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Yes ... Where is the rsTable recordset variable????
    Back to Access ... ADO is not the way to go for speed ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •