Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    TN
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to change Record # (2000)

    THANKS for "everyones" help with my last problem. I used the FORM to make my Template for printing information from my Access Database, onto a Death Certificate.

    NOW - I have another one. I only had 4 records in the database because I wanted to play around with it before I actually got serious about using it....now, when I add a new record, the ID Record Number reads in the 80's, and keeps going up.

    HOW can I change that to read like, Record Number 5, 6, 7, etc.?

    Thanks, I really appreciate the help and Tips.

    Ray

  2. #2
    New Lounger
    Join Date
    Apr 2002
    Location
    Columbus, Ohio, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to change Record # (2000)

    Ray: Since you are still in the 'play around' stage, delete all the records, then do a compact and repair. This will reset your ID Record Number to 1, assuming the data type is AutoNumber. HTH.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to change Record # (2000)

    If you compact the database, the autonumber field will continue at 1 more than the current maximum.

    Keep in mind that you really shouldn't use autonumber fields for things that users will see unless you make it clear that there will be missing numbers over time (for instance, if you start a new record but never save it, that autonumber will still be "used up").

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •