design a calendar if someone is not available it blacks field

[miamoe]

I am trying to design a calendar where if someone is not available it blacks
that date and time.

Please help

 

[Duane Hookom]

"Please help" with what? Do you have a specific question regarding
tablesdbdesign? Or, do you have tables and fields to share and need form or
report assistance?

 

[miamoe]

I need help figuring out how to do this. I am assuming it can be done. In a
table, form, macro, I have no idea. Thanks,

 

[mscertified]

You will definitely need a table or tables to save the availability data.
You will also definitely need a form for updating the data.
More than that its difficult to say unless you explain EXACTLY what you want.
Do you want to see the availability for one person or many on the same
calendar.
How long must the calendar span be? A week, a month?

Dorian

 

[miamoe]

OK I already have a calendar by day for everyone all on one calendar. And a
form to update the data. And then another form that filters by agent. Hope
that helps.

 

[mscertified]

Well it depends on what you mean by 'calendar'. To be able to 'black out'
dates you will need to be able to refer to each indivdual day and change the
background color of that day. Most of the freely available calendars probably
will not allow you to do that. So you would need to create your own calendar
which allows you to do that.
You will need a table something like:
PersonID
Date
Available YES/NO

Dorian.

 

[mnature]

What software are you using? Are you using Microsoft Access?