Filtering Question

23 Oct 2006 7:32 PM

Nathan Guill

I'm not sure if this is the correct forum, but I am searching for an example
of how to perform an MS Access "filter by form" style query. In other
words, I want the user to click on the "Filter" button and the UI controls
would blank out to accept the user's input. When the user hit OK, the query
would run using only the fields the user entered.

Any help would be appreciated.

23 Oct 2006 9:24 PM

W.G. Ryan [MVP]

If you bind to a dataview object, then you can just figure out what columns
were selected (I think you'll have to so to the UI for that) and set the
Rowfilter property accordingly. There's a few ways to filter
(DataTable.Select, Find) but the approach is all the same)
Show quote

"Nathan Guill" <NGu***@Forgeman.com> wrote in message
news:OR8$pnt9GHA.1492@TK2MSFTNGP02.phx.gbl...
> I'm not sure if this is the correct forum, but I am searching for an
> example
> of how to perform an MS Access "filter by form" style query. In other
> words, I want the user to click on the "Filter" button and the UI controls
> would blank out to accept the user's input. When the user hit OK, the
> query
> would run using only the fields the user entered.
>
> Any help would be appreciated.
>
>

28 Oct 2006 6:44 PM

Nathan Guill

Thanks for this, but I am not using a dataview object. I have a collection
of textboxes, comboboxes, radioubutton, etc. that displays the data to the
user. What I need is something similar to MS Access.

Show quote

"W.G. Ryan [MVP]" <WilliamRyan@nospam.gmail.com> wrote in message
news:%23HjvPmu9GHA.1492@TK2MSFTNGP02.phx.gbl...
> If you bind to a dataview object, then you can just figure out what
columns
> were selected (I think you'll have to so to the UI for that) and set the
> Rowfilter property accordingly. There's a few ways to filter
> (DataTable.Select, Find) but the approach is all the same)
> "Nathan Guill" <NGu***@Forgeman.com> wrote in message
> news:OR8$pnt9GHA.1492@TK2MSFTNGP02.phx.gbl...
> > I'm not sure if this is the correct forum, but I am searching for an
> > example
> > of how to perform an MS Access "filter by form" style query. In other
> > words, I want the user to click on the "Filter" button and the UI
controls
> > would blank out to accept the user's input. When the user hit OK, the
> > query
> > would run using only the fields the user entered.
> >
> > Any help would be appreciated.
> >
> >
>
>