Results 1 to 2 of 2
  1. #1
    j1976er is offline Novice
    Windows 7 32bit Access 2010 64bit
    Join Date
    Jun 2015
    Posts
    1

    Updating multiple fields automatically

    I have a training database with multiple training codes. I would like to be able to update the training date for multiple codes. These trainings are normally completed at the same time and I want to be able to reduce data entry by auto updating the date of training for the employees for multiple codes automatically. How can I link certain codes together?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,527
    Make a tPick table (or as you like it), then you can select items from a list to put in the table. Link it to your data table.
    Use an update query to set the dates to your table using only those in the tPick. The link does it.
    (or just type them in rather than the pick form below)
    see photo...
    Click image for larger version. 

Name:	pick3NY-lbls.jpg 
Views:	9 
Size:	162.6 KB 
ID:	20924

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

Similar Threads

  1. Navigation Pane not automatically updating
    By thebigthing313 in forum Access
    Replies: 4
    Last Post: 02-05-2014, 09:04 AM
  2. Replies: 3
    Last Post: 11-12-2012, 10:44 AM
  3. Automatically updating dates
    By cinciphantom in forum Programming
    Replies: 0
    Last Post: 02-15-2011, 04:33 PM
  4. Updating Table Data Automatically
    By aquarius in forum Import/Export Data
    Replies: 6
    Last Post: 09-16-2010, 03:07 PM
  5. Automatically updating matrix
    By reuip in forum Access
    Replies: 2
    Last Post: 06-08-2010, 08:04 AM

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