Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Posts
    67

    Unanswered: Check if recordset is open

    One of my main source of errors is trying to open a recordset when it is already open or trying to close it when it is already closed. Is there an easy way to check if a record set is open?

    Thanks much for any help.

    Jim

  2. #2
    Join Date
    Jul 2004
    Posts
    125
    One way is to trap the error code and take an action.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Try this code:
    PHP Code:
       If Not yourRS Is Nothing Then
           Set yourRS 
    Nothing
       End 
    If 

  4. #4
    Join Date
    Feb 2004
    Posts
    67

    Thank you

    Thank you very much. Very neat and concise!

    Much appreciated.

    Jim

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Good luck

Posting Permissions

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