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

    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

    thanxsss

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    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
  •