Solved

undefined function

Posted on 2002-06-09
2
484 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
Paurths earned 100 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

630 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