Date Function not working in queries or on Forms

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

It behaves if though a Reference were missing. However, I
check all the references and they are okay.

When Access evaluates the date function in a query, I get
an error "Undefined Function 'Date' in expression" When
the date is on a form I see the traditional "#Name" that
you see with an unrecognized field name.

However the date function works fine in the debug window.
The last thing I noticed,and perhaps the strangest,is the
problem doesn't happen on all machines AND it doesn't
happen on all profiles of a Windows XP machine. (Maybe
only one user is having the problem)

Does anyone have any ideas?? Please let me know. Thanks!!!
 
It still can be problems with the References Collection.

Try adding a Reference then OK to accept and get out. Get back in and
deselect the same Reference and OK.

Alternatively, try deselecting a selected Reference (note the name) then OK
to get out. Get back in and re-select the Reference and then OK.
 
It really does look like a Reference Problem. Be aware that if a
Reference library is not found, none of the References "below" it on
the list of included references will even be looked for, so one bad
Reference, even to a library that is not actually used in your code,
can screw you up badly.
 
Back
Top