复选框查询参数 [英] Check Boxes for Query Parameters

问题描述

早上好，


我在这个项目中添加了几个我正在工作的帖子 - 非常感谢所有回复了想法和解决方案的人！


我的新问题：

我正在拟定一些表格来代替输入参数值。用于启动查询的框。本质上，表单显示所有参数选择（在组合，文本框和弹出日历中）。我有一个搜索标准是ProcessingCenter。有五个选择（5个不同的区域）。我希望能够通过所有，部分或仅其中一个进行搜索。换句话说，用户可以使用复选框控件选择Region1，Region1 + Region2，或全部5个区域等。


所以，（A）如何设置支票选中多个复选框的框和（B）下面是我想要运行的查询中的代码 - 它本身运行正常，但是表单只会导致所有5个区域。我需要在复选框控件中进行哪些设置才能准确地为查询提供参数？


谢谢！

展开 | 选择 | Wrap | 行号

解决方案

早上好，


我添加了关于我正在工作的项目的几个帖子 - 非常感谢所有回复了想法和解决方案的人！


我的新问题：

我正在编写一些表格来代替输入参数 eter Value用于启动查询的框。本质上，表单显示所有参数选择（在组合，文本框和弹出日历中）。我有一个搜索标准是ProcessingCenter。有五个选择（5个不同的区域）。我希望能够通过所有，部分或仅其中一个进行搜索。换句话说，用户可以使用复选框控件选择Region1，Region1 + Region2，或全部5个区域等。


所以，（A）如何设置支票选中多个复选框的框和（B）下面是我想要运行的查询中的代码 - 它本身运行正常，但是表单只会导致所有5个区域。我需要在复选框控件中进行哪些设置才能准确地为查询提供参数？


谢谢！

展开 | 选择 | Wrap | 行号

您的复选框控件是一个选项组框架吗？如果是这样，它只允许选择一个选项。所以你可以增加可能的选择以包括所有可能的排列，但这会占用相当多的形式空间，所以可能不是你想要的选择。


在没有选项组的情况下将6个复选框放在屏幕上可能是要走的路。然后在RegionID的条件网格中，你可以放置多个

展开 | 选择 | Wrap | 行号

好的，很抱歉我花了这么长时间.. 。


这里最好去吧：

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号< /跨度>

Good morning,

I have added several posts out here on a project on which I am working - thank you very much to everyone who has responded with ideas and solutions!

My new question:
I am drawing up some forms to use in place of "Enter Parameter Value" boxes to initiate queries. In essence the forms display all of the paramter choices (in combos, text boxes, and popup calendars). One search criterion I have is "ProcessingCenter" with five choices (5 different regions). I want to be able to search by all, some, or only one of these. In other words, the user can use a checkbox control to select Region1, or Region1 + Region2, or all 5 Regions, etc.

So, (A) how can I set the check boxes to have multiple checkboxes selected and (B) below is the code in the query I want to run - it runs fine by itself but with the form it only results in all 5 regions. What settings do I need to make in the checkbox control to accurately provide parameters to the query?

Thanks!

Expand|Select|Wrap|Line Numbers

解决方案

Good morning,

I have added several posts out here on a project on which I am working - thank you very much to everyone who has responded with ideas and solutions!

My new question:
I am drawing up some forms to use in place of "Enter Parameter Value" boxes to initiate queries. In essence the forms display all of the paramter choices (in combos, text boxes, and popup calendars). One search criterion I have is "ProcessingCenter" with five choices (5 different regions). I want to be able to search by all, some, or only one of these. In other words, the user can use a checkbox control to select Region1, or Region1 + Region2, or all 5 Regions, etc.

So, (A) how can I set the check boxes to have multiple checkboxes selected and (B) below is the code in the query I want to run - it runs fine by itself but with the form it only results in all 5 regions. What settings do I need to make in the checkbox control to accurately provide parameters to the query?

Thanks!

Expand|Select|Wrap|Line Numbers

Is your checkbox control an option group frame? If so, it will only allow one choice to be selected. So you could increase the choices possible to include all possible permutations, but that would eat up quite a lot of form real estate, so probably isn''t the option you are looking for.

Placing your 6 check boxes on the screen without an option group is probably the way to go. Then in the criteria grid for your RegionID, you can put multiple

Expand|Select|Wrap|Line Numbers

OK, I''m sorry it took me so long...

Here''s a better go at it:

Expand|Select|Wrap|Line Numbers

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