(More time problems) Time buffer between appointments IF.....

[load3d]

I have an appointments form. The form collects the type of vehicle that is coming in for maintenance. The vehicles are identified by their tags. On the form the tag# is entered in and the time then the appointment shows up on the clerks screen. While 5 different people can be entering appointments at a time.

The problem I am having is that there is 1 certain type of vehicle that takes longer to get maintenance on then the rest of them, 95% of them take exactly 5 minutes. For the field minutes I'm allowing the users a drop down menu that they can choose between 5 minute increments. However, for this type of vehicle I want a 20 minute buffer (See Example). I just want to block out 20 minutes of time after this vehicle is scheduled. Any ideas?

Appointments:

Vehicle#: XYZ-123 Time: 12:05 PM (20 minute vehicle)
Vehicle#: ABC-123 Time: 12:10 PM then msgbox

 

[TheAceMan1]

How are ya Mbarbine . . .

[blue] . . . The problem I am having is that there is [purple]1 certain type of vehicle[/purple] . . .[/blue]

You forgot to tell us how you identify this special vehicle? . . . surely its not by [blue]Vehicle#[/blue] !

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[SkipVought]

Hi,

Is there a schedule of when each vehicle is DUE for maintenance?

I don't know why a clerk has to enter a vehicle number, it seems as if it ought to be from among the vehicles in need of maintenance, and that is a relatively small list. They could be picked from a combobox, could they not?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[load3d]

We identify the vehicles using the vehicle#. There are 150 vehicles and each vehicle gets maintenanced performed at least twice per day since we are a 24 hour operation. (Battery changes, water refills, etc.)

The vehicle number is the only identifier available and each one is unique.

The times when the vehicles need maintenance is random and cannot be on a set schedule.

 

[SkipVought]

I understand.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[ProgramError]

You say you have a drop down list of vehicles, are thes in a table?. Why not add another field for maintenance time and use this to fill in the time slots.


Ian Mayor (UK)
Program Error
If people say I have bad breath, then why do they continue to ask me questions and expect me to answer them?