Date Function not working in queries or on Forms

[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!!!

 

[Van T. Dinh]

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.

 

[Peter R. Fletcher]

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.