[AccessD] Simulate AutoFilter

Shamil,

Sounds very interesting...but what do you mean by "slipping"?  Does it move?

Thanks,

Mark A. Matte


>From: "Shamil Salakhetdinov" <shamil at users.mns.ru>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Simulate AutoFilter
>Date: Wed, 4 Apr 2007 23:02:04 +0400
>
>Thomas,
>
>You can make a form with 40 textboxes, one "slipping" combobox and subform.
>If we assume that Group By/Select distinct on your 1.5 million records on
>any of 40 fields is satisfactory speedy (<=3 sec to complete) (is it like
>that?) then on GotFocus event of a textbox you can put over textbox (by
>using VBA event processing code) a "slipping" combobox and fill its
>rowsource with corresponding Group By data etc...
>
>If getting filter values using Group By isn't a speedy enough process then
>you can use temp database and fill it on start-up of your application and
>show a progress bar form to the user recommending him to take a break and
>drink some coffee while your filter form/temp database is getting
>initialized...
>
>In any case there will be not that much VBA coding to implement this
>filtering form...
>
>--
>Shamil
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of ewaldt at gdls.com
>Sent: Wednesday, April 04, 2007 6:27 PM
>To: accessd at databaseadvisors.com
>Subject: [AccessD] Simulate AutoFilter
>
>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.
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Exercise your brain! Try Flexicon. 
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglineapril07