BeforeUpdate & AfterUpdate in Access: Conflict Check

In this Microsoft Access tutorial I will show you how to use the BeforeUpdate and AfterUpdate events together to prevent double-booking appointments, validate user input for valid dates and times, and prompt for sending a confirmation email after an appointment is added. We will build a simple appointment form, check for date conflicts, and add useful validation to make sure appointments are entered correctly.

Bryce from Mesa, Arizona (a Platinum Member) asks: I have a form where I schedule appointments, and I only book them on the hour, like 10am or 3pm. Is there an easy way to check if I already have something scheduled at that time so I don't double-book? Also, after I enter the appointment, can Access prompt me to send a confirmation email? I keep forgetting to do that, and it would really help if the system reminded me automatically.

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA
• Before Update
• AfterUpdate
• DLookup
• NZ Function
• If Then
• MsgBox

Links

• Appointments
• Send Email with CDO
• Send Email

Recommended Courses

• Access Developer Courses

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Before Update and After Update together, appointment conflict resolution, DLookup conflict check, validate date input, confirmation email prompt, NZ function usage, VBA message box Yes No, developer-level VBA, appointment form design, hour-only scheduling, appointment validation, date and year validation, TechHelp template, continuous form setup, VBA event handling, send email with CDO, prevent double booking