Date function doesn't work in Access 2002

[Lynn]

My Office XP is uptodate with SP's, perhaps the church's
isn't? Anyway, I copied a DB that worked perfectly on my
PC to the Church PC. The date functions don't work.
Get "invalid function in expression" error message.

 

[fredg]

My Office XP is uptodate with SP's, perhaps the church's
isn't? Anyway, I copied a DB that worked perfectly on my
PC to the Church PC. The date functions don't work.
Get "invalid function in expression" error message.

The machine 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.

 

[Guest]

-----Original Message-----


The machine 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.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.

But I copied the WHOLE DB file to the Church PC. How
could a reference go missing?

 

[fredg]

But I copied the WHOLE DB file to the Church PC. How
could a reference go missing?

It's the Church's computer references that is missing the reference,
not yours.

The other computer may be a different version of Access with different
references needed, or it simply lost where the library is placed. It
may not even be a reference to a library needed by your database.

Didn't you ever misplace anything?

The computer did and now it has to either find it again, or if it's an
un-needed reference, remove it from the Reference file completely
(when you un-select the MISSING reference).