搜索+多选框 [英] Search + Multi Select Box

问题描述

Hello Bytes，


我一直是潜伏者，在这里有如此多的信息我总能轻松找到答案。直到今天...


我希望有人可以为我施加一点脑力。


我有一个搜索表单使用经过尝试的真正的''AddToWhere''模块，这就像用户输入文本框的冠军一样，但现在我面临着将多选列表框集成到同一个例程中。


我的所有代码都在DoD的SECRET网络上，所以我不能向你展示我曾经尝试过的，因为它没有连接到网络。我现在正从偏高的方面发帖。


如何在以下例程中实现单个多选列表框？


如果可能，请提供修改后的代码，以便我可以在SIPR工作站上打印并手工堵塞。

ACCESS 2003

展开 | 选择 | Wrap | 行号

解决方案

取决于您要从列表框中选择的内容。如果您选择要包含的多个字段，那么值来自哪里？

无论如何，这里是我从列表框中选择的方式。我通常在列表框中有多列数据，但并非所有数据都对用户可见。

展开 | 选择 | 换行 | 行号

谢谢ChipR。


我当然理解逻辑，但我不够流利，不能把逻辑转化为工作代码。


当我将列表框放在表单上时，输入了这个多选列表框中的值。


上面的代码用于带有文本框的表单sql select查询的标准。这非常有效。


我如何修改上面的代码，以便在选择之间使用''或'以及来自的值来获取多选列表框的值目前使用''和''的文本框效果很好。


我已经接近但没有雪茄。


v / r，


Aaron

我只知道你想要什么，但直到明天我才能发布。

Hello Bytes,

I''ve been a long time lurker, there so much information here I always find my answers with ease. Until today...

I''m hoping someone can exert a little brain power for me.

I have a search form using the tried and true ''AddToWhere'' module, this is working like a champ for user input text boxes but now I''m faced with integrating a multi-select listbox into the same routine.

An added bit of difficulty is all of my code is on the DoD''s SECRET network, so I''m unable to show you what I''ve attempted as it''s not connected to the net. I''m posting from the high side at the moment.

How would you implement a single multi-select listbox into the following routine?

If possible please provide the modified code so I can print and hand-jam it on the SIPR workstation.

ACCESS 2003

Expand|Select|Wrap|Line Numbers

解决方案

Kind of depends on what you want to select from your listbox. If you select multiple fields to include, where are the values coming from?
Anyway, here''s how I get selections from my list box. I usually have multiple columns of data in the list box, but not all of them are visible to the user.

Expand|Select|Wrap|Line Numbers

Thank you ChipR.

I certainly understand the logic but I''m just not fluent enough to take the logic and turn it into working code.

The values in this multi-select listbox were entered when I placed the listbox on the form.

The code above is for a form with text boxes for the criteria of a sql select query. This works wonderfully.

How would I modify the code above to also take the values of a multi-select listbox using an ''or'' between the selections as well as the values from the text boxes which currently uses an ''and'' with great results.

I''ve been close but no cigar.

v/r,

Aaron

I just figured out what you want, but I won''t be able to post until tomorrow.

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