date functon stopped returning system date

[Dave]

The keyword 'date' is a null when I tried to use it in a command. It worked
until now, anything changed? I am using Access 2007 on both a 2003 db and
2007 db. The actual command is:

If Right(Year(Date), 2) = txtEYear Then txtEYear = ""
....

 

[Ken Snell \(MVP\)]

You probably have a field or control named Date in the form that is using
this If expression. That will confuse ACCESS as it will use that
field/control in the expression. Change the name of that field/control to
something else.

 

[Dave]

I researched my form and my VP code for the form and have no mention of
"date' as a field. Where to next?

 

[John W. Vinson]

I researched my form and my VP code for the form and have no mention of
"date' as a field. Where to next?

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.

 

[Dave]

Thanks for your prompt reply. I found no 'missing' in the references. I
unchecked one of them, rebooted, checked the one I unchecked, rebooted and
the problem remains. The only other possible 'change' was that when I
upgraded to Office 2007, I converted the db from .mdb to .accdb - I cannot
remember if I used this form after that.