Filtering Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Nathan Guill" <NGuill@xxxxxxxxxxxx>
Date: Mon, 23 Oct 2006 12:32:00 -0700

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.

.

Follow-Ups:
- Re: Filtering Question
  - From: W.G. Ryan [MVP]

Prev by Date: Re: Best way to create a database
Next by Date: Read and update a table
Previous by thread: binding tables in many-to-many relationships
Next by thread: Re: Filtering Question
Index(es):
- Date
- Thread

Relevant Pages

Re: WISH : file list
... When searching for a file in a component, creating a filter does the same thing. ... Sean Liming ... There is also my Component Hunter tool, which does the same thing, but without having to go through a filter. ... Often an embedded image doesnt work because you are missing files which different apps need. ...
(microsoft.public.windowsxp.embedded)
Re: Designing a Search Form (Access 2002)
... I am being asked to enter a parameter value when searching ... VBA code that makes a combo box function to filter a field with a yes/ ... the nurses that work in my facility) to filter a field that contains ... Dim strF as String 'strF = Filter ...
(comp.databases.ms-access)
Re: ListView lParam on alternate columns
... version you have checkboxes you can select when searching where you can ... My main problem is not being able to filter out MFC and ATL. ... Be nice if I could just filter out WinCE docs until I need them. ...
(microsoft.public.win32.programmer.ui)
Simple Question...
... I need to search and filter an entire column in a database whose range ... what I am searching for, I want to delete the entire row? ... Dim cel As Range, rng As Range ...
(microsoft.public.excel)
Re: If criteria is null return all
... First option doesn't work since it doesn't allow for me to filter out ... Put each piece of criteria on a separate row in ... What ten fields are you searching? ... this causes the query to response with insufficient memory error ...
(microsoft.public.access.queries)