MS Access 2002 - What happened to the now() function ?

[DropsIT]

I am running MS Access 2002, having migrated from 2000. Quite a few of my queries use the now() function, but this no longer works. It is quoted as a function from the build function in the queries and inserts it into a query just as before - so why is it now giving me the message 'compile error, in query expression now()'

I have to mention that I didn't install this version, so it may be something to do with that but the guys that did have no idea why this isn't working as before either!

 

[KenReay]

Have you checked for missing references? open any code module in design view, choose tools\references and look for any which say Missing

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK