Hello,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
> </o>
I am very new to access, with moderate experience with VBA in excel. In Access I am trying to create an Attendance database for a group I help out with. Below is a schematic of what I am trying to create, an attached is my rough outline of the Access database.
<o> </o>
Workflow:
<o> </o>
1.) User opens DB, which opens formAttendance.
2.) A calendar is in the right corner and today's date is automatically selected.
3.) The user uses the combobox Team (cmbTeam) to filter the members in the bottom left datasheet (MembersSubform).
Notes: MembersSubform is cannot be edited or amended on this screen, it is only for reference.
4.) When the user finds the desired member who is absent they put a code letter in the same row of the parallel datasheet (formIncidents).
Notes1: formIncidents has 3 hidden columns AttendanceIncident - the unique occurrence of the incident, MemberID, the Member ID pulled from the corresponding row of the member in MembersSubform, and AttendanceDate, which is the date from the calendar.
<o> </o>
Notes2: Currently the formIncidents datasheet only shows one line but I am hoping to have it show 1 line for each individual that is present in the MembersSubform. It will also need to recall previous entries, so if I enter an abscent into formIncidents for someone from team 1, and then I go and select team 2, and then come back to team 1 it will still show the entry for that staff, which can be edited or overwritten. The same will need to be down with dates, if I were to choose a different date.
<o> </o>
<o> </o>
Where I need help now: How do I make the formIncident show the same number of rows as MembersSubform when it updates? Also how can I make those rows tied together, so when there is a change in team the same data is recalled?
Link to Database: http://db.tt/blJUV0XI
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o> </o>I am very new to access, with moderate experience with VBA in excel. In Access I am trying to create an Attendance database for a group I help out with. Below is a schematic of what I am trying to create, an attached is my rough outline of the Access database.
<o
> </o>Workflow:
<o
> </o>1.) User opens DB, which opens formAttendance.
2.) A calendar is in the right corner and today's date is automatically selected.
3.) The user uses the combobox Team (cmbTeam) to filter the members in the bottom left datasheet (MembersSubform).
Notes: MembersSubform is cannot be edited or amended on this screen, it is only for reference.
4.) When the user finds the desired member who is absent they put a code letter in the same row of the parallel datasheet (formIncidents).
Notes1: formIncidents has 3 hidden columns AttendanceIncident - the unique occurrence of the incident, MemberID, the Member ID pulled from the corresponding row of the member in MembersSubform, and AttendanceDate, which is the date from the calendar.
<o
> </o>Notes2: Currently the formIncidents datasheet only shows one line but I am hoping to have it show 1 line for each individual that is present in the MembersSubform. It will also need to recall previous entries, so if I enter an abscent into formIncidents for someone from team 1, and then I go and select team 2, and then come back to team 1 it will still show the entry for that staff, which can be edited or overwritten. The same will need to be down with dates, if I were to choose a different date.
<o
> </o><o
> </o>Where I need help now: How do I make the formIncident show the same number of rows as MembersSubform when it updates? Also how can I make those rows tied together, so when there is a change in team the same data is recalled?
Link to Database: http://db.tt/blJUV0XI
