Validation Rules - Microsoft Access 2000

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

re: Validation Rules - Microsoft Access 2000

Mathew Hill wrote:

See the Input Mask help topic in Help[color=blue]
> I have a field in a table called: ADMIN NUMBER
> This field should have 4 characters and ONLY NUMBERS should be inputted.[/color]
Enter
0000
4 digits required
[color=blue]
> Also I have a field called COMPANY ID
> This field should have 2 characters and ONLY LETTERS should be inputted[/color]
[color=blue]
>LL[/color]

required 2 characters (A-Z) forced upper case
[color=blue]
> Finally I have a field called POSITION ID
> This field should have 3 letters and 2 LETTERS and 1 NUMBER should be inputted.[/color]
[color=blue]
>LL0[/color]

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

re: Validation Rules - Microsoft Access 2000

Mathew Hill previously wrote:
[color=blue]
> 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?[/color]

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


[color=blue]
> 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?[/color]

Use the input mask property for the field.
LL
will force entry between A to Z and requires two letters to be input.
[color=blue]
> 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?[/color]

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

re: Validation Rules - Microsoft Access 2000

rusty@127.0.0.1 (Peter Russell) wrote in message news:<memo.20040419171217.1656C@russellscott.btint ernet.com>...[color=blue]
> Mathew Hill previously wrote:
>[color=green]
> > 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?[/color]
>
> Are there always 4 digits? Do you have leading zeros for numbers like 27,
> 167 etc?
>
>
>[color=green]
> > 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?[/color]
>
> Use the input mask property for the field.
> LL
> will force entry between A to Z and requires two letters to be input.
>[color=green]
> > 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?[/color]
>
> 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[/color]

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

re: Validation Rules - Microsoft Access 2000

Mathew Hill previously wrote:
[color=blue]
> 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.[/color]


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

Peter Russell

re: Validation Rules - Microsoft Access 2000

Peter Russell wrote:
[color=blue]
> Mathew Hill previously wrote:
>
>[color=green]
>>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.[/color]
>
>
>
> All I do is use Alt+PrintScreen to capture the screen image and then drop
> it into Paint and crop it there.
>
> Peter Russell[/color]

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"