Date Function

[Guest]

Hello All,
I am using the Date() function in a series of forms for a shared database.
All the forms work just fine on my development PC but when I run the form on
a staff PC I get the #Name error when the Date() function is used. There are
other functions that do not work as well.
The installed References are exactly the same on both machines.
Any ideas on how to resolve this?

Thanks in advance.

BRC

 

[Guest]

Hi Brian,

How is the Date() function being called? Is it running within a textbox
control to autogenerate the date/time or is it being called within a code
module?

Also, have you checked the date format on the offending PC to ensure that is
the same as yours?

Plus, could you give us some examples of other functions that are not
working. For example, are they functions that are built into VBA/Access or
are they ones that you have coded?

Lance

 

[Guest]

Thanks for your response,
The Date() function is being used in a text box to set the current date.
I have found that the built in DateDiff function does not work on other
staff computers. It is being used in a text box as well to calculate a
clients age.

=DateDiff("yyyy",[CustDOB],Now())+Int(Format(Now(),"mmdd")<Format([CustDOB],"mmdd"))

The Windows XP Pro date format is the same on all computers.