Re: unknown function name in query expression
From: Jeff Conrad (jeffc_at_ernstbrothers.com)
Date: 01/18/05
- Next message: MMouse99: "All from data from two tables, where data may not exists in 2nd ta"
- Previous message: Lynn Trapp: "Re: unknown function name in query expression"
- In reply to: Lynn Trapp: "Re: unknown function name in query expression"
- Next in thread: Larry: "Re: unknown function name in query expression"
- Reply: Larry: "Re: unknown function name in query expression"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 Jan 2005 09:18:54 -0800
Ouch, that really does not sound good Lynn!
Well hopefully it won't be that bad for Larry.
We'll just try one step at a time and use that as a last resort.
Thanks for the info.
-- Jeff Conrad Access Junkie Bend, Oregon "Lynn Trapp" <ltrappNoSpam@ltcomputerdesigns.com> wrote in message news:Os4sM%23X$EHA.824@TK2MSFTNGP11.phx.gbl... > 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] > >> > > > > > > >
- Next message: MMouse99: "All from data from two tables, where data may not exists in 2nd ta"
- Previous message: Lynn Trapp: "Re: unknown function name in query expression"
- In reply to: Lynn Trapp: "Re: unknown function name in query expression"
- Next in thread: Larry: "Re: unknown function name in query expression"
- Reply: Larry: "Re: unknown function name in query expression"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
