Date() Function problem

[maniaouri]

My problem maybe very simple but I cannot solve it.In the database I was working suddenly the date() function disappeared.I searched the references of the project but there is noone missing or having problems.What do you suggest?How can I insert it again?Does anyone know the dll or the reference which contains it?

thanks

 

[MStCyr]

My problem maybe very simple but I cannot solve it.In the database I was working suddenly the date() function disappeared.I searched the references of the project but there is noone missing or having problems.What do you suggest?How can I insert it again?Does anyone know the dll or the reference which contains it?

thanks

Good morning

Since it is not a reference problem, have you tried a simple repair and compact? ... or you could create a blank database and import all of the objects from the offending database. Failing everything else, you could try uninstalling Access and reinstalling it.

Best regards

Maurice

 

[Rich]

You almost certainly have a missing/broken reference. Just uncheck one of the existing references, compile and save, compact the db and you should get hey presto