We've had someone build us a time schedule using Access. The application looks good and how it functions is pretty remarkable.
Basically we create a schedule for "On Shift, Off Shift, Vacation" etc. Then Another part of the record is pulled from our RFID Key tags, what will fill in "Clocked In" and "Clocked Out" so you know if someone showed up for the day.
Only we ran into a slight snag near the end where we're about to roll out the application.
Our plan was to color text of users in future events so you can quickly see if your on shift, or off shift. If your on-shift, its black, off shift is red. Turns out this is not possible the way the calendar was built, we're only able to change ALL the text inside a box that represents a day of the month view, but we can't individually color in a cell. For example, if you take May 11. If your off shift, it would show Red. On shift, black. When you clock in it shows green.
Now I know basically nothing about Access, but I want to learn. This if probably super advanced for me, but can anyone tell me if it might be possible to change text of content inside a cell dependent on the status? If not, how would we have to modify the calendar so we could do so?
See attached.
Thanks!