Results 1 to 7 of 7
  1. #1
    DBenz is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    76

    how an I copy a records field entries from an earlier dbase to the current one ?

    Hi,
    Access 2010
    I have managed to delete the data from fields in a record (but not the record) so now need to open an earlier one saved a day ago and copy across the field data to the same record number, how is this done ?

    I was using the arrow keys to move to next field and hit delete on a record I wanted to delete field entries from, but it didnt stop at the end of the record and carried on into the next without me twigging this !



    so how can one delete all field entries in a record, keeping the record number, as I have another subject for that record to type in, rather than have a gap in the ID numbers !

    DBenz

  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
    You can open a recordset on the desired record and copy those values to the form.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    DBenz is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    76
    Hi, thanks
    still wondering part 2 of my question...
    so how can one delete all field entries in a record, keeping the record number, as I have another subject for that record to type in, rather than have a gap in the ID numbers !

    DBenz

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Research an Update query.
    Keep the identfying record number and update all other relative fields.

    As Paul suggested you could use a recordset and update the fields involved.
    I recommend you back up what you have first; then work on a copy. Try some simple testing until you are certain your process is working correctly before doing this with your "good" data.

    Update queries can be quite unforgiving --so test it thoroughly before working with your "good" data.

    I'm not sure why a gap in record numbers would be important.

    Good luck.

  5. #5
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    To copy a complete table from one DB to another:
    In your current db do this to navigate to the backup DB.
    You can copy a single object or the whole ball game.
    Click image for larger version. 

Name:	copy.png 
Views:	11 
Size:	26.5 KB 
ID:	37561

  6. #6
    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
    Quote Originally Posted by davegri View Post
    To copy a complete table from one DB to another:
    In your current db do this to navigate to the backup DB.
    You can copy a single object or the whole ball game.
    Wrong thread maybe?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Wrong thread maybe?
    Just my thought that it might be easier than fiddling with a single record. Depends on what other records might have been changed.
    Edit: As a followup, once both the new and old tables are in the current DB, copying fields from specific records could be easily done.
    Last edited by davegri; 02-24-2019 at 09:48 AM. Reason: comment

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

Similar Threads

  1. Replies: 13
    Last Post: 12-20-2017, 08:35 PM
  2. Replies: 1
    Last Post: 05-14-2016, 04:38 PM
  3. Replies: 0
    Last Post: 03-03-2014, 06:56 AM
  4. Updating current Access Dbase
    By berger01 in forum Database Design
    Replies: 4
    Last Post: 06-28-2013, 01:35 PM
  5. Replies: 14
    Last Post: 03-01-2012, 02:39 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