Microsoft Access Free Consultant Tips 1

Programming with Microsoft Access can be easy, if you know what you are doing.  This site is dedicated to provide free Microsoft Access consultant tips. 

There are plenty of professional programs that allow for 2 key verification.  Which means you enter data twice and then the program verifies that the two data field match.  Microsoft Access Database is not set (pre-formatted) to do this feature, but the below instruction will show you how you can achieve the same goal.

I first create two tables with the same field name.  Table 1 - DD1, Table 2 - DD2.  Please view the example below:

Table DD1

Field Name, Data Type

KeyID, autonumber

F1, text

F2, text

Table DD2

Field Name, Data Type

KeyID, Number

F1, Text

F2, Text

Use the Relationship feature and connect the KeyID from table DD1 to KeyID from table DD2.

Now you can create two forms.  I'm using the same name as the tables listed above, DD1 and DD2.

Form DD1 doesn't need to be changed at all.  However, to achieve the 2 key verification form DD2 has some modifications.

Before modifying form DD2 you will need to create a macro for each field you will like the 2 key verification to apply to.  Using the F1 field as an example, create a macro with the following:

Condition, Action

[Forms]![DD1]![F1]<>[Forms]![DD2]![F1], msgbox.

The above condition and action said, "if DD1 field F1 and DD2 field F1 doesn't match bring up a msgbox.  In the message box I wrote "Fields Don't Match" and turned on the Beep.

Now, go back to the form DD2.  In the properties screen of the F1 field go to "On Lost Focus" and select the macro you have just created.  You will also need to open the DD1 form when keying (data entry) for this process to work.

I created a macro to open the DD1 form when I open the DD2 form.

Stay tuned for more Microsoft Access Free Consultant Tips.  If you have a question you can visit YSDATA.com and send an email.