DATE FIELD PROBLEM

[Andy S Main]

Hi to anyone who can help!

I am building a database for a private recruitment company
and they want to know when their staff are available for
work and when they are not. I need to create a table that
will allow the end user to view a month's calendar as a
table and also to creat a new table for a new month
without having to go into the database design. Is there a
way that ACCESS and/or EXCEL 2002 can do this?

Thanks a lot...

 

[Tim Ferguson]

Hi to anyone who can help!

I am building a database for a private recruitment company
and they want to know when their staff are available for
work and when they are not. I need to create a table that
will allow the end user to view a month's calendar as a
table and also to creat a new table for a new month
without having to go into the database design. Is there a
way that ACCESS and/or EXCEL 2002 can do this?

1) Use Outlook? -- it's what it is for. Alternatives like Act! or (there's
a Lotus one too isn't there) etc. There are quite a few freeware or
shareware scheduling/ calendaring applications about so check Winfiles.com
might help. There are also some web sites that will do this (Lycos comes to
mind, I think) and that has the advantage of being accessible from lots of
different locations at once.

2) If you are determined to re-invent the wheel, the simplest approach
would be to use a few lines of VBA code in Excel to draw up a calendar
automatically -- say one month per worksheet -- and then fill in people's
names as required.

3) You can create a complex application in Access with a table for the
people, a table for their dates-away, another table for statutory holidays
and so forth; you might want to look at some custom ActiveX controls to
display them; using real VBA gives you the opportunity to create arrays of
controls at runtime (which Access doesn't) and that might help too.

The best answer depends on exactly what the needs are for this application.

Hope that helps


Tim F

 

[Duane Hookom]

You might want to check the calendar reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4.