Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

undefined function

Posted on 2002-06-09
2
Medium Priority
?
487 Views
Last Modified: 2011-10-03
hi
I'm trying to do a query with left(field,1) function and get "undefined function 'left' in expression" error.

but !!! running the same function in another database, on the same table (linked) brings the results

why ?
0
Comment
Question by:yossin
2 Comments
 
LVL 12

Accepted Solution

by:
Paurths earned 400 total points
ID: 7065102
hi yossin,

open any module and click menu 'tools' , 'references'
see if any says missing.
If so, un-check it
u might have to close the mdb, and reopen afterwards.

cheers
Ricky
0
 

Author Comment

by:yossin
ID: 7065104
thanks a lot
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question