Re: How to display only 3 letters of a last name in field



***********************************************
Okay, do you want to know which lines are "checked" in the reference window?

Yes... particularly the MISSING one.

I can do the task of unchecking the MISSING one, go to VB/Debug/Compile (I've
never done this before) and see what happens? I am working on my home
computer if that makes any difference, I have the same version as my work
file.
Judy

The problem is that the reference may be perfectly fine on your computer and
missing on the work computer.

The References are the "extra" program libraries that Access needs to do its
work. At the very least you should have the standard ones checked: Visual
Basic for Applications, Microsoft Access <version> Object Library, OLE
Automation, and Microsoft DAO <version> Object Library.

What may have happened is that at some point you installed some sort of
add-in
or additional library; if that library existed on the computer where you
first
installed it, but does not exist on your work computer, it's "missing".
Unfortunately if the VBA engine has a missing reference anywhere, references
in other libraries can get messed up too. The Left() function is in the
Visual
Basic for Applications library, but even if that library is checked and not
missing, VBA may not be able to find it if some OTHER library is missing.
--
John W. Vinson [MVP]
**********************************************
I have 6 lines checked: Visual Basic - MS Access Obj Library - MS DAO
Library - MS VBA Extensibility 5.3 - MS forms Obj Library - MISSING: MS
Word Obj Library. I don't see OLE Automation... So, am I stuck? We're a
small court, I should probably just do it in Excel, huh? :-(
.

Relevant Pages

  • Re: How to display only 3 letters of a last name in field
    ... The missing reference may really BE missing. ... If you uncheck the MISSING one and leave it unchecked, ... The References are the "extra" program libraries that Access needs to do its ...
    (microsoft.public.access.queries)
  • Re: References In Access
    ... will NOT remove a missing reference, ... the VBA or Access ... >References to Type Libraries." ...
    (microsoft.public.access.modulesdaovba)
  • Re: Excel XP 2001 vs Excel XP 2002
    ... Check to see if any libraries are marked ... If you need the reference, close ... Microsoft MVP - Excel ... Am I missing a patch? ...
    (microsoft.public.excel.programming)
  • Re: Mid function used in query and report undefined
    ... Any missing reference can lead to problems with VBA functions. ... Access searches through all of the referenced libraries until it ...
    (microsoft.public.access.modulesdaovba)
  • Re: References problem - new variant
    ... Sometimes no libraries show as missing. ... Open the database and add the reference again. ...
    (comp.databases.ms-access)
Loading