473,769 Members | 5,131 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
Nov 12 '05 #1
5 7643
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
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
ru***@127.0.0.1 (Peter Russell) wrote in message news:<me******* *************** *@russellscott. btinternet.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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
3920
by: Stefan Richter | last post by:
Hi, after coding for days on stupid form validations - Like: strings (min / max length), numbers(min / max value), money(min / max value), postcodes(min / max value), telefon numbers, email adresses and so on. I thought it might be a better way to programm an automated, dynamic form validation that works for all kinds of fields, shows the necessary error messages and highlights the coresponding form fields.
67
5346
by: Scott Meyers | last post by:
I have a web site that, due to maintenance by several people, some of whom are fairly clueless about HTML and CSS, etc. (notably me), has gotten to the point where I'm pretty sure it's suffering from bit rot. Though the pages seem to display okay under IE and FF, I really think it's time for an under-the-hood cleaning. I recently received a copy of Molly Holzschlag's "Spring Into HTML and CSS," and in the first chapter, she makes a big...
7
736
by: Mathew Hill | last post by:
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?
0
2333
by: Steve V | last post by:
I'm using Access 2000 to build a budgeting/tracking database. Can I make a validation rule (using VBA) that checks the data as if the record has already been added? I've got 5 tables (only the necessary fields are shown here): tblBudgetCategories catName:Text catTaxTrack:Yes/No tblBudgetPeriods
2
2685
by: Dnna | last post by:
I have a table which is bound to an Internet Explorer XML data island. I'm using ASP.NET's client-side validators for an input field in the table. The problem is that if the input fields are in a table that is bound to the island (such that the rows are dynamically generated by IE from the XML data island), the validators do not work. If the table is not bound, the validators do work, but then I don't have the table iterating through...
3
6338
by: Bob Alston | last post by:
I have a routine to copy data to new versions of my app via insert into sql statements. Unfortunately, due to evolution of my app, sometimes the new version has more restrictive editing than an older version that I am updating. Thus I get this message. It tells me only how many records have errors, not which errors or which records. Anyone have a nice solution to identifying the specific records involved? Maybe even the specific...
10
5723
by: gweasel | last post by:
What is the best way to apply a Validation Rule - or rather, where is the best place to put it? Is there an advantage to putting it on the field in the table vs setting the validation rule on the form the control is on? Basically I have a number of controls in a form that are required, and to check it I am setting the Validation Rule to "<>"IsNull" so that when the user tries to tab through/click out of a required area without entering...
7
3620
ak1dnar
by: ak1dnar | last post by:
Hi, I got this scripts from this URL There is Error when i submit the form. Line: 54 Error: 'document.getElementbyID(....)' is null or not an object What is this error. Complete Files
3
5993
by: Harlequin | last post by:
I must start this posing by making the point that I am NOT a VB programmer and I'm something of a Newbie to MS Access. I can program in a number of languages (Java, Javascript, PERL,PHP and TCL) but have never actually learnt VB so my request is that you bear this in mind if you plan on replying to this post. My request for help is as follows: I have an MS Access database in which one of the tables within it contains two date fields called...
7
5971
by: sharsy | last post by:
Hi guys, I would like to setup a validation rule for a database in microsoft access that restricts data entry so that a certain field can only be filled in if another field has a specific answer (that is selected via a drop down list). Example Field1 - options are "In" or "Out" Field2 - options are "Join" or "Not Joining"
0
9583
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10210
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9990
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9860
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8869
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7406
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6668
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3955
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3560
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.