Validation Rules - Microsoft Access 2000

[Mathew Hill]

I am a beginner to the more technical aspects of Microsoft Access
(2000) and was wondering if any one can help?

I have a field in a table called: ADMIN NUMBER

This field should have 4 characters and ONLY NUMBERS should be inputted.

Does anyone know what the validation rule should be for this field?

Also I have a field called COMPANY ID

This field should have 2 characters and ONLY LETTERS should be inputted

Does anyone know what the validation rule should be for this field?

Finally I have a field called POSITION ID

This field should have 3 letters and 2 LETTERS and 1 NUMBER should be inputted.

Does anyone know what the validation rule should be for this field?

Any help regarding this would be VERY MUCH appreciated.

Thanks in advance

Mathew Hill

[Salad]

Mathew Hill wrote:

See the Input Mask help topic in Help

I have a field in a table called: ADMIN NUMBER
This field should have 4 characters and ONLY NUMBERS should be inputted. Enter
0000
4 digits required
Also I have a field called COMPANY ID
This field should have 2 characters and ONLY LETTERS should be inputted LL
required 2 characters (A-Z) forced upper case
Finally I have a field called POSITION ID
This field should have 3 letters and 2 LETTERS and 1 NUMBER should be inputted. LL0

required 3 characters, 2 (A-Z) forced upper case and 1 number

[Peter Russell]

Mathew Hill previously wrote:

I am a beginner to the more technical aspects of Microsoft Access
(2000) and was wondering if any one can help?
I have a field in a table called: ADMIN NUMBER
This field should have 4 characters and ONLY NUMBERS should be inputted.
Does anyone know what the validation rule should be for this field?
Are there always 4 digits? Do you have leading zeros for numbers like 27,
167 etc?
Also I have a field called COMPANY ID
This field should have 2 characters and ONLY LETTERS should be inputted
Does anyone know what the validation rule should be for this field?
Use the input mask property for the field.
LL
will force entry between A to Z and requires two letters to be input.
Finally I have a field called POSITION ID
This field should have 3 letters and 2 LETTERS and 1 NUMBER should be
inputted.
Does anyone know what the validation rule should be for this field?

An input mask is appropriate again.
LL0
(that is a zero after the two L's)

will require two letters followed by a number.

I'm not a fan of input masks but these are so small that they should be
ok.

Peter Russell

[Mathew Hill]

ru***@127.0.0.1 (Peter Russell) wrote in message news:<me***********************@russellscott.btint ernet.com>...

Mathew Hill previously wrote:

I am a beginner to the more technical aspects of Microsoft Access
(2000) and was wondering if any one can help?
I have a field in a table called: ADMIN NUMBER
This field should have 4 characters and ONLY NUMBERS should be inputted.
Does anyone know what the validation rule should be for this field?

Are there always 4 digits? Do you have leading zeros for numbers like 27,
167 etc?

Also I have a field called COMPANY ID
This field should have 2 characters and ONLY LETTERS should be inputted
Does anyone know what the validation rule should be for this field?

Use the input mask property for the field.
LL
will force entry between A to Z and requires two letters to be input.

Finally I have a field called POSITION ID
This field should have 3 letters and 2 LETTERS and 1 NUMBER should be
inputted.
Does anyone know what the validation rule should be for this field?

An input mask is appropriate again.
LL0
(that is a zero after the two L's)

will require two letters followed by a number.

I'm not a fan of input masks but these are so small that they should be
ok.

Peter Russell

Hi

Thanks very much for your help. Thing is though I have to prove that
validation is working for my testing documentation. I need the
validation text to come up when unsensible data is inputted and then
do a screen grab of this to put in my testing documentation to prove
that the validation is working.

Any ideas?

Matt

[Peter Russell]

Mathew Hill previously wrote:

Thanks very much for your help. Thing is though I have to prove that
validation is working for my testing documentation. I need the
validation text to come up when unsensible data is inputted and then
do a screen grab of this to put in my testing documentation to prove
that the validation is working.

All I do is use Alt+PrintScreen to capture the screen image and then drop
it into Paint and crop it there.

Peter Russell

[Salad]

Peter Russell wrote:

Mathew Hill previously wrote:

Thanks very much for your help. Thing is though I have to prove that
validation is working for my testing documentation. I need the
validation text to come up when unsensible data is inputted and then
do a screen grab of this to put in my testing documentation to prove
that the validation is working.

All I do is use Alt+PrintScreen to capture the screen image and then drop
it into Paint and crop it there.

Peter Russell

I use a freeware program called Irfanview (http://www.irfanview.com)
that is excellent for screen captures and sprucing up photos and images.
It handles just about every type of image out there in the digital world.

I like the About screen. It says "This copy of Irfanview is registered
to YOU"