Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    South Africa

    Question Unanswered: Function Date() not recognised

    I keep getting this error message: function 'DATE' not recognised.
    It seems to only be a problem with Access 2000.
    How do I stop it from giving the error message without installing another version of Access
    thanks in advance

  2. #2
    Join Date
    Nov 2003
    Go into the VBEditor and do a Compile (menu: Debug | Compile {database name}). It should show you where the error is.

    Check your References (menu: Tools | References). Make sure there are none that state they are MISSING. If there are, uncheck them. Also, make sure your DB is referencing (has checked) at least these items:
    • Visual Basic For Applications
    • Microsoft Access nn.n Object Library
    • Microsoft DAO n.n Object Library
    • Microsoft Windows Common Controls n.n
    Try changing the Date() function to the Now() function and see how that works.

    Last edited by CyberLynx; 11-29-04 at 12:07.

Posting Permissions

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