System Date

[THAWK]

Help!

I have a very simple query which works in all of my other databases except one, where on the click of a button it updates a field with the date.

However for some reason this one databse is unable to understand the commend Date, it's like it can not read from the system, however the code "Now" works, but that's too much information I only want the date.

Code: Me.LetterSent = Date

I have tried Date() just incase but the bracket just get removed.

Is there some setting that I have disabled on my database so it does not recognise the command date?

 

[ted.martin]

Is this due to some users having Access 2003 and others Access 2007. I have had a probelm like this in the distant past. You could always use me.lettersent = format(Now(),"Medium Date")

 

[DCrake]

Look at Tools and references you may have something missing

David

 

[THAWK]

Looked at the references but can't find what's missing, so going to use the now() function, how frustrating. Thank you for your help.