Results 1 to 5 of 5

Thread: Date() function

  1. #1
    Join Date
    Jun 2003
    Posts
    3

    Unanswered: Date() function

    Help!!! Getting error message that says - Unknown function 'Date' in validation expression or default value on 'HOSPITAL.date added' . I've looked for any missing library references as recommended on a previous thread but all are present. Does anyone have any ideas??

  2. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    when you say all are present is DAO checked on the list before ADO?

  3. #3
    Join Date
    Jun 2003
    Posts
    3
    The references that are checked are

    Visual Basic for Applications
    Microsoft Access 10.0 Object Library
    Microsoft DAO 2.5/3.51 Compatability Library
    utility
    OLE Automation
    Microsoft Visual Basic for Applications Extensibility 5.3
    Microsoft Office XP Web Components

    That is the order in which they appear at the top of the references list.

  4. #4
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5
    scroll down and check Microsoft DAO 3.5 or 3.6
    uncheck the 2.5
    The date function should work fine






  5. #5
    Join Date
    Jun 2003
    Posts
    3
    Originally posted by axsprog
    scroll down and check Microsoft DAO 3.5 or 3.6
    uncheck the 2.5
    The date function should work fine



    It works fine now. Many thanks for your help

Posting Permissions

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