×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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

=Date() still

=Date() still

=Date() still

(OP)
The specific problem is that a user starts an Access97 .mde
from a network drive. This specific user has NT as OS and when it opens de .mde in the startup form in a text-field it
should show the standard value which is set to =Date().
Instead of the date the value in the text field is #name?.
All other users use win95 or win98 and the don't have this problem.

RE: =Date() still

This sounds strange, but we had a similar issue, and it was two .ocx files. We got the #Name? error every place the Date() function was used, including forms and reports.

Copy these two files from your C:\Windows\System folder

Comctl32.ocx
Comdlg32.ocx

If they exist on the user machine, rename them (like comctl32.ocx.old)
Paste your two files in the user's C:\Windows\System folder.

This did it for us. The user's had older versions of these .ocx files.

Don't know if this is your problem, but it is worth a shot.

Jim Lunde
compugeeks@hotmail.com
CompuGEEKS
Custom Application Development

RE: =Date() still

dennie

As an option to the above you can replace Date() with Now() and will probably:) work - plus, Now() is a Date/Time function that can be formatted to display useful info.

HTH -

jima   

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