Results 1 to 4 of 4
  1. #1
    Tommo is offline Advanced Beginner
    Windows 8 Access 2013
    Join Date
    Sep 2015
    Posts
    42

    Copy data in table

    Hi,

    I am building a dance schools database.

    When a new term is started I want the database to ask what classes are carried over from the last term. I then want to copy these in to the classes table with the new term FK assigned to them. Is this possible??

    I tried using a multiple items form but couldn't get my head around it. Any help please?

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    unlike excel; copying/pasting multiple rows in tables is not quite as do-able in a database in general. One of the reasons is the key field which must be unique and is often contained in the row - and the system won't let you paste in a duplicate value.

    set up a query that results in the records you want to duplicate (without any key field) - save it as 'DupesQ'. Then set up a new query that is an append query - begin by putting DupesQ as the source in the upper half of the query design. ...and then continue with the append query feature set ....

  4. #4
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Why copy the data? When classes are carried over, where are you getting them from, another class table? Are you then putting them in another classes table? If so, it sounds like a lot of duplication of information, which is not good normalization technique. I think your classes table should have a field that makes sense to you (perhaps Status) that you can use to carry over whatever remains from last year. When you are editing class info on your classes handling form, you set the status as well as any other pertinent info.

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

Similar Threads

  1. Import(copy) data from another table
    By tazzzz in forum Import/Export Data
    Replies: 16
    Last Post: 09-17-2015, 11:55 AM
  2. How to copy data within the same table?
    By price12 in forum Access
    Replies: 1
    Last Post: 04-23-2014, 08:34 PM
  3. Replies: 6
    Last Post: 05-23-2013, 08:14 AM
  4. Replies: 3
    Last Post: 03-05-2013, 05:14 AM
  5. copy data from one table to another
    By Sureshbabu in forum Access
    Replies: 1
    Last Post: 01-08-2012, 01:27 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