Re: unknown function name in query expression

From: Lynn Trapp (ltrappNoSpam_at_ltcomputerdesigns.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 11:02:51 -0600

Jeff,
A couple of years ago, I experienced a problem getting to the references
screen. I don't remember if the error message was the same as the OP's, but
it required reinstalling Access to fix. 

-- 
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
"Jeff Conrad" <jeffc@ernstbrothers.com> wrote in message 
news:Ouv%23s3X$EHA.3700@tk2msftngp13.phx.gbl...
> 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: 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)
  • Re: unknown function name in query expression
    ... Does the error message occur when you open any module, ... You might have some VBA corruption in your database. ... Make a backup copy of this database before doing anything else. ... >> This appears to be the very common References bug. ...
    (microsoft.public.access.queries)
  • Re: unknown function name in query expression
    ... >>I'm getting an error message when running a query that uses the NOW ... > This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ... > If none are MISSING, check any reference; ...
    (microsoft.public.access.queries)
  • Re: How to display only 3 letters of a last name in field
    ... tried it just now and I am getting an error message "Undefined function ... This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ... If none are MISSING, check any reference; ...
    (microsoft.public.access.queries)
  • Re: Cannot tranfer Database with Date Function query
    ... and she gets the following error message ... This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ... If none are MISSING, check any reference; ...
    (microsoft.public.access.queries)