Re: Problem with Function Date() in query
From: fredg (fgutkind_at_example.invalid)
Date: 04/29/04
- Next message: DSmith: "Appending two tables"
- Previous message: MGFoster: "Re: Please help with a query"
- In reply to: Rafał: "Problem with Function Date() in query"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 21:06:00 GMT
On Thu, 29 Apr 2004 19:59:24 +0200, Rafał wrote:
> I have an updated query where function Date() is used.
> With Access XP(full instalation) query works OK.
> With Runtime I got the error 3075:
> "Function can not be used in query"
>
> Can anybody help me?
>
> Rafał
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.
- Next message: DSmith: "Appending two tables"
- Previous message: MGFoster: "Re: Please help with a query"
- In reply to: Rafał: "Problem with Function Date() in query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
