AccessBlog.net

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

About Me Search
Alex
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!

2 Comments:

Anonymous Anonymous said...

Alex,

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

Brgds,

Maarten

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