I am setting up a simple database to capture e-mail addresses for a customer. I want the customer to enter his/her email address two separate times and compare the text data before moving to the next form to make sure the e-mail address is accurate. What is the simplest way to accomplish this?
OK, bind the second in the tab order.
Now try this
Use the BEFORE update to run
If (me.email1<>Me.email2 then
Msgbox "The email addresses you entered do no match. Please try again.",vbOKOnly+vbInformation,"mail
When developing Access applications, often we need to know whether an object exists. This article presents a quick and reliable routine to determine if an object exists without that object being opened.
If you wanted to inspect/ite…
Overview: This article:
(a) explains one principle method to cross-reference invoice items in Quickbooks®
(b) explores the reasons one might need to cross-reference invoice items
(c) provides a sample process for creating a M…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…