Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

=Date() still

Status
Not open for further replies.

Sjoker

Programmer
Aug 4, 2000
30
0
0
NL
The specific problem is that a user starts an Access97 .mde<br>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<br>should show the standard value which is set to =Date().<br>Instead of the date the value in the text field is #name?.<br>All other users use win95 or win98 and the don't have this problem.
 
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.<br><br>Copy these two files from your C:\Windows\System folder<br><br>Comctl32.ocx<br>Comdlg32.ocx<br><br>If they exist on the user machine, rename them (like comctl32.ocx.old)<br>Paste your two files in the user's C:\Windows\System folder.<br><br>This did it for us. The user's had older versions of these .ocx files. <br><br>Don't know if this is your problem, but it is worth a shot.<br> <p>Jim Lunde<br><a href=mailto:compugeeks@hotmail.com>compugeeks@hotmail.com</a><br><a href= Application Development
 
dennie<br><br>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.<br><br>HTH - <br><br>jima&nbsp;&nbsp;&nbsp;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top