#Name?

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

Guest

I have an application loading a form containing date and time fields. On
most PCs these display the appropiate data, however on others only "#Name?"
is displayed. The Date Field Properties shows the default value as Date()
and time shows Time(). What am I missing on the non-working PCs or what am I
doing wrong?

Thanks
 
I have an application loading a form containing date and time fields. On
most PCs these display the appropiate data, however on others only "#Name?"
is displayed. The Date Field Properties shows the default value as Date()
and time shows Time(). What am I missing on the non-working PCs or what am I
doing wrong?

Thanks
Click to expand...

Those PC may have a missing reference.
Open any module in Design view (or click Ctrl + G).
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.

For even more information, see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 
fredg said:
Those PC may have a missing reference.
Open any module in Design view (or click Ctrl + G).
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.

For even more information, see
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
Click to expand...
Fred....That was exactly the info I was looking for. Thanks for the help!
 
Back
Top