[AccessD] Simulate AutoFilter

Thanks, but unfortunately the filter-by-form doesn't yield a list of all 
the candidates for each field like Excel's AutoFilter does. "Is Null" and 
"Is Not Null" doesn't help much. With 40+ fields, most of which they want 
to filter on, I can't require them to know all the candidates for each 
field.


Thomas F. Ewald
Stryker Mass Properties
General Dynamics Land Systems


Message: 9
Date: Wed, 4 Apr 2007 10:47:42 -0400
From: "Arthur Fuller" <fuller.artful at gmail.com>
Subject: Re: [AccessD] Simulate AutoFilter
To: "Access Developers discussion and problem solving"
                 <accessd at databaseadvisors.com>
Message-ID:
 <29f585dd0704040747x6d12c182y369ef624aec710a at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

For this kind of thing I suggest trying out the built-in filter-by-form 
and
see how you like that.
Arthur


On 4/4/07, ewaldt at gdls.com <ewaldt at gdls.com> wrote:
>
> I'd like to create a form in Access which simulates the AutoFilter
> functionality in Excel. Basically, it's the size of the files (1.5 
million
> records) that makes Excel less useful than it would be otherwise. I 
doubt
> the company wants to spring for Office 2007 just now to have Excel's
> capacity increase.
>
> Does anyone know of a sample database or just some instruction on how to
> build such a puppy? I've got about 40 fields; will this require 40 combo
> boxes, or is there another way?
>
> TIA.
>
> Thomas F. Ewald
> Stryker Mass Properties
> General Dynamics Land Systems







This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information.  No one else may read, print, store, copy, forward or act in reliance on it or its attachments.  If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.