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

On Thu, 11 Dec 2008 09:51:01 -0800, Judy-Court Clerk
<JudyCourtClerk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Yes, John, flawed indeed but it's what the Judge wants me to do. However, I
tried it just now and I am getting an error message "Undefined function
'Left' in expression." I don't know what that means. I got the same error
when I tried using 'Right' too. Can you help me? Thanks...

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]
.

Relevant Pages

  • 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)
  • Re: Action Failed for extracting data to append on another table
    ... > I just checked the references on both machines, ... > Microsoft Access 9.0 Object Library ... > Something is still missing. ... Uncheck any that have missing against them. ...
    (microsoft.public.access.queries)
  • Re: Why "Name IsNull is not declared"?
    ... but I am not using VBA I am using VB studio 2005. ... What am I missing? ... This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ...
    (microsoft.public.access.gettingstarted)
  • Re: date functon stopped returning system date
    ... I found no 'missing' in the references. ... "John W. Vinson" wrote: ... This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ...
    (microsoft.public.access.forms)
  • Re: Cannot tranfer Database with Date Function query
    ... and she gets the following error message ... This appears to be the very common References bug. ... Uncheck it, recheck it, close and open Access. ... If none are MISSING, check any reference; ...
    (microsoft.public.access.queries)