News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Tuesday, August 22, 2006

Find as you type

Find as you type - utility (actually a module, which you copy to your MDB and “attach” to your forms) finds matching records with each keystroke you type by Allen Browne, Access MVP. I am also using similar approach in my applications, but with 2 differences:

  • I look through all fields, so whatever user types - phone, city, email - he finds something
  • I use timer event to start search, and search runs after user finished typing a string. on form open timer interval is set to 0, in change event I set it to 500, so once user did not press a key within .5 sec - form get filtered.

I mostly use it for applications with SQL Server linked tables, and perhaps Allen approach is best for Jet databases, will certainly try it in some application. Well done, Allen!


Anonymous Anonymous said...


Could you post your code for this? It is exactly what I am looking for.



12:18 AM  
Blogger Alex Dybenko said...

I have a listbox filled with customers, based on a pass-through query, when user update textbox - i modify query's SQL and re-set listbox rowsource. thats all

1:49 PM  

Post a Comment

<< Home