为什么表格数据突然停止显示？ [英] Why did table data suddenly stop displaying in form?

问题描述

Access 2007：我有一个数据库，我的客户有多个站点（一对多关系），站点有多个系统（另一个一对多）。直到今天，这些关系运作良好，数据已按预期显示在每个相应的表格上。客户表单上有一个按钮，用于打开站点​​表单，并显示链接到该客户的站点。 [站点]表单上还有一个按钮，用于打开[系统]表单并显示链接到该站点的系统。它一直工作到现在......突然今天当我点击网站表单上的按钮打开系统表单时，没有系统数据出现，即使我知道它在表中。我检查了表格中的数据，一切看起来都是有序的。链接字段（SiteID）对于站点和相应的系统是正确的，但由于某种原因它们不会出现在Systems FORM上。同样，表中的所有数据都是正确的，甚至查询也能正常工作。他们不会出现在表格上的任何原因，以及当我尝试使用查找时函数搜索记录，查找函数不起作用，因为它说：

*字段是控件;

*这些字段没有数据;或

*没有要搜索的字段。


感谢您对我神秘感的任何帮助！

解决方案

尝试*将*您的FrontEnd导入到一个全新的数据库中看看问题是否存在。 http://www.btabdevelopment.com/ts/impnew

我尝试将旧数据库导入新数据库的方式有两种：（1）我通过导入结构和数据来尝试它 - 不起作用; （2）我只通过导入结构尝试了它并尝试了测试数据。它仍然无法正常工作。当我进入系统表单时，它没有显示数据。我发现表单接受数据真的很奇怪，但是如果我刷新页面就消失了，并说没有记录。但是Systems表单有一个基于查询的子表单，该查询旨在显示与该站点关联的所有类型的系统。查询有效，子窗体显示正确的系统。仍然不知道为什么它不会出现在主系统表单中，以及为什么它直到最近都无缝地工作。

你所描述的内容也可以通过设置DataEntry属性来实现。 MainForm为TRUE。

Access 2007: I have a DB where I have customers that have multiple sites (one-to-many relationship), and the sites have multiple systems (another one-to-many). Up until today, the relationships have worked fine and data has appeared as expected on each of the corresponding forms. There is a button on the customers form that opens the site form, and displays the sites that are linked to that customer. There is also a button on the [Sites] form that opens the [Systems] form and displays the systems that are linked to that site. It has all worked fine until now... Suddenly today when I click my button on the sites form to open the Systems form, none of the systems data appears, even though I know it''s in the table. I''ve checked the data in the table and everything seems in order. The linking field (SiteID) is correct for the site and the corresponding systems, but for some reason they do not appear on the Systems FORM. Again, all the data is correct in the tables and even the queries work. Any reason why they wouldn''t appear on the form, and when I try to use the "Find" function to search for a record, the Find function doesn''t work because it says:
*the fields are "controls;
*the fields have no data; or
*There are no fields to search.

Thanks for any help with my mystery!

解决方案

Try *importing* your FrontEnd into a fresh, new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

I tried importing the old DB into a new one 2 different ways: (1) I tried it by importing the structure AND the data - didn''t work; and (2) I tried it by importing the structure only and tried test data. It still is not working. When I get to the Systems form, it is not showing data. I find it really weird that the form accepts the data, but if I refresh the page it disappears and says there are no records. But the Systems form has a subform based on a query that is designed to show all the types of systems that are associated with that site. The query works and the subform shows the correct systems. Still no clue why it won''t show up in the main Systems form, and why it worked seamlessly up until recently.

What you describe can also be caused by setting the DataEntry property of the MainForm to TRUE.

这篇关于为什么表格数据突然停止显示？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！