If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Check off attendees from the entire list of employees?
Hello! Here's the setup (Access 2003): tblEmployee (EmployeeIDpk, LName, FName) tblEvent (EventIDpk, Event, EventType, EventPeriodicity) tblEmployeeEvent (EmployeeIDfk, EventIDfk, EventLocation, EventStartDate, EventEndDate) Here's the scenario: Starting on EventStartDate and ending on EventEndDate at EventLocation, an Event (which is an EventType) happened for Employee (s). This event is scheduled to repeat every EventPeriodicity. So I can use this for one-time or recurring training, evaluations, dental exams, whatever. As it is on the form, you enter the dates, select the event, enter the location, and use a dropdown to select the person. This is good except for events (i.e., training classes) where you have multiple people on the same date. I would like to make this so you enter the dates, event, location, but instead, you get a list of every employee from the tblEmployee, and then use checkboxes to select whether they attended. So going down the list and checking off would be faster than going through employee-by- employee using the combo box. How do I set this up to store the date, event, event location, and the checked employeeID for checkbox method? (I get it for "one date and one check", but "one date and many checks" has me stumped. Thanks! VR/ Lost |
#2
|
|||
|
|||
Check off attendees from the entire list of employees?
Use a subform with a combobox to select event participants from your list.
There will be 1 record for each person in the subform. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Lostguy" wrote in message ... Hello! Here's the setup (Access 2003): tblEmployee (EmployeeIDpk, LName, FName) tblEvent (EventIDpk, Event, EventType, EventPeriodicity) tblEmployeeEvent (EmployeeIDfk, EventIDfk, EventLocation, EventStartDate, EventEndDate) Here's the scenario: Starting on EventStartDate and ending on EventEndDate at EventLocation, an Event (which is an EventType) happened for Employee (s). This event is scheduled to repeat every EventPeriodicity. So I can use this for one-time or recurring training, evaluations, dental exams, whatever. As it is on the form, you enter the dates, select the event, enter the location, and use a dropdown to select the person. This is good except for events (i.e., training classes) where you have multiple people on the same date. I would like to make this so you enter the dates, event, location, but instead, you get a list of every employee from the tblEmployee, and then use checkboxes to select whether they attended. So going down the list and checking off would be faster than going through employee-by- employee using the combo box. How do I set this up to store the date, event, event location, and the checked employeeID for checkbox method? (I get it for "one date and one check", but "one date and many checks" has me stumped. Thanks! VR/ Lost |
Thread Tools | |
Display Modes | |
|
|