unique record numbers
in [Tables]
|
From: Rev David Bissas Rev David on 5 Mar 2010 22:19 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.
From: Tom van Stiphout on 5 Mar 2010 23:18 On Fri, 5 Mar 2010 19:19:44 -0800, Rev David Bissas <Rev David Bissas(a)discussions.microsoft.com> wrote: The "DMax + 1" technique should work for you. Google or Bing for it. -Tom. Microsoft Access MVP >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.
From: Steve on 6 Mar 2010 12:19 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 santus(a)penn.com "Rev David Bissas" <Rev David Bissas(a)discussions.microsoft.com> wrote in message news:97B47057-B0D2-4329-86FB-267F9914F0DD(a)microsoft.com... >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.
From: Stop$teve on 6 Mar 2010 14:16 "Steve" <notmyemail(a)address.com> schreef in bericht news:%23GKx2EVvKHA.5936(a)TK2MSFTNGP04.phx.gbl... If you should skip a number, so what! > > Steve > santus(a)penn.com > If you shoukd skip your adds... so what !! We would love you... (At least some of us here...) Regards, Arno R
From: Jeff Boyce on 7 Mar 2010 10:35
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 Bissas(a)discussions.microsoft.com> wrote in message news:97B47057-B0D2-4329-86FB-267F9914F0DD(a)microsoft.com... >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. |