Microsoft® Access® 2010 Inside Out

Validating Complex Data

Although you can certainly take advantage of the Input Mask property and the field and table Validation Rule properties, your application often has additional business rules that you can enforce only by adding code behind the forms you provide to edit the data or by using data macros at the data level. The following examples show you how several of the business rules in the Conrad Systems Contacts and Housing Reservations applications are enforced with Visual Basic code.

Checking for Possible Duplicate Names

When you design a table, you should attempt toone identify some combination of fields that will be unique across all records to use as your primary key. However, when you create a table to store information about people, ...