Change the initial number for AutoNumber to begin with

Discussion in 'Microsoft Access Forms' started by Jennifer, Mar 11, 2004.

  1. Jennifer

    Jennifer Guest

    Can someone explain how I change my autonumber's beginning
    number? I don't want 1, I want 400,000. I tried doing it
    through Access help (with my program) and it didn't work!

    I created a new table, Table1, with same field name that I
    want to change (Invoice#)and added 399999 as a long
    integer. Then I created a query with Invoice# field from
    Table1, dragged Invoive# from top of query to Invoice#
    field in list below, datasheet, run, design. After this I
    understood I was supposed to delete Table1 and after this
    I'm lost...
    Thanks in advance for the help!
     
    Jennifer, Mar 11, 2004
    #1
    1. Advertisements

  2. Jennifer

    StCyrM Guest

    Hi Jennifer

    The following procedure will do it for you.

    Best regards
    Maurice


    By design, Microsoft Access always numbers AutoNumber fields beginning
    with the number 1. You cannot edit an AutoNumber field or change its
    starting value.

    However, you can force Microsoft Access to number an AutoNumber field with
    a number you choose by following these general steps:

    - Copy the design of the original table in which you want to set the
    starting AutoNumber value to a new table.


    - Change the AutoNumber field in the new table to a Number field with a
    FieldSize property of Long Integer.

    - Add a record to the new table, and set the Number field to a value that
    is one less than the starting number you want for your original table.
    For example, if you want the AutoNumber field to start at 100, type 99
    in the Number field of the new table.

    - Use an append query to add a this new record to your original table.
    This action forces Microsoft Access to number any new AutoNumber
    fields with your number plus 1.




    >Can someone explain how I change my autonumber's beginning
    >number? I don't want 1, I want 400,000. I tried doing it
    >through Access help (with my program) and it didn't work!
    >
    >I created a new table, Table1, with same field name that I
    >want to change (Invoice#)and added 399999 as a long
    >integer. Then I created a query with Invoice# field from
    >Table1, dragged Invoive# from top of query to Invoice#
    >field in list below, datasheet, run, design. After this I
    >understood I was supposed to delete Table1 and after this
    >I'm lost...
    >Thanks in advance for the help!
    >
    >
    >
    >
    >
    >
     
    StCyrM, Mar 11, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Keith
    Replies:
    3
    Views:
    586
    Gary Miller
    Nov 12, 2003
  2. Julian Ganoudis
    Replies:
    2
    Views:
    544
    Guest
    Jan 12, 2004
  3. SL

    initial number and last number of interval

    SL, Jan 24, 2004, in forum: Microsoft Access Forms
    Replies:
    3
    Views:
    169
    Frank Dulk
    Jan 24, 2004
  4. John
    Replies:
    2
    Views:
    137
  5. Dirk
    Replies:
    2
    Views:
    267
Loading...

Share This Page