表达式中未定义的函数“left”（Windows 10 / Access 2016） [英] Undefined function 'left' in expression (Windows 10/Access 2016)

问题描述

大家好，

我刚刚安装了Windows 10，现在使用"左"字母时出现问题访问查询中的函数。我的语法很好，过去一直有效，但现在还不行。 消息： 表达式中未定义的函数"left"

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

我在其他地方发现了类似的问题，解决方法是从Microsoft下载Web服务。 我按照提到的链接并下载了它，但它仅适用于Access 2003，所以它对我没有帮助。

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? 

 

推荐答案

您好，

安装新操作系统可能意味着重新安装Office。通常，当您使用内置函数（如Date（））时出现错误，数据库中存在损坏的引用。

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.

转到VBA窗口并单击工具>引用并查看标记为"MISSING"的任何引用。如果您发现任何并且不需要它，只需取消选中该框即可解决问题。否则，你将不得不重新安装丢失的库。

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...

这篇关于表达式中未定义的函数“left”（Windows 10 / Access 2016）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！