Record Locator

K

Kathy Webster

I have posted this in the past, but no one was brave enough to take it on:

How can I build a record locator similar to the way it works in MSOutlook,
where the more characters you type, the closer it moves to your record. And
if you type a string that doesn't exist in the table, it will still move as
close as it can, based on the first part of the string.

IE: You type MARY. The record with Mary comes up.
You type MARRY (by mistake), and there is no MARRY record existing, so: The
first record that starts with MAR comes up.

TIA,
Kathy
 
S

storrboy

I have posted this in the past, but no one was brave enough to take it on:

How can I build a record locator similar to the way it works in MSOutlook,
where the more characters you type, the closer it moves to your record. And
if you type a string that doesn't exist in the table, it will still move as
close as it can, based on the first part of the string.

IE: You type MARY. The record with Mary comes up.
You type MARRY (by mistake), and there is no MARRY record existing, so: The
first record that starts with MAR comes up.

TIA,
Kathy
Click to expand...


Try here first...

http://www.allenbrowne.com/AppFindAsUType.html
 
K

Kathy Webster

Thanks storrboy. From my past experience, Allen Brown is a genius. I'll give
it a try!
 
L

Larry Linson

Kathy Webster said:
I have posted this in the past, but no one was brave enough to take it on:

How can I build a record locator similar to the way it works in MSOutlook,
where the more characters you type, the closer it moves to your record.
And if you type a string that doesn't exist in the table, it will still
move as close as it can, based on the first part of the string.

IE: You type MARY. The record with Mary comes up.
You type MARRY (by mistake), and there is no MARRY record existing, so:
The first record that starts with MAR comes up.
Click to expand...

Put a ComboBox in the Form Header, and follow the steps in the Combo Box
Control Wizard for locating a Record in a Form. All you have to do is
follow the prompts... it doesn't scroll the Records, but scrolls the
drop-down list in the Combo, then selects the Record based on the list item
selected. This scrolling is called the "AutoExpand" feature, and is turned
on by default.

Larry Linson
Microsoft Access MVP
 
K

Kathy Webster

That is the way I have been doing it, Larry, but it presents its own
problems, with ON NOT IN LIST. Once they type something that doesn't have a
match, they are not left NEAR the records that were "close" to a match.
That's why I'm looking for something that gets closer with each character
that they type.
 
Top