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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autonumber -Reset to a lower number
I have an autonumber field which is the primary key linked to other tables. I want to set the autonumber field to a lower number i.e I started at 90000 and and now have exceeded 99999, six digits wont work for me. I want to reset to 50000. I have tried the append method, but the autonumber still increments from the highest number 100004
|
#2
|
|||
|
|||
Autonumber -Reset to a lower number
On Fri, 4 Jun 2004 14:46:05 -0700, "Mike"
wrote: I have an autonumber field which is the primary key linked to other tables. I want to set the autonumber field to a lower number i.e I started at 90000 and and now have exceeded 99999, six digits wont work for me. I want to reset to 50000. I have tried the append method, but the autonumber still increments from the highest number 100004 I'd suggest that you not use an Autonumber for this purpose. Autonumbers have one purpose, and one purpose ONLY: to provide an (almost, except for occasional bugs) guaranteed unique identifier. They are not editable and (as you can see) not readily controlled. You might want instead to use a Long Integer field and use one of the many VBA routines available to increment it. What is the largest value currently in your table? Do you have a gap available in which to insert numbers? What do you want to do with record 100003? John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
#3
|
|||
|
|||
Autonumber -Reset to a lower number
Mike wrote:
I have an autonumber field which is the primary key linked to other tables. I want to set the autonumber field to a lower number i.e I started at 90000 and and now have exceeded 99999, six digits wont work for me. I want to reset to 50000. I have tried the append method, but the autonumber still increments from the highest number 100004 I agree with John. You are trying to use autonumber for something not intended. There are some work arounds that might do what you want, but it is far better to never use an autonumber where the user is going to see it. It should be used for internal (to Access) only. -- Joseph E. Meehan 26 + 6 = 1 It's Irish Math |
Thread Tools | |
Display Modes | |
|
|