Autonumber starting point

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me how make an autonumber field begin at a predetermined
starting point? For example, I want the number to begin numbering at 100
instead of at 1. There's a way to change the increment for each record's
autonumber as well, but I don't remember how. Thanks in advance.
 
You can't change the increment of an autonumber to something like 5, 10, 15,
20, etc. While you can start an autonumber at 100, you can't control if
Access suddenly wants to make the next number 22, 1 or even -100.

Autonumbers are only garenteed to be unique IF that field is also a Primary
Key (Even then there's a little bug that can mess that up). If you need your
numbers to be a certain sequence, especially without breaks as in an
invoice#, autonumber isn't the right tool.
 
You can't change the increment of an autonumber to something like 5, 10, 15,
20, etc.
Click to expand...

Oh yeah?

http://support.microsoft.com/kb/202121/

ACC2000: Cannot Change Default Seed and Increment Value in UI

"To resolve this problem, you can use Data Definition Language (DDL)
to create a table with an Identity column that has the seed and the
increment values that you want, other than the default value of one."

Use ADO. Set the autonumber increment value to anything you like. Use
DAO and live in the 1990s. Pick two. Aaron Kempff - MDB guru.
 
yes you can do this

it is called Acccces Data Projects and you can set the seed and the
increment values of an identity integer field
 
Back
Top