Results 1 to 4 of 4
  1. #1
    Astron2012 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    54

    Copy data from one record to others in same table?


    Hi, I have database containing mailing jobs we do. There are occassions where there are multiple records that correspond to one big job. Staff sometimes need to be able to 'copy down' data from one record to others. In excel it is easy to do this via copy and paste, but in access it is not so easy.

    What I have so far is a continuous form where the user first selects the jobs that correspond with each other by ticking a checkbox.

    This then opens another continuous form that has a datasource with a query based on the ticked checkboxes so they only have the jobs they want to update in front of them.

    Some of the fields will be the same for all of those jobs so I need a way they can enter the information in the top row and then either automatically or by clicking a button will copy that information to all the other records. So far I can only find a way of copying information within the same record, not from one record to another.

    Any ideas on how to do this?

    Thanks

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    How do you identify individual records? Do you a jpg of your tables and relationships?

  3. #3
    Astron2012 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    54
    I just have one main table and a record for each job. But some jobs (records) are all linked together, not physically in the database. So once these jobs are selected from the main table in a query I want to update some fields in all of those records to match. To avoid repeated data entry for say 20 jobs at a time.

  4. #4
    Astron2012 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2012
    Posts
    54
    Its OK, I have found a solution!

    I created unbound text boxes in the forms header and ran an update query to update the fields with the data in the text boxes. I run the query after each update.

    Cheers

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Copy record from one table to another
    By jpkeller55 in forum Access
    Replies: 8
    Last Post: 03-05-2013, 12:16 AM
  2. Copy-paste every other record into bew table
    By BorisGomel in forum Access
    Replies: 5
    Last Post: 02-09-2012, 03:52 PM
  3. Replies: 1
    Last Post: 07-25-2011, 09:41 AM
  4. Copy old record data to new record
    By Aussie58 in forum Access
    Replies: 12
    Last Post: 07-20-2011, 02:30 PM
  5. Copy record to different table
    By Patience in forum Access
    Replies: 27
    Last Post: 06-03-2010, 12:19 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums