从筛选计算结果 [英] Count Results From Filter

问题描述

我有一个带有未绑定字段的表单作为我的查找。

I have a form with an unbound field as my lookup.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

推荐答案

I有一个带有未绑定字段的表单作为我的查找。

I have a form with an unbound field as my lookup.

展开 | 选择 < span class =codeDivider> | Wrap | 行号

您可以使用Dcount函数返回计数变量。如果变量count大于1，则Me.txtCount.Visible = true。您还可以使用DCount将文本框值设置为计数。


默认情况下将TextBox的属性设置为No。然后，您可以在应用过滤器后使用代码使其可见。

You can use Dcount function to return a count to a variable. If the variable count is greater than 1 then Me.txtCount.Visible = true. You can also set the textbox value to the count using DCount.

Set the properties of the TextBox Visible to No by default. You can then use code to make it visible after you apply your filter.

使用dcount函数返回值是我的保留。我假设在应用过滤器之后，代码将驻留在查找的AfterUpdate部分中。请解释我如何返回值。

Using the dcount function to return a value is my holdup. I''m assuming that the code would reside in the AfterUpdate portion of my lookup, after the filter was applied. Please explain how I return the value.

使用dcount函数返回值是我的保留。我假设在应用过滤器之后，代码将驻留在查找的AfterUpdate部分中。请解释我如何返回值。

Using the dcount function to return a value is my holdup. I''m assuming that the code would reside in the AfterUpdate portion of my lookup, after the filter was applied. Please explain how I return the value.

您要过滤的数据源的表/查询名称和字段名称是什么？这些是Dcount的必需元素 - 其中部分是可选的。

你到底在想什么？


你给我们的细节越多 - 我们就越准确答案。


我要回家但可能会从那里登录。

What is the table/query name and field name of the data source you are filtering? These are required elements of Dcount - the where portion is optional.
What exactly are you counting?

The more details you give us - the more precise our answers.

I''m going home but may log in from there in a bit.

这篇关于从筛选计算结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！