I'm trying to create a form that will give an error if an appointment is made for a person on the same date and same time as another appointment. I have three factors involved: it checks to see which provider is being assigned the appointment, checks other dates within the field for this provider, and checks the times. I'm close to figuring it out but I keep catching other errors with my solutions.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating a time and date field in an appointment table/form
- Thread starter Terrell
- Start date
- Status