Employee Time card form



I have a table containing two fields - Employee_ID and Time_Stamp.

I've already created a form that scans in Employee_IDs; and once any
Employee_ID is scanned in, the ID and scanned time is recorded to the table.
In addition to what it already does, the form needs to populate the
employee's punch time records for the current week.

For example: (current date and time is Wednesday 9:02 am)

(Form view before update)
Employee ID: ___________________

(Form view after update)
Employee ID: _1001 (Enter)_______

Employee ID: 1001
Mon: 9:00 am
Mon: 5:00 pm
Tue: 8:59 am
Tue: 5:01 pm
Wed: 9:02 am

I hope my question is clear.



Tom van Stiphout

On Tue, 1 Jun 2010 11:44:02 -0700, Keith

I would use a subform for that. When the ID is scanned in, you can
requery the subform and it would show the data for this employee. Use
the subform's LinkMasterFields and LinkChildFields properties to
restrict the subform to the current employee.

Microsoft Access MVP


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question