MID: undefined function in query and Visual Basic (1 Viewer)

[Fozz]

Hi,

I'm doing some debugging over the phone.

My friend has Access 2003.

What does not work:

When he codes the MID function in a query he gets an error like this:

"Undefined function 'Mid' in expression."

In the Visual Basic editor, he gets the same error: MID is undefined.

What DOES work:

I walked him through the use of LEFT and RIGHT in the query and they work.

In Excel, MID works.

Question:

Might there be some odd ball Access configuration mess up, or maybe more likely, his Access installation is incomplete.

Thanks,
Bill

 

[pbaldy]

My guess:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[Fozz]

Paul,

Thanks for the quick response and pointer.

I will work through that document when I see him next week.

Thanks,
Bill

 

[pbaldy]

No problem Bill. A reference issue is usually the problem when Access doesn't recognize normal functions.