Undefined function in expression

[smig]

Hello all,
It has been many months since I last worked on Access and visited this forum

I now try to rework on an old project but when I try to run some queries I get an error message: Undefined function 'Date' in expression . The same happen for the Format function.
Both are built in Access functions :banghead:

No refernce is missing

Thanks,
tal

 

[Minty]

Sounds like corruption or missing references, double check the references(I know it's not showing them as missing, but...)

Compact and repair.

If that fails try importing all the objects into a new database.

 

[burrina]

Are you sure no references are missing? Have you compiled your code? Any errors if you do?

 

[smig]

No missing references.
The functions works fine in VBA.
Also the Now() function works fine both in Query and VBA code.

 

[MarkK]

Try just go to the references list and re-arrange one of them. See how there are "priority" up and down buttons? Pick a reference. Change its priority. Try your code again. See if that fixes it.

 

[smig]

I removed some references and re-attached them and it seem to be OK now

Thank you for your help