尝试使用按钮进行过滤，并按表单中的其他字段进行过滤。 [英] Trying to filter using a button and filter by another Field in a form.

问题描述

我创建了两个按钮，用于过滤我的表单，它们在不同的字段中过滤，如果有一个被过滤，而另一个不存在，则有一定数量的记录，如果它们都被推送，那么就会少一些。这很好用，但现在我想在表单中剩下的内容中进行过滤，而不添加其他记录。


我用来过滤使用我的按钮的代码是：

I created two buttons, that filter my form, They filter in different Fields, and if one is filtered, and the other is not there is a certain amount of record, if they are both pushed, then there is less. This works great, but now I want to filter within what is left in the form, without adding the other records.

The code I use to filter using my buttons is:

展开 | 选择 | Wrap | 行号

推荐答案

越来越多的过滤器组合可能变得相当代码密集。

我想请你先检查一下：
http ：//www.geocities.com/nico5038/xR...nstruc ing.zip

这种方式不需要代码，我只是将这个描述提供给我的用户。

保存了很多代码，用户可以过滤每一个他喜欢的领域。


想法？


Nic; o）

The increasing number of filter combinations can become rather "code intensive".
I would like to ask you to check first:
http://www.geocities.com/nico5038/xR...nstruction.zip
This way no code is needed and I just give this description to my users.
Saved me lots of code and the user can filter every field (s)he likes.

Idea ?

Nic;o)

表格我有，我的工程师已经使用过滤器选项，只是我放入两个按钮，一个过滤掉已关闭的项目，另一个过滤掉我们称为EP的产品。这些按钮使用按钮的标题相互协作。我的工程师希望能够过滤其他字段，并使用这些按钮。每当他这样做时，按钮过滤器或其他过滤器都会被取消，并且只应用最后一个过滤器。所以我想知道有没有办法在使用按钮时锁定过滤器？

The form I have, my engineer uses the filter option already, it is just i put in two buttons, one filters out the closed items, and the other filters out the Product we call EP. These buttons work with each other, using what the caption of the button is. My engineer wants to be able to filter other Fields, and use these buttons. Every time he does, the button filter, or the other filter, gets canceled, and just applies the last filter. So I was wondering is there a way to lock the filters when the button is used?

弹出过滤器将允许多个选择，这些将使用AND添加。 />

如果你想编码这个我会使用.filter属性。

这样你可以测试或Len（Me.Filter）> 0并添加一个带有预定义的新字段并且。


就个人而言，我更喜欢使用数据表子表格和推。从子窗体应用的过滤器到主窗体上的（只读）文本框。即使使用右键单击也可以使主动过滤可见。


结帐：
http://www.geocities.com/nico5038/xS...tAction-97.zip

Nic; o）

The popup filter will allow multiple selections and these will be added using an "AND".

When you want to code this I would use the .filter property.
That way you can test or Len(Me.Filter) > 0 and add a new field with a prefized " and ".

Personally I prefer to use a datasheet subform for this and "push" the applied filter from the subform to a (read only) textbox on the mainform. Even using the right-click will be making the active filtering visible.

Checkout:
http://www.geocities.com/nico5038/xS...tAction-97.zip

Nic;o)

这篇关于尝试使用按钮进行过滤，并按表单中的其他字段进行过滤。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！