Date Function not working in queries or on Forms

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

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.
 
Top