Re: Multiple (unrelated) declarative parameters

On Feb 17, 10:13 am, "John Saunders" <john.saunders at trizetto.com>
wrote:
"Tastic" <brett.sm...@xxxxxxxxxx> wrote in message

news:1171657736.096459.13340@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi, I am working on a search & filter form using about 6 different
dropdown boxes, and possibly more to come.

Here is what I am trying to acheive; if the user does not specfiy any
choice in a ddb then then that particular filter is not applied
...
My actual question: am I going to have to sit here and manually go
through every possible combination of parameters used? (this would be
exceptionally time consuming not to mention messy)

or is there something I can do in my BLL to add or remove parameters
depending on selections

What if your query was something like this:

SELECT * FROM MY_TABLE
WHERE (
((@DDL1_PRESENT AND DDL1 = @DDL1) OR (NOT @DDL1_PRESENT)) AND
((@DDL2_PRESENT AND DDL2 = @DDL2) OR (NOT @DDL2_PRESENT)) AND ...
)

Then your only trick would be to supply the *_PRESENT parameters by testing
to see if ddl's have the "Please Select" item selected.

John

Thanks very much I'll see how it goes

.

Relevant Pages

  • Re: Multiple (unrelated) declarative parameters
    ... dropdown boxes, ... Here is what I am trying to acheive; if the user does not specfiy any ... choice in a ddb then then that particular filter is not applied ... depending on selections ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Combo box help needed please
    ... records to be returned with the selections made. ... > Private Sub cboCategory_AfterUpdate ... > ' Filter type list of cboType under selected category ... If the same city name exists in more than one ...
    (microsoft.public.access.forms)
  • Re: How to create this WHERE condition
    ... sorry for the confusion. ... Yes form A has a list box that I then want to filter form B for. ... how do I loop through the listbox on form A and get ... I have a form A, and want to make some selections from a listbox ...
    (microsoft.public.access.formscoding)
  • Re: vba sort a query
    ... I have many comboboxes with different selections and I have this code ... that i have on a 'filter' button so when I click the filter the ... comboboxes but sort by what is selected in the sortby combobox. ... Dim strdoc As String ...
    (microsoft.public.access.formscoding)
  • Re: Query filter problem!
    ... the query results will be determined by selections made by the user on a ... I want the user to be able to select items form either or both list boxes ... then the query will select the correct records based upon the selected. ... check if they want to use 'that' list as part of the filter, ...
    (microsoft.public.access.queries)