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.
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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
=Date() still
- Thread starter Sjoker
- Start date
jimmythegeek
Programmer
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
work - plus, Now() is a Date/Time function that can be formatted to display useful info.<br><br>HTH - <br><br>jima - Status
Similar threads
