Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

problem with autonumber field

Discussion in 'Information Technology' started by Faisal Sharif, Jul 28, 2006.

  1. Faisal Sharif

    Faisal Sharif
    Expand Collapse
    Guest

    i want to change the starting value of the autonumber field to the value
    that i want one way is the ubdate query .............
    is there another way of changing the starting value
    if there is , kindly inform me . thanks
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Sikhs Face Problems While Carrying Kirpans In Khyber-Pakhtunkhwa - SikhSiyasat.Net Breaking News Jul 29, 2016
    "Dasam" Granth - A Look At The Core Problems Dasam Granth Oct 21, 2015
    Problems In Life Sikh Sikhi Sikhism Apr 13, 2015
    How can I make decent and useful friends and from where ?? most people have a problem with me Sikh Youth Oct 23, 2013
    The Problem with Taking Too Many Vitamins Health & Nutrition Oct 18, 2013

  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Faisal,

    You can use data definition language for a new autonumber field, as in this
    example:

    http://support.microsoft.com/kb/202121/en-us


    Tom Wickerath, Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Faisal Sharif" wrote:

    > i want to change the starting value of the autonumber field to the value
    > that i want one way is the ubdate query .............
    > is there another way of changing the starting value
    > if there is , kindly inform me . thanks
     
  4. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    Faisal Sharif wrote:
    > i want to change the starting value of the autonumber field to the
    > value that i want one way is the ubdate query .............
    > is there another way of changing the starting value
    > if there is , kindly inform me . thanks


    I suggest you may not want to use Autonumber for that use. Autonumbers are
    designed to provide unique numbers. It in not designed to provide numbers
    in order and for a number of reasons may not do so. As a result using them
    in any application where the user sees the numbers is likely to end up with
    confusion.

    There are other ways of providing the numbers you want depending on the
    particual application.


    --
    Joseph Meehan

    Dia duit
     

Share This Page