MsgBox Day

[Mr2006]

Hello All,

We have several scheduler in the office who schedule for different people work orders. I want a msgbox to appear if one scheduler try to schedule same employee for different work order that falls between or on the same two dates. (startdate and enddate). It is Ok to schedule, but we need a msgbox letting them know that this provider is already scheduled to do work between those days, do you want to overbook? yes/No. If yes, schedule, if no delete.

I need a msgbox to pop if a work order is being created for employee who have a work order between two dates.

Thanks

 

[JBinQLD]

Mate, No offense but I think you may need to check out the tutorials a little more. I'm always happy to help but you know

If TestDate >= Me!startdate And testdate <= Me!enddate Then
    MsgBox ("Overlap")
    'delete or whatever
else
    'no drama, do nothin
Endif

That checks your dates - search help for help on checking for confirmation (if msgbox(blah)=vbyes then....) and for deleting record if vbNo

Sure you'll get it from here,

JB

 

[Mr2006]

Thank you so much for your help. I will try to take it from here