Wrox Programmer Forums
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 March 23rd, 2004, 03:11 PM
Registered User
Join Date: Mar 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Undefined functin left

Have similar problems to a July 2003 posting where I cannot run certain queries in a newer version of Access (2000). The error I get is "undefined funtion left in expression". The posting recommended opening a new Module, go to Tools, References and check utility box. Did that and the query still does not work. Please HELP!!!!!

Please consider that I write queries instead of code and if I must write one tell me where to put it....nicely!


Old March 23rd, 2004, 06:54 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts

Okie dokie - I'm guessing you work fo a rather large company. The reason I think that is that most big companies seem to think the few extra MB needed to install Office with all the options would take up too much space on a hard disk that is probably about 40GB.

So there's a chance you might not have all the required classes.

Here's a fairly simple way to check if you've actually got it (and I'll go through step by step)

Open a module, or create a new module.

Type into it this:
Function something()
MsgBox Left("asdf",1)
End Function
now, if you have the cursor in there, and press F5 (the "Run" key), you should get a message box with "a" as the message.

If it doesn't work - you've definitely got a problem.

In Access 2000, the default references ticked (at least, on my computer) are:
[ul][li]Visual Basic For Applications[/li]
[li]Microsoft Access 9.0 Object Library[/li]
[li]OLE Automation[/li]
[li]Microsoft ActiveX Data Objects 2.1 Library[/li][/ul]

But the main ones needed are the first two.

Once you've got them checked - you should be ok.
To make sure that they work, RIGHT click on the word "Left" in the function you just typed, and choose "Complete Word". If "Left" or "Left$" isn't there, you've still got a problem, which [u]could</u> possibly be the way you're using it in the query, in which case - post your code.


I am a loud man with a very large hat. This means I am in charge
Old March 24th, 2004, 11:51 AM
Registered User
Join Date: Mar 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks for the response, I tried and still nothing. The query use to work, then it crashed and then nothing. Generally I import data and run queries/macros in Access 97, send data to a Citrix server containing Access 2000. I guess it was time to let go the old, so I imported all tables, queries, etc into the new version. All is well and I've let go and became a true convert.

Similar Threads
Thread Thread Starter Forum Replies Last Post
LEFT vs LEFT OUTER joxa83 SQL Server 2005 3 September 18th, 2008 03:13 AM
Undefined function 'Left' in expression Morris Access 13 July 23rd, 2008 02:07 AM
Report from right to left roy_mm Reporting Services 0 February 20th, 2007 11:11 AM
Undefined function 'Left' in expression MountainProud Access 4 October 23rd, 2006 10:48 AM
LEFT ERROR xcalibur ASP.NET 1.0 and 1.1 Professional 1 October 10th, 2003 09:23 AM

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