Re: Query Commands not Funtioning (Access 2000)

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 11:03:11 -0700

Date( ) and Right( ) are VBA functions. It's likely that your database
application is missing a library Reference. Open the VB Editor and select
the Tools menu -> References... to open the References dialog window. You
will probably see one of the library names listed, preceded by the word
"MISSING: " to indicate that Access cannot find this file.

If you find that any of the References are missing, note the name of the
file and its location, then uncheck this Reference, then close the
"References" dialog window. Open the "References" dialog window again and
add the Reference from the list (or browse to it). When you are finished,
close the "References" dialog window and compile the code (Debug menu ->
Compile <DatabaseName>).

If you don't find any of the References marked as missing, then attempt to
compile the code first, then open the "References" dialog window to follow
the steps above.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)

"SR Bandy" <anonymous@discussions.microsoft.com> wrote in message
news:2da601c48eb4$659ea610$a601280a@phx.gbl...
> I updated ODBC drivers for SQL software and two commands
> will not function within Access 2000 query: Date() and
> Right (substring command)and possibly some others ???.
>
> I reloaded the old ODBC drivers and Access 2000 has been
> reloaded. I don't understand why commands will not
> function???

Relevant Pages

  • Re: DatePart or multi parameter functions return invalid comma error
    ... check your References. ... Go to any code window and ... See if any of them are marked as MISSING. ... Why does the Northwind database not ...
    (microsoft.public.access.queries)
  • Re: Compile error. in table-level validation expression. (Error 33
    ... Thanks for telling me how to find missing references. ... when I open the window 'References - Access9db' ... >> I've tried compacting and repairing, also copied the database. ...
    (microsoft.public.access.forms)
  • Re: How often to things crawl out of the sea?
    ... (all John's references are places where Scripture is referencing other ... KJV, and they're all there, Tobit and Maccabees and the others. ... really missing or are they simply excluded by the dictates (arbitrary ... Plenty of lots of ancient books are, ...
    (talk.origins)
  • Re: References problem - new variant
    ... I suspect that there is an issue with one of the libraries on that machine. ... Sometimes no libraries show as missing. ... When I open the References window ...
    (comp.databases.ms-access)
  • Re: Help with DCount
    ... Klatuu wrote: ... There's nothing there that I can see thats marked Missing. ... References and see if any are marked *Missing* ... I got an error message up earlier about the Yearfunction I was ...
    (microsoft.public.access.formscoding)