Error with date function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have sent a data base to a client and he keeps getting the following error.

Unknown function 'Date' validation expression or default value on
'Processing_List.PL.PL_AOD.

I have set all my forms so that when the user updates the form the PL_AOD
feild for As Of Date. The date that the change was made will be changed to
the current date.

It works great on my system but not on my clients.

What can I do to fix this???
 
Hi.
It works great on my system but not on my clients.

What can I do to fix this???
Click to expand...

Most likely this is due to a missing Reference. This often occurs when the
database is developed on a computer that is configured differently than the
computers where the database is deployed. One way to fix this is to
configure your development computer to match that of your clients' computers
or have your clients configure their computers to match yours. That way the
database will stay compiled when deployed on the other computers. Another
way is to use only the default References and use late binding with objects
that need libraries that aren't the default libraries.

In the meantime, have the clients open the database application. Open the
VB Editor by pressing <ALT><F11>. Select the Tools menu -> References... to
open the References dialog window. If any of the checked References is
labeled "MISSING:" then they've found the culprit. They'll need to write
down the name of this Reference (including path and file name), delete it,
close the References dialog window, open it again, then add the Reference
again, this time using the file path that their computers are configured
with, not yours.

After adding the correct References, close the References dialog window by
selecting the "OK" button, then compile the VBA code by selecting the Debug
menu -> Compile <DatabaseName>. If it doesn't compile without errors then
there are more References to be fixed or there are errors in your code that
need to be fixed.

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.)

- - -
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. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.
 
Back
Top