Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 29th, 2004, 07:25 PM
Authorized User
Join Date: Oct 2004
Posts: 59
Thanks: 0
Thanked 0 Times in 0 Posts

Morris & Paumir-

You'll also get this error if your project isn't compiled and you have an error in your code. Open any module in the Visual Basic Editor and choose Compile from the Debug menu. Checking Tools / References is also a good idea. You typically don't need the Utility library (an artifact in a database converted from Access 97 or earlier). Don't dink with the VBA library - the one checked at the top of the list is usually the correct one for your release. If you have any marked "Missing", uncheck those and try to compile the project.

If all this fails, create a new database and import all the objects from the old one to get rid of any corruption.

John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
Old October 30th, 2007, 05:05 PM
Registered User
Join Date: Oct 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts

I had the same problem with "Undefined Function Left in Expression" error in my Access 2003 database when opening a particular form. The underlying query was fine. It was the form itself which was choking when opening it. I didn't use the LEFT function anywhere in this particular form so it was driving me nuts. Oh, and the problem only occurred for 2 out of 20 users using the same database.

J Lovell's suggestion to uncheck any missing references (VBA -> Tools -> References) worked for my particular problem (at least for one user it did. I'm still waiting to test the other user)
Old October 31st, 2007, 06:35 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Just for another two cents here, I find I sometimes need to do this in the query builder:

PrimeDiag:(Left([FCE Primary Diagnosis],5))



Look it up at: http://wrox.books24x7.com
Old July 23rd, 2008, 02:07 AM
Authorized User
Join Date: Jul 2005
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts


This is my observation to the issue:
I made some testing with Office 2007 to older Access files (2000).
Did not save the old, but just converted to 2007 version and saved it.
I got the same "Undefined Function Left (Mid, Right)" when trying to start with older Access.
In this case also Outlook library is chosen and it seems that 2007 changed the library to ver 12 (from ver 9) and this halted my queries and modules.
I had to go to Tool-References and tick-Off Outlook ver 12 and tick-on Outlook ver 9.

So be cautious if you try new Office version to older programs that are still in production.
My advice is take to a copy with older software first and test that copy only with your new Office programs.

Have a nice summer.

Similar Threads
Thread Thread Starter Forum Replies Last Post
Undefined function 'Left' in expression MountainProud Access 4 October 23rd, 2006 10:48 AM
undefined function vurtman ASP.NET 1.0 and 1.1 Basics 8 October 4th, 2004 01:32 PM
Undefined function dhborchardt Classic ASP Databases 0 June 7th, 2004 03:31 PM
Undefined functin left greenfish Access 2 March 24th, 2004 11:51 AM
undefined function: mysql_connect() shabboleth Beginning PHP 2 September 18th, 2003 05:09 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.