表单上的计数功能不再适用于Access 2013 [英] Count function on form no longer working in Access 2013
问题描述
我在旧客户端上有一个Access 2003数据库(.mdb),其中表单上的Count已停止工作。这似乎是因为数据库现在正在Access 2013中运行。我在Access 2010上尝试了数据库的副本(我个人拥有的最新版本
),它运行正常。
I have an Access 2003 database (.mdb) at an old client where a Count on a form has stopped working. It would appear to be because the database is now being run in Access 2013. I have tried a copy of the database on Access 2010 (the newest version I personally have) and it works fine.
计数在子表格上。主窗体显示客户端,子窗体显示每个客户端的约会。计数在子表单的表单页脚上的文本框的控件来源属性中,并且只是=计数([客户端ID])。
The count is on a Sub-form. The main form shows clients, the sub-form shows appointments for each client. The count is in the Control Source property of a text box on the sub-form's Form Footer and is simply =Count([Client ID]).
到目前为止工作正常,而且我可能会遗漏一些非常简单的东西但是在有限的时间内我不得不看它,我无法弄清楚为什么它不再有效。
It's worked fine up until now, and I may be missing something really simple but in the limited time I had to look at it I couldn't figure out why it would no longer work.
有没有人有任何想法?
谢谢
Adrian
Thanks
Adrian
推荐答案
用*替换字段名称,所以Count(*)
Replace the field name with *, so Count(*)
如果不能解决,请尝试将所有对象导入到新(空)Access(较新版本)文件中。这样引用将自动加载并避免出现问题。
If that does not solve, try importing all objects into ta New (empty) Access (newer version) file. This way the references will auto load and avoid problems.
这篇关于表单上的计数功能不再适用于Access 2013的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!