“在组合中显示所有结果”行可能吗？ [英] 'Show all results' row within combo possible?

问题描述

大家好，已经搜索了这个但是找不到答案...


我有一些组合框限制了标题中的连续子表单主要形式。


目前，如果它们是空白的，则由于我的基础查询中的以下代码而显示所有结果：


（（Tbl_Schedule.Machine ）=表格！Frm_Schedule！ComboMa chine或Forms！Frm_Schedule！ComboMachine Null）


有没有办法在我的每个组合框中都有一个''显示所有结果''行这样可以选择并显示所有结果吗？

希望你能帮忙，OllyJ

Hi guys, have searched for this but can''t find an answer...

I have a number of combo boxes that limit a continuous subform in the header of the main form.

Currently, if they are blank, all results are shown due to the following code in my underlying query:

((Tbl_Schedule.Machine)=Forms!Frm_Schedule!ComboMa chine Or Forms!Frm_Schedule!ComboMachine Is Null)

Is there any way of having a ''show all results'' row in each of my combo boxes so that this can be selected and all results shown?

Hope you can help, OllyJ

推荐答案

如果组合框是目前从表中填充那将是困难的。

我想你可以在RecordSource中使用UNION查询，但更简单的可能是操作员只需清除ComboBox，从而返回Null值。你的代码可以解决这个问题。

If the ComboBoxes are currently populated from a table then that would be difficult.
I suppose you could use a UNION query in the RecordSource, but simpler would probably be for the operator simply to clear the ComboBox, thus returning a Null value. Your code could handle this.

感谢你的及时回复！


很抱歉这是一个痛苦的但如果你能解释所需的代码一个联合查询（之前从未使用过），这将是很棒的。


如果我的编码过于复杂，我可以随时返回空值。

Thank you for your timely response!

Sorry to be a pain but if you could explain the code required for a union query (never used one before), that would be great.

I can then always resort back to the null value if my coding gets too complicated.

Many thanks, OllyJ

它是UNION查询（语法）的一般用法还是你需要的细节？

请记住我可以在没有任何迹象或当前正在做的事情的例子的情况下帮助细节。

Is it general usage of a UNION query (syntax) or specifics you need?
Bear in mind I can''t help with specifics without some indication or examples of what you''re doing currently.

这篇关于“在组合中显示所有结果”行可能吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！