访问 2007-#名称?错误
我正在尝试指定一个控制源。我基本上只是在报表中创建一个文本字段,使用构建工具从子报表/查询中查找相关字段,然后进行设置。我知道该路径对于控制源来说是正确的,因为我不是自己输入它,而是选择它。
我引用的字段仍然存在,并且实际上位于 controlsource 指向的位置。但由于某种原因,我收到此错误。这没有道理。
有人可以帮忙吗?
I am trying to specify a controlsource. I basically just create a text field in a report, use the build tool to find the relevant field from a subreport/query, and then set it. I know the path is right for the control source because I am not typing it myself, I am selecting it.
The field I am referencing still exists and is actually located where the controlsource is pointing. But for some reason, I get this error. It doesn't make sense.
Can anyone please help?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
尝试以不同于源名称的方式命名控件。例如,如果源中有名为“Name”的字段,请指定控件名称“Name_Textbox”。只是为了确保您有两个不同的名称(源名称与控件名称)。我想我在 MS Access 的早期版本(例如 2003)中遇到了这些问题。
Try naming the control differently from source name. For example, if you have field in the source called "Name", give the control name "Name_Textbox". Just to make sure you have two different names (source vs. control). I think I had these problems in previous versions of MS Access (e.g. 2003).
我已经看到这个错误(很久以前)并设法通过将完全限定名称括在括号中来修复它,IIRC,例如[源表]。[列名称]。无论如何都要尝试一下。
I've seen that error (long time ago) and managed to fix it, IIRC, by wrapping the fully qualified name in brackets, e.g. [source table].[column name]. Something to try at any rate.