I'm running this on the front end to populate two parameters myName
and myAltName.
Maybe someone out there has done the same and has a lot more name
combinations. Any help filling out this list is appreciated:
Select Case MyName
Case "Richard"
myAltName = "Dick"
Case "Dick"
myAltName = "Richard"
Case "Robert"
myAltName = "Bob"
Case "Bob"
myAltName = "Robert"
Case "Matt"
myAltName = "Mathew"
Case "Mathew"
myAltName = "Matt"
Case "Tom"
myAltName = "Thomas"
Case "Thomas"
myAltName = "Tom"
Case "Daniel"
myAltName = "Dan"
Case "Maggie"
myAltName = "Margaret"
Case "Margaret"
myAltName = "Maggie"
Case "Susan"
myAltName = "Sue"
Case "Sue"
myAltName = "Susan"
Case "Elizabeth" 'opposite not needed: 'beth' is
contained
myAltName = "Beth"
Case "Charles"
myAltName = "Chuck"
Case "Chuck"
myAltName = "Charles"
Case "Peter"
myAltName = "Pete" 'opposite not needed: 'pete' is
contained
Case "James"
myAltName = "Jim"
Case "Jim"
myAltName = "James"
End Select 4 1323
How are you going to handle Lizzie and Betty -
both short forms of Elizabeth?
Also -
do you have a way of distinguishing the guy whose legal first name IS
Bob, not Robert?
Or my uncle, whose name was Frederic, but always went by Ted?
- Turtle
"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47**************************@posting.google.c om... I'm running this on the front end to populate two parameters myName and myAltName. Maybe someone out there has done the same and has a lot more name combinations. Any help filling out this list is appreciated:
Select Case MyName Case "Richard" myAltName = "Dick" Case "Dick" myAltName = "Richard" Case "Robert" myAltName = "Bob" Case "Bob" myAltName = "Robert" Case "Matt" myAltName = "Mathew" Case "Mathew" myAltName = "Matt" Case "Tom" myAltName = "Thomas" Case "Thomas" myAltName = "Tom" Case "Daniel" myAltName = "Dan" Case "Maggie" myAltName = "Margaret" Case "Margaret" myAltName = "Maggie" Case "Susan" myAltName = "Sue" Case "Sue" myAltName = "Susan" Case "Elizabeth" 'opposite not needed: 'beth' is contained myAltName = "Beth" Case "Charles" myAltName = "Chuck" Case "Chuck" myAltName = "Charles" Case "Peter" myAltName = "Pete" 'opposite not needed: 'pete' is contained Case "James" myAltName = "Jim" Case "Jim" myAltName = "James" End Select
THis is used as a search filter, not for output. So Legal Bob stays
Legal Bob, just users can find him if they search for Robert as well.
"MacDermott" <ma********@nospam.com> wrote in message news:<V5***************@newsread3.news.atl.earthli nk.net>... How are you going to handle Lizzie and Betty - both short forms of Elizabeth? Also - do you have a way of distinguishing the guy whose legal first name IS Bob, not Robert? Or my uncle, whose name was Frederic, but always went by Ted?
- Turtle "Lauren Quantrell" <la*************@hotmail.com> wrote in message news:47**************************@posting.google.c om... I'm running this on the front end to populate two parameters myName and myAltName. Maybe someone out there has done the same and has a lot more name combinations. Any help filling out this list is appreciated:
Select Case MyName Case "Richard" myAltName = "Dick" Case "Dick" myAltName = "Richard" Case "Robert" myAltName = "Bob" Case "Bob" myAltName = "Robert" Case "Matt" myAltName = "Mathew" Case "Mathew" myAltName = "Matt" Case "Tom" myAltName = "Thomas" Case "Thomas" myAltName = "Tom" Case "Daniel" myAltName = "Dan" Case "Maggie" myAltName = "Margaret" Case "Margaret" myAltName = "Maggie" Case "Susan" myAltName = "Sue" Case "Sue" myAltName = "Susan" Case "Elizabeth" 'opposite not needed: 'beth' is contained myAltName = "Beth" Case "Charles" myAltName = "Chuck" Case "Chuck" myAltName = "Charles" Case "Peter" myAltName = "Pete" 'opposite not needed: 'pete' is contained Case "James" myAltName = "Jim" Case "Jim" myAltName = "James" End Select
On 2 Feb 2004 05:05:20 -0800 in comp.databases.ms-access, la*************@hotmail.com (Lauren Quantrell) wrote: I'm running this on the front end to populate two parameters myName and myAltName. Maybe someone out there has done the same and has a lot more name combinations. Any help filling out this list is appreciated:
Select Case MyName Case "Richard" myAltName = "Dick" Case "Dick" myAltName = "Richard" Case "Robert" myAltName = "Bob" Case "Bob" myAltName = "Robert" Case "Matt" myAltName = "Mathew" Case "Mathew" myAltName = "Matt" Case "Tom" myAltName = "Thomas" Case "Thomas" myAltName = "Tom" Case "Daniel" myAltName = "Dan" Case "Maggie" myAltName = "Margaret" Case "Margaret" myAltName = "Maggie" Case "Susan" myAltName = "Sue" Case "Sue" myAltName = "Susan" Case "Elizabeth" 'opposite not needed: 'beth' is contained myAltName = "Beth" Case "Charles" myAltName = "Chuck" Case "Chuck" myAltName = "Charles" Case "Peter" myAltName = "Pete" 'opposite not needed: 'pete' is contained Case "James" myAltName = "Jim" Case "Jim" myAltName = "James" End Select
Why not use a table? Maintainable by users rather than programmers.
tblAltName
MyName text (pk)
AltName text (pk)
MyAltName = Nz(DLookup("AltName","tblAltName","MyName=" & MyNAme &
"'"),MyName)
--
A)bort, R)etry, I)nfluence with large hammer.
You are right, a table would be best. I'm using a SQL Server backend
and I'm trying to avoid round trips to the server. I'll look at it
though. Thanks for the tip.
lq
Trevor Best <bouncer@localhost> wrote in message news:<vq********************************@4ax.com>. .. On 2 Feb 2004 05:05:20 -0800 in comp.databases.ms-access, la*************@hotmail.com (Lauren Quantrell) wrote:
I'm running this on the front end to populate two parameters myName and myAltName. Maybe someone out there has done the same and has a lot more name combinations. Any help filling out this list is appreciated:
Select Case MyName Case "Richard" myAltName = "Dick" Case "Dick" myAltName = "Richard" Case "Robert" myAltName = "Bob" Case "Bob" myAltName = "Robert" Case "Matt" myAltName = "Mathew" Case "Mathew" myAltName = "Matt" Case "Tom" myAltName = "Thomas" Case "Thomas" myAltName = "Tom" Case "Daniel" myAltName = "Dan" Case "Maggie" myAltName = "Margaret" Case "Margaret" myAltName = "Maggie" Case "Susan" myAltName = "Sue" Case "Sue" myAltName = "Susan" Case "Elizabeth" 'opposite not needed: 'beth' is contained myAltName = "Beth" Case "Charles" myAltName = "Chuck" Case "Chuck" myAltName = "Charles" Case "Peter" myAltName = "Pete" 'opposite not needed: 'pete' is contained Case "James" myAltName = "Jim" Case "Jim" myAltName = "James" End Select
Why not use a table? Maintainable by users rather than programmers.
tblAltName MyName text (pk) AltName text (pk)
MyAltName = Nz(DLookup("AltName","tblAltName","MyName=" & MyNAme & "'"),MyName) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Leader |
last post by:
HI,
i got a problem while using StrConv function in sql server.
My requirement is:-
suppose in a name field i have "jhon smith" Now i want to run a sql
which will give me the result like "Jhon...
|
by: dixie |
last post by:
I am using an update query to parse out the Firstname of a person from a
field (GivenNames) in a list of names. The criteria I am using is
Left(,InStr(1,," ")-1)
This works fine if the person...
|
by: Theresa Hancock via AccessMonster.com |
last post by:
I have an Excel table I need to import into Access. The name is entered into one field "Name". I'd like to have two fields in Access, FirstName and LastName. How do I do this.
--
Message posted...
|
by: musicloverlch |
last post by:
I used to have a function that would change data that came across as
LASTNAME, FIRSTNAME MI to FirstName M. LastName with an update query.
Does that sould familar to anyone?
Thanks in advance,...
|
by: Ken Adeniji |
last post by:
Must declare the scalar variable '@FirstName'
ContactGridViewWebForm.aspx
<aspqlDataSource
RunAt="server"
ID="SqlDataSourceContact"
...
|
by: Nico Grubert |
last post by:
Hi there,
I have a string 'Michèle' that represents the firstname of a person.
What's the best way to get all possible versions of this name if I
consider to use these characters: e, è, é, ê
...
|
by: imani_technology_spam |
last post by:
I'm sure you all have seen situations where a field has a combined name
in the format of "Lastname, Firstname Middlename" and I've seen
examples of parsing that type of field. But what happens...
|
by: alxasa |
last post by:
Hello, I am hoping someone can help me with this. I need a javascript
function, which sits inside a <input type="text" name="firstname">
line of code. Now, if someone starts typing fine, but when...
|
by: avssiva |
last post by:
I am doing one project . in that we are using smtp and pop3 mail servers sending and receving respectively. My problem is display USERNAME(LASTNAME OR FIRST NAME ) in the place of Sender email-id. ...
|
by: ramprakashjava |
last post by:
hi ,
i hav this error while running this customerDetails.jsp
<html:html>
<head>
<html:base/>
</head>
<body>
<html:errors/>
<html:form...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |