Time Card data entry Form

[Parker]

I need help creating a form for entering employee time
cards. I have three linked tables - TimeCards, Employees,
and ProductionCode. I would like to be able to have a
Form that looks like a standard time card that populates
the TimeCard table. There are multiple entries for each
employee for each day and I would like to have the user
enter Employee and Date once for each 'set' of TimeCard
entries. Can anyone help get me started with some basic
info, or are there any standard Time Card Templates
available online?

Thanks in advance,

Parker

 

[SteveS]

Parker,

In Ac2K, there is a Time & Billing dB example that has
time card forms. Maybe it will help you get started.

If not, post back here with a little more info:

- which version of Access?
- table structures?
- relationships?
- daily (single day) tc with multiple projects?
- weekly (7 days) with multiple projects?
- how are your coding skills?

Steve

 

[Parker]

I've got Access 2000 and I looked at the Time & Billing
example, but it was more complex than I need. Here's what
I have:
Time Card Detail Table
Fields - DetailID (AutoNum), EmployeeID, DateWorked,
RunNo, ProdCode, StartTime, EndTime, Duration.
Emlpoyee Table (Linked on EmployeeID)
Fields - EmployeeID, FirstName, LastName, Dept
Production Code Table (Linked on ProdCode)
Fields - ProdCode, ProdDesc
The Time Cards are daily with multiple entries (Many
RunNo's, different Start & End Times).

I want to make a Form in which the data entry person
enters / selects the EmployeeID and DateWorked one time
and then enters all appropriate detail creating multiple
entries into the Time Card Table. I was thinking a cmd
button to enter / select a new EmployeeID and/or
DateWorked. Also, I need to have the Duration a formula
(EndTime - StartTime).
I thought a lookup of employee name (for verification)
would be nice, but not necessary. Also, the StartTime
could be pulled from the previous EndTime, but again, not
necessary. The Production Code Table will be used for
Reports and does not need to be incorporated into this
Form.

The closest I've come with this is with a Form based on a
Query that prompts for EmployeeID and DateWorked. This
seemed to work well for a lookup, but not data entry.
I've been putting fields (EmployeeID and DateWorked) into
the header of the Form and the other info in the body, but
this obviously doesn't work.

This is my first attempt at Access, I've used VB in Excel
quite a bit. I realize that all of this is probably very
basic to someone who works with Access, but it's been
quite frustrating for me so any help is greatly
appreciated.

Thanks again in advance!

Parker

 

[SteveS]

Parker,

Had an unexpected trip... Seems like I'm burning the candle
at all three ends...

I put together a db using your table info. I guessed at
some of the data types.

E-mail me and I'll send you the example I made. Or send me
what you have (zipped) and I'll add the form I made.

You could use a form - subform arrangement or just a form
with an unbound combo in the form header and the fields
from the Time Card Detail table in the detail section. Code
in the beforeupdate event of the detail form would enter
the employee ID into the EmployeeID field. The afterupdate
event in the unbound combo box would take care of finding
the employeeID.

Steve