473,748 Members | 2,361 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 7640
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
5335
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
2332
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
6337
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
5721
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
3619
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
5991
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
5970
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
8822
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9528
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...
0
9359
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9236
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...
1
6792
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
6072
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();...
0
4863
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
2774
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2206
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.