By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,444 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Validation Rules - Microsoft Access 2000

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

P: n/a
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
Nov 12 '05 #4

P: n/a
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
Nov 12 '05 #5

P: n/a
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"
Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.