Welcome to SPN

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

Sign Up Now!

deleting row but wanted the row numbers in running order ?

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

  1. tikchye_oldLearner57

    tikchye_oldLearner57
    Expand Collapse
    Guest

    hello community

    can someone please assist me in solving this problem...

    I entered a name in a "Field Name Col" and same time entered the ID number
    into the "Field ID Col" and saved the database.

    Upon re-opening the database, and making a query by using the name that I
    had previously entered, the result was not found then when I entered the ID
    number of that belongs to the "unfound" name, the query was displayed.

    I then found out that the name that I used was "wrong" and I did a change in
    the "Field Name" but when do a "save", it prompted me..."duplicated
    data......not able to be save"

    now, I am unable to do anything to this Name that I had entered wrongly. Is
    there a way where I can delete this row and recreate the data entry but I
    still need the row serial numbers to be in same running order

    (from what I see, the Name and ID field lists are set to have Primary Key)

    can anybody please clarify for me




    --
    oldLearner57
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Is Mahesh Bhatt considering deleting Meera's controversial kissing ... Breaking News Mar 4, 2005
    Sorrow Makes You Realize The Unreality Of This World And All Its Relations Hard Talk Nov 20, 2016
    Sikh News Sikh Farmers Flatten Ravines To Grow Basmati - Times Of India Breaking News Jul 27, 2016
    Sikh News Profiled US Sikh Throws 'Know Me' Challenge Breaking News Jul 25, 2016
    Pacific Storms Hit Banana-growing Sikh Community Hard Breaking News Jun 9, 2016

  3. Joseph Meehan

    Joseph Meehan
    Expand Collapse
    Guest

    tikchye_oldLearner57 wrote:
    > hello community
    >
    > can someone please assist me in solving this problem...
    >
    > I entered a name in a "Field Name Col" and same time entered the ID
    > number into the "Field ID Col" and saved the database. ...



    Access does not have row numbers.

    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.


    As it is you are going to need to jump through quite a few hoops to get
    what you want and it is going to happen again and again.


    --
    Joseph Meehan

    Dia duit
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    If you want to change the entry in the Name field, simply type over it. It
    sounds like you are trying to enter a new record with the same ID number and
    the corrected name. If the record is already there, change it, don't add a
    new one.



    --
    Rick B



    "tikchye_oldLearner57" <tikchyeoldLearner57@discussions.microsoft.com> wrote
    in message news:3CDD697D-09D8-4DF4-B01B-C1C353979A78@microsoft.com...
    > hello community
    >
    > can someone please assist me in solving this problem...
    >
    > I entered a name in a "Field Name Col" and same time entered the ID number
    > into the "Field ID Col" and saved the database.
    >
    > Upon re-opening the database, and making a query by using the name that I
    > had previously entered, the result was not found then when I entered the
    > ID
    > number of that belongs to the "unfound" name, the query was displayed.
    >
    > I then found out that the name that I used was "wrong" and I did a change
    > in
    > the "Field Name" but when do a "save", it prompted me..."duplicated
    > data......not able to be save"
    >
    > now, I am unable to do anything to this Name that I had entered wrongly.
    > Is
    > there a way where I can delete this row and recreate the data entry but I
    > still need the row serial numbers to be in same running order
    >
    > (from what I see, the Name and ID field lists are set to have Primary
    > Key)
    >
    > can anybody please clarify for me
    >
    >
    >
    >
    > --
    > oldLearner57
     

Share This Page