MJBag7UF

Avoiding+clashing+appointments+Access%0AEmployee%28Id%2Cname+etc%29%0AAppointment%28Id%2Cdate%2Ctime%2Cemployee+id%2C+clientid+etc%29%0AClient%28Id%2Cname+etc%29%0A%09%0ATimeslots%3A%0AEmployeeID+%29+Primary+key%0ATimeSlot+++%29+%0AJobID++++++-+Foreign+key%0AStatus+++++%29+And+so+forth%0ANotes++++++%29%0A%09%0ASELECT+TimeSlots.EmployeeID%2C+TimeSlots.TimeSlot%2C+TimeSlots.JobID%0AFROM+TimeSlots%0AWHERE+TimeSlots.EmployeeID%3D1%0AAND+TimeSlots.TimeSlot+Between+%232%2F9%2F2012+9%3A0%3A0%23+And+%232%2F9%2F2012+11%3A30%3A0%23%0A%09%0ASELECT+TimeSlots.EmployeeID%2C+TimeSlots.TimeSlot%2C+TimeSlots.JobID%0AFROM+TimeSlots%0AWHERE+TimeSlots.TimeSlot+Between+%232%2F9%2F2012+9%3A0%3A0%23+And+%232%2F9%2F2012+9%3A30%3A0%23%0A%09%0ARequestStartDate+%3D+StartDate%0A%09%0ARequestStartTime+%3D+StartTime+%0AAnd%0ARequestDate+%3D+BookingDate%0A%09%0Adim+strWhere+++++++++++++++++as+string+%0Adim+dtRequeestStartDate++++++as+date+%0Adim+dtRequestEndDate+++++++++as+date+%0A%0AdtRequestStartDate+%3D+inputbox%28%22Enter+start+Date%22%29+%0AdtRequestEndDate+%3D+inputbox%28%22Enter+end+date%22%29+%0A%0AstrWhere%3D%22%23%22+%26+format%28dtRequestStartDate%2C%22mm%2Fdd%2Fyyyy%22%29+%26+%22%23+%3D+StartDate%22+%0A%0A%0Aif+dcount%28%22%2A%22%2C%22tableBooking%22%2CstrWhere%29+%3E+0+then+%0A++++msgbox+%22sorry%2C+you+cant+book+%0A...bla+bla+bla....