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

copy/paste multiple records

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

  1. Kaur

    Expand Collapse

    Hi, I have been successful copying a vba code from one of your posts on
    how to copy and paste a record by declaring the desired fields that
    needs to be copied in form's declaration and creating two button "copy"
    and "paste". Works like magic.
    My problem is how can I copy multiple records and paste them at the
    same time. My data entry form has main form that has a Questionlist box
    of Questions. The second list box on the same form displays
    subquestions based on the selection made in Question list box. The
    subform allows to add response for a selected subquestion. Majority of
    the time response choices are the same for all the subquestion.
    Based on the scenario below, if I do data entry for SubquestionA, I
    want to copy/paste all three records to Subquestion B and Subquestion
    Question A has
    Sub questions A, B, C.
    SubQuestion A: Response Choice: 1, 2, 3
    SubQuestion B: Response Choice: 1, 2, 3
    SubQuestion C: Response Choice: 1, 2, 3

    Please let me know how can I achieve that. It will save a lot of time
    entering the same records.
    Thanks for all your help.
  2. Loading...

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