DATE/TIME ERRORS

[Guest]

Hi Guys,
I have Office XP Developer (2002) on my PC using Windows XP. I developed a
small program with Access and it worked fine. I converted it to an mde file
before packaging with the Packaging Wizard, including Access Runtime. Alas,
when I setup the packaged program in another PC (also using Windows XP), my
Date and Time fields (those defaulting to system date using Date() and
Time()) on
my form showed #Name?, and error message: "Function is not available in
expression in table-level validation expression." After this error message,
the field would then accept a date input.
Could it be that I missed something during the packaging process? I have
checked the references library, and it does not appear there is any missing
one.

 

[Douglas J. Steele]

Unfortunately, if you've packaged it as an MDE, you're unable to check the
references on the other machine (which is where the problem occurs!)

I give a suggestion for one way to check with MDEs at
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html