Timetable

  • Thread starter Thread starter John Crighton
  • Start date Start date
J

John Crighton

Hi all,

I think perhaps I won't get any replies for this, but
I'll give it a try on the offchance.

I'm trying to create a timetable type of form - I have a
table of bookings and a table of vehicles.

I need to show the days of the month, and when that
vehicle is booked out (by changing colours of text boxes).

This is fairly easy to do with only one vehicle, however
when using continuous forms and trying to display for
each vehicle, I have the problem of all the text boxes
changing colour to the vehicle that has focus's booking
dates.

I've thought about using conditional formatting, but I
guess I'd have to use some SQL in there - not
neccessarily a problem for me, but I'm not sure it's
possible, and it may be a little messy with so many
controls on a continuous subform.

Does anyone know of any useful examples or have any tips?

TIA

John Crighton
 
I did almost the same in a Report. If this will work for
you also, pls post back. Now office hours are over but
tomorrow I can answer you gadly.

tschous!
 
Back
Top