user defined wildcards

  • Thread starter Thread starter mattiss
  • Start date Start date
M

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.
 
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/
 
thank you
--
matt


Jeff Boyce said:
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 said:
[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.
Click to expand...
Click to expand...
 
[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.
Click to expand...

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.
 
Back
Top