Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    3

    Question Unanswered: Date function in what dll

    I created a multi-user database. When this database is opened, it automatically performs and update query to insert todays date into a field using the Date() function. It works for everyone except 2 people. It gives them a run time error (3075) Function isn't available in expressions in query expression 'Date. My guess is that it can't find the dll on their machine. Does anyone know what dll the Date function is in so I can check?

    Thanks,
    Cheri

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Go onto the machine(s) in question and view code for any report or form then pull up the Reference under tools and look at any MISSING: library references ... Load as necessary.
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    Aug 2004
    Posts
    3

    Thumbs up Thanks

    Thank you so much! I installed the dll and they work fine!

    Cheri

Posting Permissions

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