Shamil Salakhetdinov
shamil at users.mns.ru
Wed Apr 4 14:02:04 CDT 2007
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