I have a form which if a time to start a program is typed in (the programs has a table that tells the length of the programs) it automatically calculates the end time and the next row has the new time to start. Well, here's the problem if a time is entered that overlaps with the new time I don't know how to tell the program to find that problem and notify the user. Here is an example:
Date Start Time Length End Time Prog Title
01/05 1:00:00 15:00 1:15:00 xxxxxx
01/05 1:15:00 15:00 1:30:00 XXXXXX
01/05 1:30:00 15:00 1:45:00 xtstls
01/05 1:35:00 15:00 1:50:00 tslkto
It does not notice that 1:35 overlaps with the 1:45 program because it is programmed to automatically put the end time of the last program as the start time for the next program. So the manual entry could be an overwrite and the program will not notice it.
Can anyone help me with a suggestion.
MissC
Date Start Time Length End Time Prog Title
01/05 1:00:00 15:00 1:15:00 xxxxxx
01/05 1:15:00 15:00 1:30:00 XXXXXX
01/05 1:30:00 15:00 1:45:00 xtstls
01/05 1:35:00 15:00 1:50:00 tslkto
It does not notice that 1:35 overlaps with the 1:45 program because it is programmed to automatically put the end time of the last program as the start time for the next program. So the manual entry could be an overwrite and the program will not notice it.
Can anyone help me with a suggestion.
MissC