auto fill search tool

[Chrisopia]

I have noticed in the form, using the search bar at the bottom not only searches all the fields but guesses ahead on what your searching.

For example if I typed "ban" it will find "banana street" uder addresses or "ban drugs.com" or something under company... does this make sense?

Is it possible to add this to my own design,

for example using a form to enter data it will search the database for that field to see if it already exsists, a bit like predictive text messaging, but entering data into a form.


I have tried looking in this forum already but the search tool keeps erroring :S

thanks.

 

[raskew]

What form are you referring to?

Bob

 

[Chrisopia]

any form you create - next to the navigation controls near the bottom.

 

[raskew]

Hi -

Try downloading the Cool Search Tool posted here: http://www.access-programmers.co.uk/forums/showthread.php?t=1162 (original author unknown)

In my experience, it'll take a fair amount of experimentation to:

a. Figure out how it's doing what it's doing.

b. Figure out how to modify it to fit your own needs.

The possible downside to it, as written, is that it's db/table/query specific. To convert to a different table/query entails rewritting a fair amount of code. I've been playing with developing a more generic version whereby the user could specify the table/query to search, along with the fields to display and or search on. If I ever come up with something, I'll post it here.

Best wishes and good luck -

Bob

 

[raskew]

Hi -

Returning to my original post, I'm at a loss with:

I have noticed in the form, using the search bar at the bottom not only searches all the fields but guesses ahead on what your searching.

I've never had a search bar at the bottom of any form. Is this an A2007 thing?

Bob

 

[Chrisopia]

I cant remember if the search tool was in 2003 or not, perhaps it is a new thing sorry,

Also that link didn't work - told me to tell the administrator.

 

[raskew]

Oops -

Let's try it again:

http://www.access-programmers.co.uk/forums/showthread.php?t=116253

Bob

 

[missinglinq]

Yes, Bob, this is a new feature with v2007. And to be honest, it doesn't strike me as being a very desirable tool, in most cases. Having a search tool that wanders indiscriminately from one field to another to another, with each stroke of a key?

 

[Chrisopia]

Great it worked a treat!


I tweaked the source codes, changed the query design and edited the code for the query (it seemed to prioritise the search).

I changed the boxes along the bottom to match the rest of the table, and customised the query viewing window ("QuickSearch") to view the columns I want.

Just what I needed! PERFECT!

Only confusing trouble is it searched for the item, but when I clock on it it tells me it couldn't find the field, but then it magically can and it appears in the boxes? I've found the code that controls this message box but do not understand why it appears.