Results 1 to 6 of 6

Thread: Update All Tables With Newly Added Data

  1. #1
    Junior Member
    Join Date
    Jun 2013
    Posts
    3
    Rep Power
    0

    Update All Tables With Newly Added Data

    i am using Access 2010 and i have 3 tables, studentinfo, testscores and attendance.

    what i would like is for when i enter the student information into the studentinto table that it copies over lastname, firstname, dateenrolled, studentid and grade into the testscores table and lastname, firstname, dateenrolled into the attendance table.

    i enter the information in using the datasheet view.

    i have read to use the table tab, after the table is open however the options for after events are greyed out and i am not able to use them.

    please advise how i would be able to accomplish this task

    thank you

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    hi Redja71. Can be done. But to provide you with an optimal (or close) solution, please share the trimmed down version of your Access file.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Jun 2013
    Posts
    3
    Rep Power
    0

    after insert

    i have attached a compressed file with the tables that you will need, attendance, studentinfo and testscores.

    thank you
    Attached Files Attached Files

  4. #4
    Junior Member
    Join Date
    Jun 2013
    Posts
    3
    Rep Power
    0
    good morning

    just wondering if you had come up with a solution to my after insert question.

    thank you

  5. #5
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,401
    Rep Power
    10
    redja71, referential integrity has to be maintained. So using that feature is advised. Having said that, what you've asked for has to be done with the help of VBA.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  6. #6
    Senior Member alansidman's Avatar
    Join Date
    Apr 2012
    Posts
    125
    Rep Power
    12
    you should be using a form to enter your data and should not be entering data directly into tables. This can be easily accomplished by setting up a relationship between the tables and then creating sub forms to your main input form. This will automatically update all the tables concurrently.

Similar Threads

  1. Replies: 8
    Last Post: 06-08-2013, 01:24 PM
  2. Replies: 2
    Last Post: 05-30-2013, 07:28 PM
  3. VBA Code to create Pivot tables
    By Howardc in forum Excel Help
    Replies: 2
    Last Post: 08-05-2012, 02:41 AM
  4. Reading Access tables using INNER JOIN
    By Rasm in forum Excel Help
    Replies: 2
    Last Post: 02-04-2012, 09:17 PM
  5. Update data from closed workbook with sumif formula
    By leopaulc in forum Excel Help
    Replies: 4
    Last Post: 11-02-2011, 02:58 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •