Queries don't work after moving database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm befuzzled. I moved an Access 2000 database from my old laptop (W2K, SP3) to my new laptop (also W2K, SP3) and now my queries that use the RTRIM() function no longer work.

I receive the following error message - "Function is not available in expressions in a query expression ([Volunteers].[LNAME] & RTRIM(' ' & [Volunteers].[SUFFIX]) & ', ' & [Volunteers].[FNAME] & ' ' & [Volunteers].[MI]) AS NAME FROM Volunteers WHERE [Volunteers].[ID]=[Forms]![Team Master].Leader

The queries work when I remove the RTRIM() function but I really need this particular fucnction. I've ensured that the same service packs for Office 2000 have been installed on both laptops but I think that the Visual Basic for Applications is involved somehow.

Anyone have any ideas/solutions?

Sincerely, Frazzled
 
Bill ("Fraz")

Access sometimes looses track of where the reference libraries are located.

Open a code module and try Compiling. You'll probably get the same message
about missing functions. If so, select Tools | References.

I suspect at least one of them will show as "MISSING" (but checked). Make
note of all that are checked.

Uncheck any MISSING and <Save> (Access won't let you uncheck all).

Reopen References and recheck those you unchecked. Re<Save>.

Compile.
 
Thanks Jeff! That was exactly the ticket!

I checked the libraries and one (Outlook) was missing. I
unchecked the library and thing are working fine now.
Thanks a lot for your assistance. It is much appreciated!

-Bill
 
Back
Top