I have a database that tracks the usage of a number of different physical resources in our company. I would like to try to create some sort of graphical display that shows what resources are in use at any given point during the day; basically I am looking for a timeline for each resource that highlights the time the resource starts to be used to the time when it's finished.
I tried to cheat and use the Chart Wizard, but it's not able to do exactly what I would like. I have thought about trying to write some code to look at a recordset and draw boxes over a premade timeline on form, but I can't figure out how to get VBA to draw a new box. If I could figure that out, I could come up with a way to have VBA draw a box on a form marking when the resource is in use.
Anyone have any ideas? Better yet, is there an easier way I can do this?
[This message has been edited by jstutz (edited 02-10-2000).]
I tried to cheat and use the Chart Wizard, but it's not able to do exactly what I would like. I have thought about trying to write some code to look at a recordset and draw boxes over a premade timeline on form, but I can't figure out how to get VBA to draw a new box. If I could figure that out, I could come up with a way to have VBA draw a box on a form marking when the resource is in use.
Anyone have any ideas? Better yet, is there an easier way I can do this?
[This message has been edited by jstutz (edited 02-10-2000).]
