DATE FIELD ERRORS IN ACCESS RUNTIME

[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, 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? I have checked the
references library, and it does not appear there is any missing one.

 

[Guest]

Hi.

"Function is not available in
expression in table-level validation expression."

In general, this error message is caused by using a non-built-in function in
the table constraint. However, if you didn't use any non-built-in functions
in this table constraint, then I would suspect a missing reference. MDE
database files are more sensitive to reference libraries being located in
directories on the target computer different than on the development
computer, because the code can't be decompiled to accommodate a newly
resolved reference.

Check your development computer and the target computer. Are the paths of
each library identical on both computers? If not, changing one computer's
configuration to accommodate the other will fix the broken references. Since
you control the installation of the Access Runtime, you can make the target
computer match your own configuration. You may also be able to use late
binding for the non-default references. For a list of other techniques that
will prevent missing references, please see the following Web page:

http://www.trigeminal.com/usenet/usenet026.asp?1033

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.