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 field changes to random from sequential
I design a table with the key field set to autonumber - sequential. I then
append records to it from another table imported from an Excel Spreadsheet. Why does the key field in the table being appended to change to autonumber - random every so often and how can I stop that. Thanks in advance. Anthony. |
#2
|
|||
|
|||
Autonumber field changes to random from sequential
Anthony
I may be reading too much into your description ... It sounds like you require the Autonumber field to be sequential. Are you aware that there's no guarantee that Autonumber will be sequential? The Access Autonumber field is intended to provide a unique row identifier, and is generally unfit for human consumption. Are you trying to display that number? Regards Jeff Boyce Microsoft Office/Access MVP "Anthony Fontana" wrote in message ... I design a table with the key field set to autonumber - sequential. I then append records to it from another table imported from an Excel Spreadsheet. Why does the key field in the table being appended to change to autonumber - random every so often and how can I stop that. Thanks in advance. Anthony. |
#3
|
|||
|
|||
Autonumber field changes to random from sequential
No. I just don't like the fact that (a) Access changes it to random when I
set it to sequential and (b) negative numbers are sometimes generated. We use the autonumber field for ID numbers which get printed on certain IDs and I think that assigning a negative ID number to person doesn't look right. Personally, I don't care if the numbers are random, I just don't like the negative numbers that the random setting seems to generate. Thanks "Jeff Boyce" wrote: Anthony I may be reading too much into your description ... It sounds like you require the Autonumber field to be sequential. Are you aware that there's no guarantee that Autonumber will be sequential? The Access Autonumber field is intended to provide a unique row identifier, and is generally unfit for human consumption. Are you trying to display that number? Regards Jeff Boyce Microsoft Office/Access MVP "Anthony Fontana" wrote in message ... I design a table with the key field set to autonumber - sequential. I then append records to it from another table imported from an Excel Spreadsheet. Why does the key field in the table being appended to change to autonumber - random every so often and how can I stop that. Thanks in advance. Anthony. |
#4
|
|||
|
|||
Autonumber field changes to random from sequential
Anthony
So you are trying to use automatically-generated (Autonumber) row identifiers as human-readable data (i.e., IDs). You've (re-)discovered one of the many reasons Autonumbers are not generally fit for human consumption. If you need a human-friendly ID number, add another field to your table and generate those numbers to be sequential (search for "Custom Autonumber" on-line or at mvps.org/access). Use that field instead of the Access Autonumber field. Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "Anthony Fontana" wrote in message ... No. I just don't like the fact that (a) Access changes it to random when I set it to sequential and (b) negative numbers are sometimes generated. We use the autonumber field for ID numbers which get printed on certain IDs and I think that assigning a negative ID number to person doesn't look right. Personally, I don't care if the numbers are random, I just don't like the negative numbers that the random setting seems to generate. Thanks "Jeff Boyce" wrote: Anthony I may be reading too much into your description ... It sounds like you require the Autonumber field to be sequential. Are you aware that there's no guarantee that Autonumber will be sequential? The Access Autonumber field is intended to provide a unique row identifier, and is generally unfit for human consumption. Are you trying to display that number? Regards Jeff Boyce Microsoft Office/Access MVP "Anthony Fontana" wrote in message ... I design a table with the key field set to autonumber - sequential. I then append records to it from another table imported from an Excel Spreadsheet. Why does the key field in the table being appended to change to autonumber - random every so often and how can I stop that. Thanks in advance. Anthony. |
Thread Tools | |
Display Modes | |
|
|