Dates not showing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form view where user enters data. In this form there is a date field which defaults to todays date. All user except one get the #Name# error in that field. Do I need to re-install Access in her PC again
Thanks in advance...
Shaji
 
I have a form view where user enters data. In this form there is a date field which defaults to todays date. All user except one get the #Name# error in that field. Do I need to re-install Access in her PC again ?
Thanks in advance....
Shaji
Click to expand...

If you are using Date() or Now() as default value ....
The machines may have a missing reference.
Open any module in Design view.
On the Tools menu, click References.
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.
 
THe reason for the problem is probably due to different (office) service
packs on the pc's
Pieter
Shaji said:
I have a form view where user enters data. In this form there is a date
Click to expand...
field which defaults to todays date. All user except one get the #Name#
error in that field. Do I need to re-install Access in her PC again ?
 
I have a form view where user enters data. In this form there is a date field which defaults to todays date. All user except one get the #Name# error in that field. Do I need to re-install Access in her PC again ?
Thanks in advance....
Shaji
Click to expand...

This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.
 
Back
Top