[AccessD] Simulate AutoFilter

>I also worked at YPG as a RAM-D engineer.

And I grew up in the Bard valley, the shortcut between Yuma and the YPG.  My
uncle was a test driver for the tanks and other vehicles out there, in fact
he was killed in a rollover of a vehicle he was testing.

John W. Colby
Colby Consulting
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert L. Stewart
Sent: Wednesday, April 04, 2007 1:23 PM
To: accessd at databaseadvisors.com
Cc: ewaldt at gdls.com
Subject: Re: [AccessD] Simulate AutoFilter

Thomas,

First, are you nuts? Loading 1.5 million records just to filter them.
That is extremely poor design.

And to even consider Excel for the task...well, I won't say what I think
about that.

Build a search form.  Create a subform on it that will display the results
of the things selected as part of the search. Do not load the source for the
subform until you click on a button to 'find' the results of the search
criteria entered. As part of the search, give them a field for the top X
number of records. And do not let them exceed a certain number.

Even you military contractor types should be able to use it. :-)

I can say that because I developed the FRACAS system that Stewart &
Stevenson used in the FMTV production system for the Army. So, I know how
backward engineers can be. I also worked at YPG as a RAM-D engineer. As well
as reporting on some of the testing on the M1A1 systems.

Robert