I have a Schedule table with the following fields:
Date (LongDate)
AgentID (Number)
ShiftStartTime (ShortTime)
ShiftEndTime (ShortTime)
I would like to represent this information graphically with horizontal bars on either or both a report and form
For instance:
..............................|8am ...................... |12pm....................... ......|4pm................................ |8
Agent 1: 8:30-5:30....... [|||||||||||||||||||||||||||||||||||||||||||||||||| ||||||||||||||||]
Agent 2: 12-4 ........................................ [|||||||||||||||||||||||||||||]
Agent 3: 10-6 ....................... [|||||||||||||||||||||||||||||||||||||||||||||||||| ||||||||||||||]
etc...
Is there some way I can do this using VBA? Maybe formatting a txtbox size and coloring through VBA code based on a Datediff value?
Or maybe an easier way?
I am relatively new to VBA but understand programming concepts. Any assistance or example of simple code would be greatly appreciated.
Thanks