How do you put a validation rule for ID numbers in Access?

B

Bonza

Require to validate all Identity Nos of my clients when capturing data. When
you enter the invalid ID no, it must report error.I have the validation code
from Department of Home Affairs to identify false ID nos. How do I put this
code in the system and in what fields/tables/forms must I put it in order for
it to work properly.Must also be able to identify a duplication of ID Nos,
whether Member or Spouse and quote the member no where it exists. Please
help!!!
 
K

KARL DEWEY

in what fields/tables/forms must I put it in order for it to work properly.
Without knowing your table structure it is a little difficult to say where
to put it.

What does a valid ID look like? Do you have a complete list in advance?
How will you be using the ID's? Just to build a list of people?

A few more details please.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top