A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

unique record numbers



 
 
Thread Tools Display Modes
  #1  
Old March 6th, 2010, 04:19 AM posted to microsoft.public.access.tablesdbdesign
Rev David Bissas
external usenet poster
 
Posts: 1
Default unique record numbers

I am trying to create a unique PIN for members in a table (not the primary
key) that will be 4 digits long, and would like each new entry to be
incremental. I am very new, and would appreciate a detailed instruction
(though I can get around access fair enough). Any help would be appreciated.
  #3  
Old March 6th, 2010, 06:19 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default unique record numbers

PINs are suppose to be confidential and no one is suppose to know anyone
else's PIN. This being the case, why would the PINs need to be incremental?
You're just making it hard on yourself. Just use an autonumber starting at
some appropriate four digit number. If you should skip a number, so what!

Steve



"Rev David Bissas" Rev David
wrote in
message ...
I am trying to create a unique PIN for members in a table (not the primary
key) that will be 4 digits long, and would like each new entry to be
incremental. I am very new, and would appreciate a detailed instruction
(though I can get around access fair enough). Any help would be
appreciated.



  #4  
Old March 6th, 2010, 08:16 PM posted to microsoft.public.access.tablesdbdesign
Stop$teve
external usenet poster
 
Posts: 76
Default unique record numbers


"Steve" schreef in bericht ...
If you should skip a number, so what!

Steve



If you shoukd skip your adds... so what !!
We would love you... (At least some of us here...)

Regards, Arno R


  #5  
Old March 7th, 2010, 04:35 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default unique record numbers

Steve offers a cogent point. If your PINs are sequential, and if I have a
PIN, what's to stop me from trying out the number before and after mine?

Are you confident that folks wont be able to use brute force to try all
10,000 possibilities? Are you confident you'll never have 10,000 PINs to
generate?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Rev David Bissas" Rev David wrote in
message ...
I am trying to create a unique PIN for members in a table (not the primary
key) that will be 4 digits long, and would like each new entry to be
incremental. I am very new, and would appreciate a detailed instruction
(though I can get around access fair enough). Any help would be
appreciated.



  #6  
Old March 12th, 2010, 12:10 AM posted to microsoft.public.access.tablesdbdesign
accessnewbie79915
external usenet poster
 
Posts: 4
Default unique record numbers

I am new to access myself, but I do know enough to say that if you adopt the
autonumber setup it would work better for you. However, do not skip numbers
when building your database. The reason for this is that when it comes time
to query your data into reports and forms, if you skip numbers it could cause
problems pulling in the data that you want.

"Rev David Bissas" wrote:

I am trying to create a unique PIN for members in a table (not the primary
key) that will be 4 digits long, and would like each new entry to be
incremental. I am very new, and would appreciate a detailed instruction
(though I can get around access fair enough). Any help would be appreciated.

  #7  
Old March 14th, 2010, 08:15 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 1,555
Default unique record numbers

Depending on your definition of "autonumber"...

If you mean what Access provides, we can almost guarantee there will be
"skipped" numbers.

If you mean a custom "autonumber" (lower case) function, it could ensure
that numbers are guaranteed sequential ... BUT! if someone were to delete a
record, there would still be a missing/skipped number!

Good luck

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"accessnewbie79915" wrote in
message ...
I am new to access myself, but I do know enough to say that if you adopt
the
autonumber setup it would work better for you. However, do not skip
numbers
when building your database. The reason for this is that when it comes
time
to query your data into reports and forms, if you skip numbers it could
cause
problems pulling in the data that you want.

"Rev David Bissas" wrote:

I am trying to create a unique PIN for members in a table (not the
primary
key) that will be 4 digits long, and would like each new entry to be
incremental. I am very new, and would appreciate a detailed instruction
(though I can get around access fair enough). Any help would be
appreciated.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.