BindingSource.Filter [英] BindingSource.Filter

问题描述

我可以使用BindingSource.Filter =" FIELD 像 ENTRY "来过滤记录.

因此，在这种情况下，仅显示与"FIELD"中与"ENTRY"匹配的记录，其余记录将被丢弃.

我想知道最简单的方法是做相反的事情.

我希望过滤器放弃"FIELD"中包含"ENTRY"的记录，但显示其他所有内容.
因此，除了使用"FIELD like ENTRY"之外，还有类似于"FIELD like ENTRY"或"FIELD not like ENTRY"的东西吗?

我当前的代码:

TblAccomadationBindingSource1.Filter = "Site like ''" & ComboBox5.Text & "*''"


请帮助


Marco

Hi,

I am able to filter records using BindingSource.Filter = "FIELD like ENTRY".

So in this case only the records which match "ENTRY" in "FIELD" are displayed and the rest of the records are discarded.

I want to know what the simplest way is, to do the exact opposite.

I want the filter to discard the records which contain "ENTRY" in "FIELD" but display everything else.
So instead of using "FIELD like ENTRY" is there something similar to "FIELD unlike ENTRY" or "FIELD not like ENTRY"?

My Current Code:

TblAccomadationBindingSource1.Filter = "Site like ''" & ComboBox5.Text & "*''"


Please Help


Marco

推荐答案

抱歉，我在这里回答了自己的问题.

QryProblemLocationBindingSource.Filter = "[Location Field] not like ''" & "Kitchen" & "*''"

我忘了括号:rolleyes:

Hi,
Sorry I kind of answered my own question there.

QryProblemLocationBindingSource.Filter = "[Location Field] not like ''" & "Kitchen" & "*''"

I forgot brackets :rolleyes:

这篇关于BindingSource.Filter的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！