Results 1 to 5 of 5
  1. #1
    krueck is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    3

    Exclamation Undefined Function "Left" in Expression

    I am using Microsoft Access 2003 on Windows XP. I have a database that has just recently starting giving me the following error:



    Undefined Function 'Left' in expression.

    This error is being thrown anyplace the Left function is called. This happened previously and I fixed it by just unchecking and checking some of the references under the tools menu. (This was a fix I found online.)

    The database is having this issue again (cause? unknown.) and the fix above is not resolving this. Also, during the fix above I unchecked Microsoft Office 11.0 Object Library and when I went back in the object library was not in the list. I selected the 12.0 Office Object library instead, but it made no difference. The error is still occurring.

    I guess I have a couple of questions. Do I need to add the Microsoft Office 11.0 Object library to the list and reference it or will it be fine using the 12.0? Also, any help on my Undefined Expression error would be great.

    This is a production database that produces time-sensitive materials, so any immediate help would be greatly appreciated!

    Thanks ahead of time!

  2. #2
    krueck is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    3
    These are the references that are currently active:

    Visual Basic for Applications
    Microsoft Access 11.0 Object Library
    Microsoft Office 12.0 Object Library
    OLE Automation
    Microsoft DAO 3.6 Object Library
    Utility

  3. #3
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    First off, try this. Make a copy just in case anything goes wrong. Then do a DECOMPILE (see here for more about that: http://www.granite.ab.ca/access/decompile.htm )

    If that doesn't work, then try unchecking the DAO 3.6 reference, closing the dialog and then reopening it and rechecking it.

  4. #4
    krueck is offline Novice
    Windows XP Access 2003
    Join Date
    Sep 2011
    Posts
    3
    Quote Originally Posted by boblarson View Post
    If that doesn't work, then try unchecking the DAO 3.6 reference, closing the dialog and then reopening it and rechecking it.
    I've already tried the unchecking/rechecking of all of the references. This did not help. I will be trying the decompile though.

    I am assuming I need to recompile after the decompile?

  5. #5
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by krueck View Post
    I am assuming I need to recompile after the decompile?
    Not necessary to do explicitly as it will technically do it behind the scenes when you open a form. But you can do it just in case any errors then show up in code because of the decompile which then you can go fix those errors.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 12-05-2011, 05:10 AM
  2. Replies: 8
    Last Post: 08-05-2011, 02:55 PM
  3. Replies: 2
    Last Post: 05-17-2011, 02:40 PM
  4. Replies: 3
    Last Post: 04-10-2010, 10:22 AM
  5. Relocating objects via "Left" properties value
    By Ripcut in forum Programming
    Replies: 0
    Last Post: 08-01-2008, 06:40 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums