Results 1 to 3 of 3

Thread: invalid use of null

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    9

    invalid use of null

    Hi all,

    i've got a error about the following statement in MS Access, the message was "invalid use of null".... i just don't understand what that means.. can any help?
    PERID = DLookup("PERID", "tbApp", "APPLICATIONID=" & lngAppID)


    regards

  2. #2
    Fanatic Member kaihirst's Avatar
    Join Date
    Jul 2005
    Location
    The Resaurant At the End of The Universe
    Posts
    633

    Re: invalid use of null

    Hi,

    the statemetn look sok, but it could have something to do with your database and a null reference in there.

    ta

    kai
    As the information I give is useful in its nature, consider using the RATE POST feature located on the bottom left of this post please..

    A few things that make a good Developer a Great One.
    Methodical and a thorough approach to research and design inevitably leads to success.
    Forward thinking is the key to Flow of control.
    Never test in the design environment, always test in real time, you get the REAL results.
    CBSE & OOSE are the same animal, they just require different techniques, and thinking.
    SEO is a globe of objectives, SE rankings is an end to a means for these objectives, not part of them.
    The key to good design is explicit attention to both detail and response.
    Think Freely out of the "Box" you're in..... You will soar to better heights.

    Kai Hirst - MSCE, MCDBA, MCSD, MCP, MCAP, MSCT


  3. #3

    Thread Starter
    New Member
    Join Date
    Oct 2005
    Posts
    9

    Re: invalid use of null

    the error will not occurs when there is a record in table "tbApp". But for the first time will always no record. can u teach me how to handle 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
  •  



Click Here to Expand Forum to Full Width