DARRYL C
06-13-2001, 08:39 PM
I have a problem, that I cannot resist asking you for input on.
The folks at the airport asked me to build them a simple application/database in Access
that would function as an electronic booking sheet for planes, pilots, and customers.
This I have done, complete with VB code that open subforms if either planes or pilots are
double booked on a given day.
Where I am stumped is how to create a free busy graphical display based on
the start time, and end time data contained in the bookings table.
I have scoured the Access Forums, websites, ad nauseum, and am now going to attack
the problem with a series of queries setting image visible properties based on their output.
If you know of the best path to take, please advise.
Thanks
Darryl C.
The folks at the airport asked me to build them a simple application/database in Access
that would function as an electronic booking sheet for planes, pilots, and customers.
This I have done, complete with VB code that open subforms if either planes or pilots are
double booked on a given day.
Where I am stumped is how to create a free busy graphical display based on
the start time, and end time data contained in the bookings table.
I have scoured the Access Forums, websites, ad nauseum, and am now going to attack
the problem with a series of queries setting image visible properties based on their output.
If you know of the best path to take, please advise.
Thanks
Darryl C.