=Date() not working

  • Thread starter Thread starter Gavin
  • Start date Start date
G

Gavin

Hello all.

I have a textbox with the control source =Date()
which I want it to display today's date, but all that
displays is #Name?
Does anyone know how I can fix this? The textbox works on
another computer.

Thank you,
Gavin
 
Hi Gavin

This is probably caused by missing references. Open a VBA code window and
click Tools>References. See if there are any checked references near the
top of the list marked "MISSING". If so, first try unchecking that line and
compiling your project - it's possible the reference is not being used
anyway. If it won't compile, then you must instal the missing file on the
culprit computer.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.
 
Thanks, actually, I fixed the problem somehow...I
registered a few of the .dll files and I thik it did the
trick
-----Original Message-----
Hi Gavin

This is probably caused by missing references. Open a VBA code window and
click Tools>References. See if there are any checked references near the
top of the list marked "MISSING". If so, first try unchecking that line and
compiling your project - it's possible the reference is not being used
anyway. If it won't compile, then you must instal the missing file on the
culprit computer.

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.

Hello all.

I have a textbox with the control source =Date()
which I want it to display today's date, but all that
displays is #Name?
Does anyone know how I can fix this? The textbox works on
another computer.

Thank you,
Gavin
Click to expand...


.
Click to expand...
 
the #Name can also be called if the name of the text
control matches a name in the forms dataset.
 
When you add References, Access updates the References Collection and
removes the corruption(s). In fact, Douglas J. Steele advised that when you
have the Reference Errors and no Reference is marked as missing, uncheck a
Reference, get out, get back in and re-check the unchecked Reference to get
rid of the errors.
 
Back
Top