time card

  • Thread starter Thread starter me
  • Start date Start date
M

me

I am very new to Access and am trying to set up a time card for my shop. I
have a basic form set up that shows the worker and his info (address phone
etc) and then i have a sub form under that, it shows different types of
hours worked ( ex, reg hours, ot, capital, sick leave,) then i have another
sub form under that, it gives me totals for week, year to date and weekly
total for shop.

The first thing i wants to do is to be able to select the workers name thru
a drop down type box where i can select any workers name, and his info will
show on the time card below. Is it also possible to select a date range for
the worker on the same page (ex. Jan 31, 05 to Feb 6, 05) (another drop
down box)

Also when i enter values into the hours boxes, nothing update on the bottm
totals.


Please help, !!!!!!!!!!!!!!!!
 
Your easiest solution may be to use the Filter By Form option that's built
into Access. When you're in the form select "Records", "Filter" then "Filter
By Form" from the menu bar. You'll be given the option to select the
combination of employee and date that you're interested in within the form
itself. To view all records again select "Records", "Filter" then "Remove
Filter".

I don't know how you have your subform built to calculate your totals. If it
were me I'd use the form footer area of the main form to display these
calculations. The fields would have to use DLookup to obtain the numbers that
you want to see. In order to have these fields update during data entry would
require you to requery each of them on the data entry field's AfterUpdate
event.
 
Back
Top