Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page