Sign in Sheets

D

DrEvil

Hi guys, I would like to create sign in sheet for each employee and then
group them by department, but I would like to autogenerate dates.
So far i have database with names and departments so no problem there but
I'm not sure how to go about dates. I would like HR person to fill out
beginning date and end date and then Access(XP in my case) would autogenerate
dates in between. I don't need to separate out Sunday and Saturday, they can
stay on sheet since some people do work on those days.
Sign in sheet would look something like this; one person per sheet, and
below name and department I would list dates(usualy 15 days). They will
distribute this by department where user when he comes to work will sign
in... that is about it.
I don't want to store dates in database... I just need them to show up and
go aways once user prints report.
Thank you in advance
 
B

Bill

If you design your report with labels layed out in a column fashion
as you would like to see the dates printed AND set their visibility
property to "NO", you can then populate their caption properties
in code with progressive dates based on a start date and loop for
the 15 or so dates you want. As each label's caption is set, you can
then make it visible. Perhaps with an adjacent label whose caption
is under-scores for a sign-in space.

The code isn't particularly difficult. Post back if you think this
approach has merit given your application.

Bill
 
D

DrEvil

Something like that would work I think, but I think the biger problem would
be coding it and doing date range... I do like your approach.. I guess the
only way to find out if would it work is to try it. I can code OK but haven't
done anything with progressive dates yet. I'll try sometime today.
 
Top