Calendar for Schedling Staffing

M

Mad Medic

I am having a heck of a time trying to make a simple database that will
build and then store work schedules for about 20 people.
I just want a form with names in the right column. The top row has the
specific days of the month and the fields show who is working that shift. I
have done it for years in Excel (so that data entry format would be great),
but I want to tie the names to a database with their personal data,
"holidays owed", etc. And I want to be able to go back and look at any past
month (preferably with a combo box).
Sounds simple, but I am stumped.

Anyone got any ideas?
TIA!
Nick
 
M

Mad Medic

Thanks! I would like to automatically create date tables (i.e. a field with
the month name and fields with the days of the month) But I can't figure
out how to make an automatic table with 31 fields for January, 28 Fields for
February, etc automatically.....
 
M

Mike Painter

Mad said:
Thanks! I would like to automatically create date tables (i.e. a
field with the month name and fields with the days of the month) But
I can't figure out how to make an automatic table with 31 fields for
January, 28 Fields for February, etc automatically.....
Click to expand...

Using a table with 31 date fields on it violates relational database rules
and will cause lots of problems, solved only by more code.
It has to be done programmatically to display properly and involves a
continuous form with 33 or so fields that hides unused fields in the month.
It can also be made to color code and make smaller week ends and color code
holidays.

I've done that kind of thing using a flat file to display the calendar and
relating each date field in code to a properly designed table.

It was not a cheap solution, but that's what they insisted on.

There are tons of scheduling programs out there.
 
M

Mad Medic

Does anyone have any examples that I could use?


Mike Painter said:
Using a table with 31 date fields on it violates relational database rules
and will cause lots of problems, solved only by more code.
It has to be done programmatically to display properly and involves a
continuous form with 33 or so fields that hides unused fields in the
month. It can also be made to color code and make smaller week ends and
color code holidays.

I've done that kind of thing using a flat file to display the calendar and
relating each date field in code to a properly designed table.

It was not a cheap solution, but that's what they insisted on.

There are tons of scheduling programs out there.
Click to expand...
 
Top