Asset Tracking Template

  • Thread starter Thread starter Bob Stamper
  • Start date Start date
B

Bob Stamper

I want to use the Asset Tracking template in Access 2000
but the program autonumbers the asset ID number. We have
our own numbering system. How do I change the AssetID to
accept a number I input or how do I start it autonumbering
from say 100 not 0?
 
Change the data type to Number (or text, if your numbering scheme requires
characters other than digits, or you need to store leading zeros).

Also consider the Field Size property if you use Number. The default Field
Size setting for Number fields in recent versions of Access is Long Integer,
which allows only whole numbers, you'll need to change it to another
setting, e.g. Double, if your numbers include a decimal part.

While it's possible to change the starting number of an AutoNumber field,
you'll inevitably end up with gaps in the sequence, as numbers are discarded
when you delete a record, or begin to enter a record then change your mind
and cancel by pressing the Esc key. AutoNumber fields are fine as unique
identifiers, with no other purpose, but not a good choice when you need an
unbroken sequence or need to record 'real world' values.
 
Back
Top