left函数未定义,表达式中未定义的函数“left”（Windows 10 / Access 2016）

Hi All,

I just had Windows 10 installed and am now having a problem using the "left" function in an access query. My syntax is fine and has worked in the past, but is not working now.  Message:  Undefined function 'left' in expression

I saw a similar problem posted elsewhere and the resolution was to download web services from Microsoft.  I followed the link mentioned and downloaded it, but it was only for Access 2003, so it did not help me.

Anyone know the fix to this problem?

解决方案Hi,

Installing a new OS probably means reinstalling Office as well. Typically, when you get an error for using built-in function like Date(), there is a broken reference in the database.

Go to the VBA window and click on Tools > References and look any reference marked as "MISSING." If you find any and don't need it, simply uncheck the box to fix the problem. Otherwise, you will have to reinstall the missing library.

Hope it helps...