Results 1 to 5 of 5

Thread: SET objet

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

    Unanswered: SET objet

    How can you determine whether an Oject was set or not?

  2. #2
    Join Date
    Jan 2004
    Posts
    184

    Re: SET objet

    See if it is nothing i.e.

    If Object = Nothing Then

    It was not set

    ELSE

    It was set

    Endif
    In abundance of water only the fool is thirsty. Bob Marley.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thanks for your answer, it should function.

  4. #4
    Join Date
    Feb 2004
    Posts
    199
    rami.haddad don't lie it won't work!

    you should use "IS NOTHING" this statement

    IF myObj Is Nothing then
    .....
    End if


    or


    IF not myObj IS Nothing then
    ...
    MDB, ADP <-> MS SQL + VBA, ADO & RDO, .NET, Oracle, Java/Jsp.

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Originally posted by Kakha
    rami.haddad don't lie it won't work!

    you should use "IS NOTHING" this statement

    IF myObj Is Nothing then
    .....
    End if


    or


    IF not myObj IS Nothing then
    ...
    Thank you you are right, it functions using Is Nothing , I tried it.

Posting Permissions

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