#Name appearing when using Date()

[theprez]

I have a form that is using the Date() function in one of the fields. This was working fine, but the customer installed some other application and now instead of showing todays date, the dreaded #NAME? is showing up. Can anyone give me any idea what library may be having this problem. I found a post referencing run-time error 3075, but there was no real resolution here. I'm really desparate. Can anyone help?

 

[ghudson]

Check for any missing references.

Open any module. Then from the menu bar, click Tools, then click References... find and reselect any references that are at marked "missing".

 

[theprez]

The customer is running an .MDE version and we don't believe there are any missing references.

 

[ghudson]

The customer is running an .MDE version and we don't believe there are any missing references.

Did you at least verify if there are any missing references? Common function errors like Date(), Left(), etc. always point to a missing reference.

the customer installed some other application

That spells a reference or DLL problem. Try reinstalling Access if you have verified that there are no missing references.