Previous Thread

6/15/2006 7:39:02 AM    Autonumber
Is there anyway to start an autonumber field at a specific number in Access XP?



6/15/2006 10:57:06 PM    Re: Autonumber
See: 
 
Set AutoNumbers to start from ... 
 
at: 
 
http://allenbrowne.com/ser-26.html 
 
-- 
 
Allen Browne - Microsoft MVP.  Perth, Western Australia. 
 
Tips for Access users - http://allenbrowne.com/tips.html 
 
Reply to group, rather than allenbrowne at mvps dot org. 
 
"Karla" <Karla@discussions.microsoft.com> wrote in message 
 
news:92E241E9-EDC6-41DE-8498-F3EBABEBA518@microsoft.com...

6/15/2006 11:01:16 PM    Re: Autonumber
Karla wrote: 
 
I suggest you may not want to use Autonumber for that use.  Autonumbers are 
 
designed to provide unique numbers.  It in not designed to provide numbers 
 
in order and for a number of reasons may not do so.  As a result using them 
 
in any application where the user sees the numbers is likely to end up with 
 
confusion. 
 
There are other ways of providing the numbers you want depending on the 
 
particual application. 
 
-- 
 
Joseph Meehan 
 
Dia duit