Function Is Not Available in Query Expr

  • Thread starter Thread starter Mike Thomas
  • Start date Start date
M

Mike Thomas

In Access 2000 we have an update query which populates a date field in the
target table using the Date() function. The SQL code is at the bottom of
this message.

This has worked fine for weeks, and works on all computers but the
development computer. It worked correctly there until an hour or so ago.
Now, when we run the query, we receive an error

"Function is not available in expressions in query expression 'Date()'"

I think the libraries are set correctly:
Visual Basic for Applications
Microsoft Access 9.0 Object Library
Ole Automation
Microsoft DAO 3.6 Object Library

We uninstalled and reinstalled Office 2000 to no avail.

Does anyone know what might be causing this??

Many thanks
Mike Thomas


INSERT INTO POHead ( ImportHeadKey, ShipToKey, SupplierKey, DateDue, PODate,
[By] )
SELECT CreatePO0.ihpk, CreatePO0.ShipToKey, CreatePO0.SupplierKey,
CreatePO0.RSD, Date() AS Expr2, GetWorkStationInfo() AS Expr3
FROM CreatePO0;
 
Back
Top