Results 1 to 3 of 3

Thread: AutoField

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: AutoField

    How could I change the AutoNumber of AutoField to start form 10000 for example instead of starting from 1

    Also can I change the step of its increment? It is usually 1.
    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580

    Resource

    http://www.mvps.org/access/general/gen0025.htm

    I think if you import 9999 records into a table, delete them, it will then start on 10000, but please read to the above link. Very good site with lots of interesting tips and tricks.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Resource

    Originally posted by garethdart
    http://www.mvps.org/access/general/gen0025.htm

    I think if you import 9999 records into a table, delete them, it will then start on 10000, but please read to the above link. Very good site with lots of interesting tips and tricks.
    Thank you for your nice Link and answer, I could do it also through an Append Query. I read it in the help of the ACCESS

    Thanks

Posting Permissions

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