Re: unknown function name in query expression

From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 09:01:17 -0800

Hi Larry,

Humm...this does not sound good.
Does the error message occur when you open any module, or just the one?
You might have some VBA corruption in your database.
Make a backup copy of this database before doing anything else.
Try importing all objects into a new database container, compile, and then compact the new database.
Do you still get the error message when opening that (or any) module?

We may need to decompile your database, but try the above first. 

-- 
Jeff Conrad
Access Junkie
Bend, Oregon
"Larry" <Larry@discussions.microsoft.com> wrote in message
news:C86184C9-6477-43D1-AF68-272B9171AE78@microsoft.com...
> My attempts at this have been unsuccessful:  I get an Invalid data format
> when I try to open the module. Then when going to Tools References and
> unchecking a reference, I get the message that it can't perform the requested
> operation.  This happens if I select one or unselect one.
>
> "John Vinson" wrote:
>
> > On Mon, 17 Jan 2005 15:17:04 -0800, "Larry"
> > <Larry@discussions.microsoft.com> wrote:
> >
> > >I'm getting an error message when running a query that uses the NOW()
> > >function.  The error message is "unknown function name in query expression".
> > >This stopped working today for all queries and reports that have the NOW()
> > >function in them.  Is there a bug in Access 2000 that causes this?  Please
> > >help.
> > >
> > >Thank you.
> >
> > 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.
> >
> >                   John W. Vinson[MVP]
> >

Relevant Pages

  • Re: unknown function name in query expression
    ... that really does not sound good Lynn! ... > A couple of years ago, I experienced a problem getting to the references ... >> Does the error message occur when you open any module, ... >> Make a backup copy of this database before doing anything else. ...
    (microsoft.public.access.queries)
  • Re: DBD::Informix 2003.04 AIX4.3.3 SELECTIVE TEST ERRORS
    ... one which you could fix by removing the database). ... The bug report is below. ... > Informix Server Entries in sqlhosts file ... > # Error Message: ...
    (perl.dbi.users)
  • Re: unknown function name in query expression
    ... I experienced a problem getting to the references ... > Does the error message occur when you open any module, ... > Make a backup copy of this database before doing anything else. ... Uncheck it, recheck it, close and open Access. ...
    (microsoft.public.access.queries)
  • Re: Module Not Found
    ... Close the database. ... Still in the code window, choose Compile from the Debug menu. ... The error message could be related to something else that is going on, ... VB and press the cancel button I receive the error message ...
    (microsoft.public.access.formscoding)
  • Re: Undefined function Left in expression
    ... > I'm getting a weird error message and I don't know when the problem started ... My database is just a contact ... The arch-nemesis of Access is missing references. ...
    (microsoft.public.access.reports)