Searching My database and live results...

[DanielWalters6]

Hi, I'm building a stock management system, which lists all the items which
my client's company use, and how many they have in stock.

Should they want to reorder some products, they can search the product's
name and description to show a list of products that match keyword.

How can I get this on the fly? ie, similar to Vista's Instant Search,
Similar to Apple's Safari, Similar to Google Search using the firefox
toolbar...

The more characters I type into the system, the more refined the search. For
example, typing tooth, it would show me toothpaste and toothbrush, but after
typing in toothb, toothpaste wouldn't be in the results list...

I hope I'm explaining this clearly, if not, then let me know.

I presume it's a piece of code in VBA which says, on update or something
like that, run the query. But I would like the query to run after each
letter, slowly narrowing down my results...

I understand this is quite labour intensive, but the quite powerful machine
will cope!

Cheers

 

[Allen Browne]

See:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

Implimenting this is copy'n'paste, i.e. you don't really have to understand
or change the code.

 

[DanielWalters6]

Looks like it might just work

I'll repost an update later on, when I'm not in my current environment ( zip
files from the internet are disabled)

Dan