Printing a range of dates on a timesheet

[Guest]

We are attempting to integrate our company's timesheets into Access 2002,
where we have a worker table with the names, emp numbers etc. The goal is to
be able to click a button, and the timesheets will print out with the name,
id number, department, pay period dates already on the timesheet, where the
worker would then just have to fill in the number of hours worked each day.
The timesheet requires that a "payroll begin date" and "payroll end date" be
printed on the timesheet, and below that is a row of boxes in which the
individual dates for each day of that period are entered.
We took the timesheet and scanned it into the report as the background, then
overlayed text boxes to print the name, id number, department, etc, using the
worker table as the record source for each of these fields.
We used the text box for the payroll begin and end dates, too, so that it
prompts the user to enter the beginning and ending dates of the pay period.
Is there anyway we can use an expression to get the individual dates to
print in the date boxes below, starting with the payroll begin date, and
ending with the payroll end date?

 

[Jim/Chris]

I have just completed a time reporting system similar to
the one you mentioned. Her is what I did.

Tables
Names - Emplyee Names and EmployeeId
Calendar - Each record is a date. Also I added a field for
the Time Period
TimePeriod - one field for the time period and a sort Field
Empmain - Contains EmpLoyeeId, TimeIn,LunchYimeOut,
LunchTimeIn,EndTime, and Comment. You could use just hours
instead of times.

Forms
form A - Base on the Names table. Add combo boxes for the
Time period and the emplyee.

Subform A - Continuos form - based on theEmpMain table
linked to Form A by the Employee ID and the Time period.
has all the fileds in Table Empmain.

Changing either the TimePeriod Combo box or Emplyee Id
combo box will refresh the data on the subform.

I have added calculations, Holidays in my system and also a
request for time off. I also secure what schedules people
can see by login ID

Hope this helps. Post back if you need more info.

Jim



-----Original Message-----

 

[Guest]

Thanks! I will show this to my buddy!

I have just completed a time reporting system similar to
the one you mentioned. Her is what I did.

Tables
Names - Emplyee Names and EmployeeId
Calendar - Each record is a date. Also I added a field for
the Time Period
TimePeriod - one field for the time period and a sort Field
Empmain - Contains EmpLoyeeId, TimeIn,LunchYimeOut,
LunchTimeIn,EndTime, and Comment. You could use just hours
instead of times.

Forms
form A - Base on the Names table. Add combo boxes for the
Time period and the emplyee.

Subform A - Continuos form - based on theEmpMain table
linked to Form A by the Employee ID and the Time period.
has all the fileds in Table Empmain.

Changing either the TimePeriod Combo box or Emplyee Id
combo box will refresh the data on the subform.

I have added calculations, Holidays in my system and also a
request for time off. I also secure what schedules people
can see by login ID

Hope this helps. Post back if you need more info.

Jim



-----Original Message-----