Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009

    Question Unanswered: PC setup problem access 2007

    I have an MDE that works on one PC with access 2007. when I run it on a different PC with access 2007 I get "Function is not available in expressions in query expression 'Date('.".

    The MDB was written using access 2003 and works fine on PC's with access 2003.

    I did this 2 years ago and can't remember what I had to set on the access 2007 PC

    Any help will be appreciated.

    Thank you.

  2. #2
    Join Date
    Nov 2007
    Adelaide, South Australia
    Sounds like it might be a references issue if Date() isn't working... and the right bracket missing is a typo.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2009
    Thanks for the response, I'll be working on it tomorrow.

Posting Permissions

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