what i have: a form with a sub form with a text box that says 10/13/2016 05:00:00 am
the record source for this form is a query with po number, part name, start day, end day, batch, week, yr
a sample record is p8888, type 218, 10/11/2016 08:00:00 am, 10/13/2016 02:00:00 pm, 2, 42, 2016
what i am trying to do is highlight said text box a specific color and create a tool tip showing entire record because its time and date falls between the start and end times and because the batch number equals 2
the query should have between 0 and 25 records, and none should overlap the time period but if they do I am not sure how that should be handled
i want to run it in the main forms on load event
I have no idea where to start attempting to program this and I realize it is a bit of an odd idea to do, but it is a starting point for a project i am working on. Any help is very much appreciated.
the record source for this form is a query with po number, part name, start day, end day, batch, week, yr
a sample record is p8888, type 218, 10/11/2016 08:00:00 am, 10/13/2016 02:00:00 pm, 2, 42, 2016
what i am trying to do is highlight said text box a specific color and create a tool tip showing entire record because its time and date falls between the start and end times and because the batch number equals 2
the query should have between 0 and 25 records, and none should overlap the time period but if they do I am not sure how that should be handled
i want to run it in the main forms on load event
I have no idea where to start attempting to program this and I realize it is a bit of an odd idea to do, but it is a starting point for a project i am working on. Any help is very much appreciated.
Last edited: