Date() in query result in error on other computer 1

[WillemdeNie]

The following query is used in my application:
UPDATE Tbl_box SET Tbl_box.Vrij = False, Tbl_box.[Vrij vanaf datum] = Null, Tbl_box.[Vrij t/m datum] = Null
WHERE (((Tbl_box.[Vrij t/m datum])<=Date()))
WITH OWNERACCESS OPTION;
It does not cause any problems.

If I put this application on a other computer this query results in an error message which sais this function is not available in the expression: (((Tbl_box.[Vrij t/m datum])<=Date()))
Both machines have Access 2002 (NL) installed and both machines have Windows XP Home SP 2 (Dutch)

 

[PHV]

Check the missing references:
while in VBE, menu Tools -> References ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[WillemdeNie]

Great! It works a dll was missing!