在我的表单上，并非我的所有数据库都显示在表单视图上。 [英] On my Form not all my database shows on the form view.

问题描述

我在Access 2007中设置了所有内容。当我转到表单视图时，并不是所有数据库都显示出来。我觉得某处有休息，但我是Access的新手，需要帮助。

I have everything setup in Access 2007. When I go to my form view, not all my database shows up. I feel there is a break somewhere but I am new to Access and need help.

推荐答案

你没有提供太多信息让我们离开，但是这里有几个地方可以看。


您的表格在其过滤属性中是否有任何内容？

您的表单的记录来源是表格还是查询还是一个SQL字符串？

如果它是一个查询或一个SQL字符串，是否有一个WHERE子句？

虽然我猜不到，是吗表单''事件（On_Load，On_Current等）中可以过滤结果的任何代码？

You don''t provide much information for us to go off of, but here are a few places to look.

Does your form have anything in its Filter property?
Is your form''s Record Source a table or query or a SQL string?
If it is a query or a SQL string, is there a WHERE clause in either one?
While I''m guessing not, is there any code in the form''s events (On_Load, On_Current, etc.) that could filter the results?

Steve我对此很新。它是在我开始在这里工作之前创建的。它工作正常大约8个月，但当我们去新的联系人并保存 - 它保存到我们的数据库但不会在表单上显示

Steve I am so new to this. It was created before I started to work here. It was working fine about 8 months but when we went to put a new contact in and save - It saved it to our database but will not show on the form

Seth这是一个查询和在事件下的表单属性表上，on current中没有任何内容。或载入。

Seth this is a query and on the form property sheet under event there is nothing in "on Current" or "on Load".

这篇关于在我的表单上，并非我的所有数据库都显示在表单视图上。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！