If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"left function " problem???
For some reason my home copy of access2003 wont let me use the
following criteria in a query but it seems to work fine at the office. the error message states: UNDEFINED FUNCTION 'LEFT' IN EXPRESSION. There must be a setting that needs to be done ??? (i just installed the home copy and it's the exact version that's on the office computer. Any help is greatly appreceiated. expression= 1: Left([company],20) Tks |
#2
|
|||
|
|||
"left function " problem???
|
#3
|
|||
|
|||
"left function " problem???
Check this out:
http://www.mvps.org/access/bugs/bugs0001.htm -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. " wrote: For some reason my home copy of access2003 wont let me use the following criteria in a query but it seems to work fine at the office. the error message states: UNDEFINED FUNCTION 'LEFT' IN EXPRESSION. There must be a setting that needs to be done ??? (i just installed the home copy and it's the exact version that's on the office computer. Any help is greatly appreceiated. expression= 1: Left([company],20) Tks |
#4
|
|||
|
|||
"left function " problem???
Hello "".
"" wrote: For some reason my home copy of access2003 wont let me use the following criteria in a query but it seems to work fine at the office. the error message states: UNDEFINED FUNCTION 'LEFT' IN EXPRESSION. There must be a setting that needs to be done ??? (i just installed the home copy and it's the exact version that's on the office computer. expression= 1: Left([company],20) In the home copy, open a module and click "tools, references" to see if there are any broken references ("MISSING:"). Delete these and replace them by existing libraries on that PC. -- Wolfgang |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom functions calculating time arguments Help Desperate | Bill_De | Worksheet Functions | 12 | April 25th, 2006 02:22 AM |
SPELL CURRENCY FUNCTION | Rajesh | Using Forms | 1 | October 1st, 2005 11:04 PM |
Attaching Code | DS | General Discussion | 2 | August 22nd, 2005 11:21 PM |
Excel option to store trendline's coefficients in cells for use | Miguel Saldana | Charts and Charting | 9 | June 20th, 2005 08:45 PM |
Match function problem | Tom | Worksheet Functions | 0 | September 22nd, 2003 09:05 PM |