Results 1 to 4 of 4
  1. #1
    JustMargie is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Mar 2011
    Posts
    2

    Use Command Button to Select and enter single or multiple records to a table

    I have a training db that records all training employees have been enrolled in, completed & did not complete. I have a table called tblTrainingSessions which contains the course names, date of training, location etc. The primary key is the SessionID. A second table (tblSessionDetails) contains the list of employees enrolled in that course and a Yes/No for completion (used after the session ends) and a reason field if they did not attend. I have been 'enrolling' the employees one by one using their EmpID. I would like to add entire shifts or other variables of employee groupings (by JobTitle for example) and enroll that entire group - Using different forms for each grouping is fine. Ideally the form would look like this:

    Drop-Down List of Sessions - Select the session

    List Box of All Employees Command Button > or >> to move one or all employees of Enrolled Employees


    Another form might look like this:

    Drop-down list of sessions - Select the session

    List of All First Shift Employees - Command Button > or >> to move one or all employees to Enrolled Employees

    I have been able to build this form with unbound lists but have not been able to

    1. Get the session to associate with either list
    2. Get the selected employees to update to the tblSessionDetails.

    Any suggesions?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Is this what you're trying to do?

    http://www.baldyweb.com/MultiselectAppend.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    JustMargie is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Mar 2011
    Posts
    2
    Kinda. I think I can work through from your sample to get where I'm going. I'll let you know.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problem, post back if you get stuck. Welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 06-13-2013, 01:02 PM
  2. Replies: 14
    Last Post: 02-19-2013, 03:16 PM
  3. Replies: 3
    Last Post: 11-16-2011, 11:53 AM
  4. Replies: 1
    Last Post: 08-30-2011, 07:35 AM
  5. Replies: 2
    Last Post: 03-25-2010, 12:11 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