S
Sierras
Hi,
I'm trying to do a timesheet database. It will show the hours worked
from week to week. The database is working fine as the user just pick
the employee, the date, and the hours worked. But this involves a lot
of data entry since it has to be done for each employee. Also, the
employee days of the week and times are almost always the same from
week to week. In Excell, the user would just make a copy of the
previous week spreadsheet and modify the few records that need
mending. But I can't find a way to do this in Access.
Is there a way to basically click a command button that will duplicate
all the hours from the previous week for all the employees and append
them into the hours worked table for the current week (or selected
week) and then present them in a form for editing?
I'm trying to do a timesheet database. It will show the hours worked
from week to week. The database is working fine as the user just pick
the employee, the date, and the hours worked. But this involves a lot
of data entry since it has to be done for each employee. Also, the
employee days of the week and times are almost always the same from
week to week. In Excell, the user would just make a copy of the
previous week spreadsheet and modify the few records that need
mending. But I can't find a way to do this in Access.
Is there a way to basically click a command button that will duplicate
all the hours from the previous week for all the employees and append
them into the hours worked table for the current week (or selected
week) and then present them in a form for editing?