General discussion


VBA Coding in Access

By gerard_moreland ·
In a form I would like to be able to enter a piece of code into the form that will give a message to the user if the same data is entered i.e. I have developed a system that books rooms, if the room is booked for the same time on the same day then a message will tell the user that the room is already booked.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by Bristar In reply to VBA Coding in Access

It sounds to me like you need a "Lost_Focus" control on the text box where the date would be entered that would first check to see if it is a valid date, then check to see if that date exists in the data table. You can either set it on the box, or in the processing of the submission button.

Related Discussions

Related Forums