Results 1 to 9 of 9
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Unknown Date() / Now() Function (Access 2000)

    Hi,
    On my PC, I have a number of small DB's. In one particular DB (the one I attached), I am attempting to create a validation rule in the table by using " >=Date() ". On saving the change, the DB pops up an error message saying, " Unknown function : " Date() " in validation expression or default value ". I tested this with the Now() function, and the same message appeared???

    When I set up the same validation in another DB on the same PC, then the rule works! Any idea why this one DB does this???
    Regards,
    Rudi

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Unknown Date() / Now() Function (Access 2000)

    Check the References!
    Regards
    John



  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unknown Date() / Now() Function (Access 2000)

    That problem is almost always caused by a broken reference. This one is no exception.
    - Activate the Visual Basic Editor.
    - You'll get a warning. Click OK.
    - Select Tools | References...
    - You'll see one of the reference starting with MISSING: ...
    - Clear its check box.
    - Click OK.
    The problem should now be gone.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unknown Date() / Now() Function (Access 2000)

    You mean the VBA references. If it is these...then which one am I looking for?
    Regards,
    Rudi

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unknown Date() / Now() Function (Access 2000)

    Aah Ha... got it.

    It was MISSING: DAO library.... I cleared it and it is now working...

    TX a stack John and Hans
    Cheers
    Regards,
    Rudi

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unknown Date() / Now() Function (Access 2000)

    It's the standard reply to this question... <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  7. #7
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unknown Date() / Now() Function (Access 2000)

    Agreed that the reply was standard, but Rudi is missing the DAO library?! That is a pretty serious library to be lacking... I would think that a re-install of MS Access might be in order.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Unknown Date() / Now() Function (Access 2000)

    No, there was a missing reference to the Microsoft DAO 2.5/3.5 Compatibility Library. This wasn't needed. There was a valid reference to DAO 3.6.

  9. #9
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Cincinnati, Ohio, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unknown Date() / Now() Function (Access 2000)

    Whew. That does make a big difference. I missed that from his earlier message, and I didn't download the original attachment.

Posting Permissions

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