How can we create a unique and non-editable ID from client's first and
last name?
eg.: SmitJ1 for John Smith
Matuag
May 24 '07
28  4110 
On May 27, 11:42 am, "Tony Toews [MVP]" <tto...@teluspl anet.net>
wrote:
"paii, Ron" <p...@packairin c.comwrote:
My take on the original post was to hide even the APPEARANCE of a client
count.Using a random auto number will eliminate even the appearance of
meaningful information.
Which is a number about 10 digits long. Kinda cumbersome.
Tony
I agree with Tony. Thats why I wanted a shorter ( 6 / 7 digit) number,
which is easy to quote, read and write.
Matuag <ma****@gmail.c omwrote in
news:11******** *************@n 15g2000prd.goog legroups.com:
On May 27, 11:42 am, "Tony Toews [MVP]" <tto...@teluspl anet.net>
wrote:
>"paii, Ron" <p...@packairin c.comwrote:
>My take on the original post was to hide even the APPEARANCE of
a client count.Using a random auto number will eliminate even
the appearance of meaningful information.
Which is a number about 10 digits long. Kinda cumbersome.
I agree with Tony. Thats why I wanted a shorter ( 6 / 7 digit)
number, which is easy to quote, read and write.
Use a sequential Autonumber and display it with Hex(). Most people
won't be able to translate that into decimal.
For your users, you'll want a lookup that takes hexadecimal or
decimal numbers. If all the numbers are printed as Hex(), then
you'll want to default to hexadecimal.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
On May 27, 11:04 pm, "David W. Fenton" <XXXuse...@dfen ton.com.invalid >
wrote:
Matuag <mat...@gmail.c omwrote innews:11****** *************** @n15g2000prd.go oglegroups.com:
On May 27, 11:42 am, "Tony Toews [MVP]" <tto...@teluspl anet.net>
wrote:
"paii, Ron" <p...@packairin c.comwrote:
My take on the original post was to hide even the APPEARANCE of
a client count.Using a random auto number will eliminate even
the appearance of meaningful information.
Which is a number about 10 digits long. Kinda cumbersome.
I agree with Tony. Thats why I wanted a shorter ( 6 / 7 digit)
number, which is easy to quote, read and write.
Use a sequential Autonumber and display it with Hex(). Most people
won't be able to translate that into decimal.
For your users, you'll want a lookup that takes hexadecimal or
decimal numbers. If all the numbers are printed as Hex(), then
you'll want to default to hexadecimal.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
OK. Hex seems to be a good idea. Thanks.
Matuag wrote:
On May 27, 11:04 pm, "David W. Fenton" <XXXuse...@dfen ton.com.invalid >
wrote:
Matuag <mat...@gmail.c omwrote
innews:11****** *************** @n15g2000prd.go oglegroups.com:
On May 27, 11:42 am, "Tony Toews [MVP]" <tto...@teluspl anet.net>
wrote:
"paii, Ron" <p...@packairin c.comwrote:
My take on the original post was to hide even the APPEARANCE
of a client count.Using a random auto number will eliminate
even the appearance of meaningful information.
Which is a number about 10 digits long. Kinda cumbersome.
I agree with Tony. Thats why I wanted a shorter ( 6 / 7 digit)
number, which is easy to quote, read and write.
Use a sequential Autonumber and display it with Hex(). Most people
won't be able to translate that into decimal.
For your users, you'll want a lookup that takes hexadecimal or
decimal numbers. If all the numbers are printed as Hex(), then
you'll want to default to hexadecimal.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
OK. Hex seems to be a good idea. Thanks.
Actually, if you go with Hex() display I would also use random for the
AutoNumber. Otherwise the codes will be very similar looking within certain
data entry time-spans. With random you still get a nice 8 character
alpha-numeric value (with no worries about negative signs), but they will not be
in a close-set pattern. Someone is also more likely to see that they are an
incrementing value even when using Hex() if you stay with increment on the
AutoNumber.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
"Rick Brandt" <ri*********@ho tmail.comwrote in
news:u9******** *********@newss vr14.news.prodi gy.net:
Matuag wrote:
>On May 27, 11:04 pm, "David W. Fenton"
<XXXuse...@dfe nton.com.invali dwrote:
Matuag <mat...@gmail.c omwrote
innews:11****** *************** @n15g2000prd.go oglegroups.com:
On May 27, 11:42 am, "Tony Toews [MVP]"
<tto...@teluspl anet.netwrote:
"paii, Ron" <p...@packairin c.comwrote:
My take on the original post was to hide even the
APPEARANCE of a client count.Using a random auto number
will eliminate even the appearance of meaningful
information.
Which is a number about 10 digits long. Kinda cumbersome.
I agree with Tony. Thats why I wanted a shorter ( 6 / 7
digit) number, which is easy to quote, read and write.
Use a sequential Autonumber and display it with Hex(). Most
people won't be able to translate that into decimal.
For your users, you'll want a lookup that takes hexadecimal or
decimal numbers. If all the numbers are printed as Hex(), then
you'll want to default to hexadecimal.
OK. Hex seems to be a good idea. Thanks.
Actually, if you go with Hex() display I would also use random for
the AutoNumber. Otherwise the codes will be very similar looking
within certain data entry time-spans. With random you still get a
nice 8 character alpha-numeric value (with no worries about
negative signs), but they will not be in a close-set pattern.
Someone is also more likely to see that they are an incrementing
value even when using Hex() if you stay with increment on the
AutoNumber.
Yes, but you'll only see that when you have more than one number in
front of you. And most people won't see it as suggesting any
particular number of clients, which was the main problem for the OP.
My only question on this is how to format hex numbers so they are
all the same length? Format(Hex(Pers onID), "0000000") works only for
the values with all 0-9 digits and no letters. I guess you could use
padding instead.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"Tony Toews [MVP]" <tt****@teluspl anet.netwrote in message
news:7t******** *************** *********@4ax.c om...
"paii, Ron" <pa**@packairin c.comwrote:
My take on the original post was to hide even the APPEARANCE of a client
count.Using a random auto number will eliminate even the appearance of
meaningful information.
Which is a number about 10 digits long. Kinda cumbersome.
Which is another reason to hide the PK from the user.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
David W. Fenton wrote:
My only question on this is how to format hex numbers so they are
all the same length? Format(Hex(Pers onID), "0000000") works only for
the values with all 0-9 digits and no letters. I guess you could use
padding instead.
I must admit that I hadn't actually considered the length bit properly, but
was fooled by the statistics. Yes, you would have to use padded zeros to
ensure that all hex values would be 8 characters in length. However;
consider the following numbers...
I have an app used by nearly 300 remote users that submit records to our
corporate database that has been in use for over three years and is up to
48611 records so far. Of those NO hex value has less than 6 characters,
only 102 have 6 (0.2%), 1511 have 7 (3%), and all the rest have 8
characters. So any padding done would only affect (it would seem) a very
small percentage of all hex values.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
"Rick Brandt" <ri*********@ho tmail.comwrote in
news:du******** ********@newssv r19.news.prodig y.net:
David W. Fenton wrote:
>My only question on this is how to format hex numbers so they are
all the same length? Format(Hex(Pers onID), "0000000") works only
for the values with all 0-9 digits and no letters. I guess you
could use padding instead.
I must admit that I hadn't actually considered the length bit
properly, but was fooled by the statistics. Yes, you would have
to use padded zeros to ensure that all hex values would be 8
characters in length. However; consider the following numbers...
I have an app used by nearly 300 remote users that submit records
to our corporate database that has been in use for over three
years and is up to 48611 records so far. Of those NO hex value
has less than 6 characters, only 102 have 6 (0.2%), 1511 have 7
(3%), and all the rest have 8 characters. So any padding done
would only affect (it would seem) a very small percentage of all
hex values.
Yes, but if the app was converted to random Autonumber after the
table was already populated, you're going to have a lot of low
Autonumber values, and those are going to need to be padded. I
tested Hex() on just such data, and that's why I noticed it.
Do current versions of Access have a Pad() function or do you have
to write one for yourself? It's simple enough to do, of course, and
I"ve probably written one a half dozen different times, but have
never considered it useful enough to import into my code library.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
David W. Fenton wrote:
"Rick Brandt" <ri*********@ho tmail.comwrote in
news:du******** ********@newssv r19.news.prodig y.net:
David W. Fenton wrote:
My only question on this is how to format hex numbers so they are
all the same length? Format(Hex(Pers onID), "0000000") works only
for the values with all 0-9 digits and no letters. I guess you
could use padding instead.
I must admit that I hadn't actually considered the length bit
properly, but was fooled by the statistics. Yes, you would have
to use padded zeros to ensure that all hex values would be 8
characters in length. However; consider the following numbers...
I have an app used by nearly 300 remote users that submit records
to our corporate database that has been in use for over three
years and is up to 48611 records so far. Of those NO hex value
has less than 6 characters, only 102 have 6 (0.2%), 1511 have 7
(3%), and all the rest have 8 characters. So any padding done
would only affect (it would seem) a very small percentage of all
hex values.
Yes, but if the app was converted to random Autonumber after the
table was already populated, you're going to have a lot of low
Autonumber values, and those are going to need to be padded. I
tested Hex() on just such data, and that's why I noticed it.
Do current versions of Access have a Pad() function or do you have
to write one for yourself? It's simple enough to do, of course, and
I"ve probably written one a half dozen different times, but have
never considered it useful enough to import into my code library.
As far as I know there is none built in. I have always just coded it myself,
but as with you have never built a generic function for doing so.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com 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: 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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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: 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...
| |
