Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

why do I get the error : #name?

why do I get the error : #name?

why do I get the error : #name?

I get the error : #name? in a text-field which should
show the standard value which is =Date()
There are several users where the field shows the correct date, only one user has this problem.
How do I solve this???

RE: why do I get the error : #name?


Check this user's references.  It may be that their reference to Visual Basic for Applications is missing.


RE: why do I get the error : #name?

Thank you Chopper,

the user's refeference is ok.
I suspect the problem has something to do with the fact that
this problem user is using NT and all the other users use
win95 or win98.

RE: why do I get the error : #name?

I've seen this come up many times and everytime (so far!) the individual user's references have not been the same as the people who were not having the problem. Please post here if you find it is something else.

RE: why do I get the error : #name?

Check the versions of the following two files in on the users machines with the problems:


Try copying the versions from a working machine to the ones that are not working (rename first). This happened to us, and took me weeks to find, but when we switched (or in some cases, added) the files, it took care of the problem.

Worth a shot.

Jim Lunde
Custom Application Development

RE: why do I get the error : #name?

Try putting NOW() instead of DATE()  ... it should work

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close