Cannot find Function IsNothing in Access 97 VBA

Discussion in 'Microsoft Access VBA Modules' started by Guest, Apr 29, 2005.

  1. Guest

    Guest Guest

    Hi,

    I find references to the function IsNothing(object) in the helpfile for
    Access 97 VBA under IsObject(object), but this function is not present in VBA
    97. How can I emulate this function?
    --
    Jos
     
    Guest, Apr 29, 2005
    #1
    1. Advertisements

  2. Guest

    Alex Dybenko Guest

    you can use:

    if MyObject is nothing then
    ....

    or just make own function based on this

    --
    Alex Dybenko (MVP)
    http://Alex.Dybenko.com
    http://www.PointLtd.com



    "Jos" <> wrote in message
    news:...
    > Hi,
    >
    > I find references to the function IsNothing(object) in the helpfile for
    > Access 97 VBA under IsObject(object), but this function is not present in
    > VBA
    > 97. How can I emulate this function?
    > --
    > Jos
     
    Alex Dybenko, Apr 29, 2005
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Alex,

    It is indeed very simple, I knew that "If MyVar Is Null Then" is equal to
    "If IsNull(MyVar) Then" but I just could not make the mindleap to your
    solution. Many thanks

    "Alex Dybenko" schreef:

    > you can use:
    >
    > if MyObject is nothing then
    > ....
    >
    > or just make own function based on this
    >
    > --
    > Alex Dybenko (MVP)
    > http://Alex.Dybenko.com
    > http://www.PointLtd.com
    >
    >
    >
    > "Jos" <> wrote in message
    > news:...
    > > Hi,
    > >
    > > I find references to the function IsNothing(object) in the helpfile for
    > > Access 97 VBA under IsObject(object), but this function is not present in
    > > VBA
    > > 97. How can I emulate this function?
    > > --
    > > Jos

    >
    >
    >
     
    Guest, Apr 29, 2005
    #3
  4. Guest

    Guest Guest

    Mind Lead? I'm just happy when I get beyond Mind Limp :)

    "Jos" wrote:

    > Alex,
    >
    > It is indeed very simple, I knew that "If MyVar Is Null Then" is equal to
    > "If IsNull(MyVar) Then" but I just could not make the mindleap to your
    > solution. Many thanks
    >
    > "Alex Dybenko" schreef:
    >
    > > you can use:
    > >
    > > if MyObject is nothing then
    > > ....
    > >
    > > or just make own function based on this
    > >
    > > --
    > > Alex Dybenko (MVP)
    > > http://Alex.Dybenko.com
    > > http://www.PointLtd.com
    > >
    > >
    > >
    > > "Jos" <> wrote in message
    > > news:...
    > > > Hi,
    > > >
    > > > I find references to the function IsNothing(object) in the helpfile for
    > > > Access 97 VBA under IsObject(object), but this function is not present in
    > > > VBA
    > > > 97. How can I emulate this function?
    > > > --
    > > > Jos

    > >
    > >
    > >
     
    Guest, Apr 29, 2005
    #4
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. valentine

    Unknown Function Name when calling VBA function from a query

    valentine, Jul 15, 2003, in forum: Microsoft Access VBA Modules
    Replies:
    6
    Views:
    4,655
    valentine
    Jul 16, 2003
  2. Guest

    Find first, find 2nd, find 3rd, etc.

    Guest, Jul 21, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    4
    Views:
    412
    Guest
    Jul 22, 2005
  3. Guest

    debugging code- access/vba cannot find 'macro'

    Guest, Jul 29, 2005, in forum: Microsoft Access VBA Modules
    Replies:
    7
    Views:
    421
    Dirk Goldgar
    Jul 29, 2005
  4. JR
    Replies:
    6
    Views:
    2,576
  5. Number Cruncher

    Using a VBA Variable function from Access table data in Access que

    Number Cruncher, Sep 16, 2009, in forum: Microsoft Access VBA Modules
    Replies:
    5
    Views:
    526
    Banana
    Sep 16, 2009
Loading...

Share This Page