在组合框的行源中添加“ALL”。 [英] Adding 'ALL' in rowsource of combobox.

问题描述

我有acombobox用于过滤任何值的选择数据。我想在我的组合框中添加一个值''ALL'，供用户选择所有的值，即删除过滤。在某种程度上，一切都不起作用。这里'是查询：

I have acombobox used to filter data on selection of any value.I want to add a value ''ALL'' in my combobox for users to select all the values i.e. remove filtering.union all is not working somehow.Here''s the query:

展开 | 选择 | Wrap | 行号

推荐答案

下次，更好地格式化查询。当一切都在一条线上时，很难读懂。


我在你的查询中看不到联合。您必须发布错误的查询。


如果这是正确的查询，那么您并没有使用所有联合。但话说回来，你不必。很难说它出了什么问题，因为你没有给我们提供我们需要的所有信息。我们需要知道GetAsset（）的代码。我们需要知道哪些数据在位置。


但是我会这样说，如果你使用LIKE谓词并且你的组合框中的All项返回一个值会更容易星号。

Next time, format your query better. It''s difficult to read when everything is on one line.

I don''t see union all in your query. You must have posted the wrong query.

If that is the correct query, then you didn''t use a union all. But then again, you don''t have to. It''s hard to say where it went wrong because you don''t give us all the information we need. We need to know the code for GetAsset(). And we need to know what data is in location.

But I will say this, it would be easier if you used a LIKE predicate and had the All item in your combobox return a value of an asterisk.

我曾尝试使用union这样：

I had tried using union all like this:

展开 | 选择 | Wrap | 行号

你的工会不是不会去工作，因为它实际上并没有选择任何记录。你的函数和SQL看起来很好。我会调试它，以确保它返回正确的值。

Your union isn''t going to work because it doesn''t actually select any records. Your function and SQL look fine. I would debug it though to make sure it''s returning the right value.

这篇关于在组合框的行源中添加“ALL”。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！