Query Commands not Funtioning (Access 2000)

  • Thread starter Thread starter SR Bandy
  • Start date Start date
S

SR Bandy

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???
 
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!)
 
It worked! Thanks for explaining the VBA fix. I thought
it might be a DLL problem, but didn't know where to start.

SR Bandy
 
You're welcome. Glad it helped.

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!)
 
Back
Top