user defined wildcards

[mattiss]

[enter title] ??

I am trying to set up a user entered perameter that will allow for
mispelling, or misnamed titles. I would like for them to be able to enter
the 1st letter or 1st few letters of the title, and get all titles that start
with that.

 

[Jeff Boyce]

Hold on a sec, that's two different issues...

"Starts with" is easy, use something like:

Like [First few letters] & *

as your selection criterion.

Finding misspellings is a totally different issue -- and you'll have to tell
Access HOW to spot a misspelling!

One possible approach (no guarantees) is to use the Soundex function (do an
online search) to find words that "sound like"...

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[mattiss]

thank you
--
matt

Hold on a sec, that's two different issues...

"Starts with" is easy, use something like:

Like [First few letters] & *

as your selection criterion.

Finding misspellings is a totally different issue -- and you'll have to tell
Access HOW to spot a misspelling!

One possible approach (no guarantees) is to use the Soundex function (do an
online search) to find words that "sound like"...

Good luck!

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

[enter title] ??

I am trying to set up a user entered perameter that will allow for
mispelling, or misnamed titles. I would like for them to be able to enter
the 1st letter or 1st few letters of the title, and get all titles that start
with that.

 

[John W. Vinson]

[enter title] ??

I am trying to set up a user entered perameter that will allow for
mispelling, or misnamed titles. I would like for them to be able to enter
the 1st letter or 1st few letters of the title, and get all titles that start
with that.

If you have a fixed list of titles, simply create a smal table Titles with
just one field, Title, as its primary key. Fill it with the valid titles
("Mr.", "Ms.", "Dr.", "Her Royal Highness", etc.); and let the user *pick*
from this list using a Combo Box, rather than making them type it in and
slapping their hand if they make a mistake.