Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003

    Red face Unanswered: Restart autonumeric number

    My aplication is built in VB and work with access 97. My transaction number is autonumeric and work in this way 02001, the first two number are the current year, and the last 3 are de autonumeric. I already know how to change to 03 but i don't know how to restar the autonumeric without loosing data


  2. #2
    Join Date
    Feb 2002
    When you say autonumeric do you mean the autonumber data type in access ? If it is, how is the table defined and how are you using this combined field (the year/autonumber) ?

Posting Permissions

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