Welcome to SPN

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

Sign Up Now!

copying entries and changing....

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

  1. Gary

    Gary
    Expand Collapse
    Guest

    I am new to Access....can this be done?

    lets say i have records like this:

    TEST1A
    TEST1B
    TEST1C

    I want to copy all three of them and paste them at the end so that I could
    edit them and change them so that the list will be like this.

    TEST1A
    TEST1B
    TEST1C
    TEST2A
    TEST2B
    TEST2C

    I seem to get an error say there is duplicate entries before I can even
    paste them.
    Is there some sort of override that I can set so that I can do this and then
    maybe set the override back?
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013
    Sikh News Entries from Torontoist tagged with 'sikhism' (Torontoist) Breaking News Apr 24, 2008
    Sikh News 61 entries for Realtech Punjab Open Ladies Golf (Deepika) Breaking News Oct 23, 2007
    Sikh News 61 entries for Realtech Punjab Open Ladies Golf (Deepika) Breaking News Oct 22, 2007

  3. Delordson Kallon

    Delordson Kallon
    Expand Collapse
    Guest

    Hi Gary,

    Open the table in design view, select the field, at the bottom of the table,
    on the general tab, look for the indexed property and change it to 'No'. Your
    current setting is stoping you putting the same entry in two rows.

    Delordson Kallon
    www.instantsoftwaretraining.com


    "Gary" wrote:

    > I am new to Access....can this be done?
    >
    > lets say i have records like this:
    >
    > TEST1A
    > TEST1B
    > TEST1C
    >
    > I want to copy all three of them and paste them at the end so that I could
    > edit them and change them so that the list will be like this.
    >
    > TEST1A
    > TEST1B
    > TEST1C
    > TEST2A
    > TEST2B
    > TEST2C
    >
    > I seem to get an error say there is duplicate entries before I can even
    > paste them.
    > Is there some sort of override that I can set so that I can do this and then
    > maybe set the override back?
    >
    >
    >
     
  4. Gary

    Gary
    Expand Collapse
    Guest

    Well....that just opened up a whole can of worms....
    I tried doing that and it seems that one of the fields has a KEY associated
    with it...So I tried to click to remove the KEY... Then it said to remove the
    RELATIONSHIP. Haven't figured out how to do that one yet.

    I would like to keep everything the same but just be able to create
    duplicates for easy data entry.........
     
  5. Delordson Kallon

    Delordson Kallon
    Expand Collapse
    Guest

    OK, instead of 'No', set it to 'Yes (Duplicates OK)'.

    Delordson Kallon
    www.instantsoftwaretraining.com

    "Gary" wrote:

    > Well....that just opened up a whole can of worms....
    > I tried doing that and it seems that one of the fields has a KEY associated
    > with it...So I tried to click to remove the KEY... Then it said to remove the
    > RELATIONSHIP. Haven't figured out how to do that one yet.
    >
    > I would like to keep everything the same but just be able to create
    > duplicates for easy data entry.........
    >
     
  6. Gary

    Gary
    Expand Collapse
    Guest

    I tried that but it wont let me change it because it has a KEY in turn has a
    RELATIONSHIP. It just wont let me change nothing without deleting those...
    I dont think I'm supposed to delete those

    "Delordson Kallon" wrote:

    > OK, instead of 'No', set it to 'Yes (Duplicates OK)'.
    >
    > Delordson Kallon
    > www.instantsoftwaretraining.com
    >
    > "Gary" wrote:
    >
    > > Well....that just opened up a whole can of worms....
    > > I tried doing that and it seems that one of the fields has a KEY associated
    > > with it...So I tried to click to remove the KEY... Then it said to remove the
    > > RELATIONSHIP. Haven't figured out how to do that one yet.
    > >
    > > I would like to keep everything the same but just be able to create
    > > duplicates for easy data entry.........
    > >
     
  7. Delordson Kallon

    Delordson Kallon
    Expand Collapse
    Guest

    Hi Gary,

    My apologies. It's now clear to me that the field you are trying to make
    entries into is the primary key field. Such a field will not allow duplicates
    which is what you are entering when you copy and paste. What you want to do
    cannot be done on this field.

    Delordson Kallon


    "Gary" wrote:

    > I tried that but it wont let me change it because it has a KEY in turn has a
    > RELATIONSHIP. It just wont let me change nothing without deleting those...
    > I dont think I'm supposed to delete those
    >
    > "Delordson Kallon" wrote:
    >
    > > OK, instead of 'No', set it to 'Yes (Duplicates OK)'.
    > >
    > > Delordson Kallon
    > > www.instantsoftwaretraining.com
    > >
    > > "Gary" wrote:
    > >
    > > > Well....that just opened up a whole can of worms....
    > > > I tried doing that and it seems that one of the fields has a KEY associated
    > > > with it...So I tried to click to remove the KEY... Then it said to remove the
    > > > RELATIONSHIP. Haven't figured out how to do that one yet.
    > > >
    > > > I would like to keep everything the same but just be able to create
    > > > duplicates for easy data entry.........
    > > >
     
  8. Rohan via AccessMonster.com

    Rohan via AccessMonster.com
    Expand Collapse
    Guest

Share This Page