access 2000 with xp

[GezB]

Can anyone tell me why I get this error msg or better still how to avoid it.
I have an access 2000 db which works fine in windows 1998 but when I try to run it on my other computer running windows XP i keep getting the following error msg;
"Function is not available in expressions in table-level validation expression"

thanks

Gez

 

[Jack Cowley]

Open any code page where you see the Debug menu. Select Tools > References and uncheck any items marked "MISSING".

hth,
Jack

 

[nelslynn]

Can anyone elaborate on this problem? I am having a similar problem with Access 2000 on XP OS.

The problems include:
- "#name?" in fields where the data source includes the Trim function.
- "#Name?" when using the Date() function.

When I take out the Trim and change Date() to Now() everything works. I have checked the references and there are no MISSING references.

 

[Rich]

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html