Date & time

[Guest]

On the swichboard of a database, I have this formula in a text box:
(=Format(Date(),"dddd"", ""mmm d yyyy") This then displays the current date
when the database is opened.

The problem is the date appears on some workstations but on others we get
#Name?

Why is this happening??

tia

 

[Ricky Hicks [MVP]]

This is usually an indication of a Missing Library Reference on the machines
displaying the error ...
Check the machines for a reference marked "Missing" ...
If the reference is not needed in the app .. uncheck it.
If the reference is needed .. you will need to install the files associated
for the reference in the proper location and register the files in Windows.

 

[Allen Browne]

Change the Control Source of the text box to:
=Date()
and the Format property of the text box to:
dddd mmm d yyyy

Also, make sure the Name property of this text box is not the same as the
name of any field in the form's RecordSource.

If it still fails, check the references:
http://allenbrowne.com/ser-38.html