How can we create a unique and non-editable ID from client's first and
last name?
eg.: SmitJ1 for John Smith
Matuag
28  4107 
Left([LastName],4) & Left([FirstName],1) & TryCount
Keep incrementing TryCount in a loop until you get a unique ID then create
the record with an append query. On your form, make the field read only.
Don't use it as a primary key, so when the last name changes you can change
the ID without changing your detail records.
"Matuag" <ma****@gmail.c omwrote in message
news:11******** **************@ u36g2000prd.goo glegroups.com.. .
How can we create a unique and non-editable ID from client's first and
last name?
eg.: SmitJ1 for John Smith
Matuag
Per Matuag:
>How can we create a unique and non-editable ID from client's first and
last name?
eg.: SmitJ1 for John Smith
What function will it need to fulfill?
--
PeteCresswell
>
What function will it need to fulfill?
--
PeteCresswell
I just need it to identify the record. It already has a Primary Key
setup.
On May 25, 12:25 am, "paii, Ron" <p...@packairin c.comwrote:
Left([LastName],4) & Left([FirstName],1) & TryCount
Keep incrementing TryCount in a loop until you get a unique ID then create
the record with an append query. On your form, make the field read only.
Don't use it as a primary key, so when the last name changes you can change
the ID without changing your detail records.
Thanks Ron.
I could do this in a query. Now I do not want it to change even if
there is any change in Last Name. I want to use this to identify the
client's record.
"Matuag" <ma****@gmail.c omwrote in message
news:11******** **************@ x18g2000prd.goo glegroups.com.. .
What function will it need to fulfill?
--
PeteCresswel l
I just need it to identify the record. It already has a Primary Key
setup.
Define "to identify the record". The PK already does that.
Keith.
>
Define "to identify the record". The PK already does that.
Keith.
I want an alphanumeric ID rather than its auto numbered ID, for using
it on all manual records for clients. I am reluctant to use primary
key because I do not want users to know the total number of clients.
Per Matuag:
>I want an alphanumeric ID rather than its auto numbered ID, for using
it on all manual records for clients. I am reluctant to use primary
key because I do not want users to know the total number of clients.
The junk mail that I get in my mailbox seems to use a fraction of
the last name, the house number, and some fraction of the street
name a lot.
But it all still begs the question "Why". Is it so customers
can say over the phone something like "Cresswell 303 Friendship"
and the person at the other end can look up "Cress303Friend "?
--
PeteCresswell
(PeteCresswell) wrote:
Per Matuag:
>I want an alphanumeric ID rather than its auto numbered ID, for using
it on all manual records for clients. I am reluctant to use primary
key because I do not want users to know the total number of clients.
The junk mail that I get in my mailbox seems to use a fraction of
the last name, the house number, and some fraction of the street
name a lot.
But it all still begs the question "Why". Is it so customers
can say over the phone something like "Cresswell 303 Friendship"
and the person at the other end can look up "Cress303Friend "?
It sort of makes sense if it used on paper work (manual records?).
Cress303Friend would be entered to bring up the exact records for Pete
Cresswell instead of searching on something that brings up more than
one record.
Sort of.
"Matuag" <ma****@gmail.c omwrote in message
news:11******** **************@ b40g2000prd.goo glegroups.com.. .
On May 25, 12:25 am, "paii, Ron" <p...@packairin c.comwrote:
Left([LastName],4) & Left([FirstName],1) & TryCount
Keep incrementing TryCount in a loop until you get a unique ID then
create
the record with an append query. On your form, make the field read only.
Don't use it as a primary key, so when the last name changes you can
change
the ID without changing your detail records.
Thanks Ron.
I could do this in a query. Now I do not want it to change even if
there is any change in Last Name. I want to use this to identify the
client's record.
You don't have to change it, but if you want is to provide an easily
remembered client ID then if the name changes, your users will want to
changing the ID. By providing a hidden ID for linking detail records,
changing the visible ID will not be a problem. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Tony Clarke |
last post by:
Hi,
I'm trying to write a system thats used for about 50 clients that uses html
forms and php to log details. The problem is that when a client loads the
form page it's given a value which is the last record in a table +1 (i.e. so
its the next record). The problem with that is that a client could sit on
that page for 20 mins (or whatever length of time) and a different client
could use that record number and there what be an error...
|
by: Louis Frolio |
last post by:
Greetings All, I have read many upon many articles here regarding GUID
data types and uniqueness. There have been many opinions regarding
the effectiveness of GUID's and when they should/should not be used.
However, every article strongly implies, if it does not state it
outright, that GUID's are always unique. My question is this, what
happens if you have a database that uses GUID's and the NIC is changed
out on the box? From what I...
|
by: UJ |
last post by:
Is there any number I can get that is truly unique for a computer that can't
be changed? I want to have a system whereby I have a computer that accesses
a web service based on some unique value that can't be changed. Or at least
if it is changed, it's not changed frequently. (IP address won't work
because that can change frequently).
Here's my thought - the program boots up, finds some unique piece of
information, sends that off to the...
|
by: bwmiller16 |
last post by:
Guys -
I'm doing a database consistency check for a client and I find that
they're building unique indexes for performance/query reasons where
they could be using non-unique indexes.
Note that these columns in the unique indexes are truly unique and
don't constitute a collision hazard of any kind.
Now, I personally wouldn't use unique where non-unique would do but I
|
by: Mamuninfo |
last post by:
Hello,
Have any function in the DB2 database that can generate unique id
for each string like oracle, mysql,sybase,sqlserver database.
In mysql:-
select md5(concat_ws("Row name")) from tablename;
Here this function generate unique id for each row of the table.
Regards..
| | |
by: Goh |
last post by:
Hi,
I would like to know how can we implement a web page that
intelligent enough to unique identify that pc have been visit before without
any cookies and login user require.
I have try implement this by MAC address. When user browser the web
site I sometime can get user pc MAC and sometime no.
Why this type of implementation are so not consistency? Does any
|
by: Jimmy Stewart |
last post by:
Ok, I'm trying to write a query that is starting to wear me down.
What I'm trying to do is create a year end report that gets sent to all of
my customers who meet two criteria. One they are 'Residential' customer AND
they have had business with us during this past year.
My report is based on a query.
The query has two tables associated with it. One is tblClients which
provides client name, account type and the other relevant mailing...
|
by: tony obrien |
last post by:
Hi,
I have written a Class Library in VB.net which provides Props/Meths to a
caller to hide the uglinesses of a TCP message protocol between a Client
and a Server.
All this works just fine.
Now I am trying to develop a LOAD TESTER app which spawns lotso' threads
each with this capability to bang the server.
|
by: Mufasa |
last post by:
I'm looking for a way to get a truly unique identifier for a machine for our
client software. I'd like to have it so that there's little or no setup by
the end user. (We set up the machines and then ship them out for most cases
but some of our customers do provide their own machines.) Our concern is if
somebody takes one of our machines and ghosts it so they have a complete
copy of the machine, it will allow them to continue working.
We...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
