Unknown function 'Date' in validation expression or default value on ...

[Almis123]

Hello,



Nice to see you, congratulations with New Year 2022!

I'm newcomer here and I hope here is a place for some questions about my hobby Access
I have an old PC with installed Access 2000 so it's time to play ...

After building the db for my work (now it is in device repair service)
I cannot make Access to print a report - I'm getting a message



Unknown function 'Date' in validation expression or default value on 'Saskaitos.Pardavimo data'.
Pls find attachments, I cannot get what is te reason, everything looks fine in that Table...






hmmm. ...... where is the mistake ????

BR,
Almis

[June7]

The = sign is not needed but should work.

Possibly there is a missing library reference. Open VBA editor > Tools > References > check if any have MISSING prefix.

[Almis123]

..here we are having some Missing library, pls check the pic.
Could you pls suggest the next step

[ranman256]

when simple normal functions dont work, its usu a bad Reference.

[pbaldy]

Try to uncheck the missing DAO 2.5 reference and check the DAO 3.6 reference a few lines down.

[Almis123]

It's working after uncheck of missing DAO 2.5 ... !!!
No more mistake unknown function 'Date' .... and the new dB records now having the right date,
even the printing start working.

Thanks everybody helped.

BR,
Almis