Err Msg: 3320--Function is not availabe in expressions in table-l

[Guest]

I am having a problem which results in the following error: "Function is not
valid in expressions in table-level validaton expression."

I refreshed the refrences and then created an mde file. The mde file works
on all versions of Access that's NOT using Vista. When I launch the program
in Vista, I get the error message again, so I refreshed the refrences on the
Vista computer and then created an mde file. This solved the problem for the
Vista version of the program, however, that mde program cannot be used in the
Non-Vista version anymore.

Any help in resolving this issue would be appreciated. Thank you in advance!

 

[Tony Toews [MVP]]

I am having a problem which results in the following error: "Function is not
valid in expressions in table-level validaton expression."

I refreshed the refrences and then created an mde file. The mde file works
on all versions of Access that's NOT using Vista. When I launch the program
in Vista, I get the error message again, so I refreshed the refrences on the
Vista computer and then created an mde file. This solved the problem for the
Vista version of the program, however, that mde program cannot be used in the
Non-Vista version anymore.

What version of Access? What references do you have? Are there any
differences between the references on the non Vista system vs the
Vista system?

Use the following code to place the current references in the debug
window.

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " " & ref.FullPath & " " & _
ref.Major & "." & ref.Minor
Next ref

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/