TEXT Functions(MID,Left,Right) Undefined Error

  • Thread starter Thread starter Lance
  • Start date Start date
L

Lance

From some reason my queries just stopped working. The text functions
such as MID,Left,Right gives me an error when I use it. It says
"undefined function 'Mid' in expression". I have checked with the
references, none of them are missing??. Can anyone help me in firguring
out this thing??

Access Version: Microsoft access 2002(10.6501.6626) SP3

Thanks in advance,
- Lance
 
From some reason my queries just stopped working. The text functions
such as MID,Left,Right gives me an error when I use it. It says
"undefined function 'Mid' in expression". I have checked with the
references, none of them are missing??. Can anyone help me in firguring
out this thing??

Access Version: Microsoft access 2002(10.6501.6626) SP3

Thanks in advance,
- Lance
Click to expand...

It probably is a missing or an incorrect reference (even though none
are marked missing).
Make sure you are using the correct set for your version of Access.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'

And read the following link by Doug Steele:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html
 
Back
Top