搜索没有连续表格 [英] SEARCH without Continuous Form

问题描述

这可能是一个非常基本的问题，但我不得不问这个，因为我在任何地方都找不到答案。


我正在使用Access 2010.我有几张桌子，现在我需要创建一个SEARCH表单来搜索这些表中的数据。


我搜索了有关创建搜索表单的信息，而且我发现使用连续表单的大多数地方都是最佳选项。

so，continuous form显示所有记录，当你添加搜索条件时，它会过滤掉结果。

这是我的理解。


但我不想使用连续的表格，因为我不想显示我的所有记录。

所以可以用其他方法显示结果。不是作为消息框，可能是弹出窗口或列表或其他东西。？


所以基本上，表单应该只包含用户可以输入其标准的文本框。当他点击SEARCH。结果应显示。

结果也可能是记录列表。


感谢任何建议！

解决方案

我仍然会使用连续形式，但不是在开头使用连续形式，而是在打开表单时使用WhereCondition参数根据文本框中输入的值过滤结果。

我明白了。但是必须打开表单并输入值，然后我们才知道用什么值来过滤结果。那怎么可能在表格的ON Load函数中使用过滤器值？没有打开表格。

我不认为你确实得到了我的想法。我的想法涉及两种形式：一种用于输入要搜索的值，另一种用于搜索结果。你根本不会使用On_Load事件，而是使用 DoCmd.OpenForm 命令的WhereCondition。因此，在输入搜索条件后，单击一个搜索按钮，打开第二个表单（在连续视图中），将根据您的搜索条件对其进行过滤。

This might be a very Basic question, but I have to ask this as I dont find the answer anywhere.

I am using Access 2010. I have few tables and now I Need to create a SEARCH form to search data from These tables.

I searched about creating SEARCH forms and most places I find using a continous form is the best Option.
so, continous form Shows you all the records and when you add your search criteria it filters out the result.
this is my understanding.

But i dont want to use the continous form as I dont want to Show all my records.
so is it possible to Show the result in some other method. Not as a message box, maybe a popup or a list or something.?

so basically, the form should only contain only text boxes where the user can enter his criteria. and when he hits SEARCH. the result should Display.
the result could also be a list of records.

thanks for any suggestions!

解决方案

I would still use the continuous form, but instead of having the continuous form at the beginning, use the WhereCondition argument when opening the form to filter the results based on the values entered in the textbox.

I get your idea. But the form has to be opened and the values have to be entered, only then we know what values to filter the results with. so how is it possible to use the filter values in the ON Load function of the form?? without opening the form.

I don''t think that you do get my idea. My idea involves two forms: one for entering the values to search for and another one for the results. You wouldn''t use the On_Load event at all, but the WhereCondition of the DoCmd.OpenForm command. So after you have entered your search criteria, you click a search button that opens the second form (which is in continuous view) which would be filtered based on your search criteria.

这篇关于搜索没有连续表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！