I have a database that I am using as a Time clock where employees can
clock in and out. Is there a way to make it so that when they clock
out a form would open displaying their work day hour by hour with combo
boxes next to each hour that they could select what task they did for
the coorisponding hour. For example: lets say the clock in field says
"7/5/2006 11:00:00 AM" and the clock out field is "7/5/2006 8:00:00
PM." Once they clock out a form opens that would look something like:
Employee Name
7/5/2006
11:00AM Combo box with list of possible tasks
12:00PM Combo box with list of possible tasks
1:00PM Combo box with list of possible tasks
2:00PM Combo box with list of possible tasks
.........................etc.
.........................etc.
8:00PM Combo box with list of possible tasks
I can build the form ok but I am unsure how to have this form populate
with combo boxes for only the hours worked or for multiple hours
period. Is this even possible?
Any insights or comments would be greatly appreciated.
Thanks