473,324 Members | 2,400 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Validation rules stops the user from going forward.

jinalpatel
I have two tables Mainfirm and Subfirm. I have everything ready. Now I am entering validation rules like as below in my form fields to protect the tables from bad data. But when I try to enter something wrong, it gives me error and it sticks to that error message,. It does not let me go forward.
Is Null OR Not Like "*[!a-z]*"
Is Null OR Not Like "*[!0-9]*"
Is Null OR Not Like "*[!((a-z) or (0-9))]*"
Also, I tried to enter validation rules to the table itself instead of each and every form fields. Still the same.

Please help...It is driving me nuts!!
Aug 13 '08 #1
7 2190
missinglinq
3,532 Expert 2GB
I think we need to get a couple of things straight before we begin here.

"it gives me error and it sticks to that error message,. It does not let me go forward"

What exactly do you mean by this? Does it not let you attempt to correct your incorrect entry in the textbox?

"Is Null OR Not Like "*[!a-z]*""

Exactly what type of data do you expect this Validation rule to allow?

Linq ;0)>
Aug 13 '08 #2
I think we need to get a couple of things straight before we begin here.

"it gives me error and it sticks to that error message,. It does not let me go forward"

What exactly do you mean by this? Does it not let you attempt to correct your incorrect entry in the textbox?

"Is Null OR Not Like "*[!a-z]*""

Exactly what type of data do you expect this Validation rule to allow?

Linq ;0)>


Ya
I have several textboxes for data entry. Like License number, Firmname,address,city etc.I am using "Is Null OR Not Like "*[!a-z]*"" validationrule for my FirmName. Now supoose I try to edit the existing data and by mistake I type any number like 4 instead of any character like A to Z.
I get an error message(which is my validationtext) "Please enter valid Firmname." Now if I click "OK" on this message and retype in FirmName textbox. It again gives me the same error message as I just listed. The same is keep going untill I quit the application itself.

I tried to put the validation rules and validationtext on both
1)Form
2) Tables itself.
But none of them seemed to be working

Please help
Aug 14 '08 #3
missinglinq
3,532 Expert 2GB
I don't know what to tell you. The validation rule is correct for what you're trying to do. I used it without problem, both n the table as well as in the form, and jsut for kicks I tried it in both! When placing it in both and entering data thru the form, the form's Validation is the one that prevails; I know this because I varied the Validation text between the table and form. HAve you tested the other fields that have validations in place? Do all these fields fail or have you just tested the FirnName field?

Linq ;0)>
Aug 14 '08 #4
I don't know what to tell you. The validation rule is correct for what you're trying to do. I used it without problem, both n the table as well as in the form, and jsut for kicks I tried it in both! When placing it in both and entering data thru the form, the form's Validation is the one that prevails; I know this because I varied the Validation text between the table and form. HAve you tested the other fields that have validations in place? Do all these fields fail or have you just tested the FirnName field?

Linq ;0)>
Thankf for your help.
I was doing one silly mistake of entering space. Now I changed my validation rules to "Like "*[a-z]*" Or Like "?"" and it is working perfectly. I worked on this problem almost 3-4 days..and see I was doing just one mistake..
Thanks for your help
Thanks much.
Aug 15 '08 #5
missinglinq
3,532 Expert 2GB
Don't mean to upset your apple cart, but you do realize by adding the "?" that you can actually enter anything now, letters, special characters and numbers! You essentially have no validation at all.

Every attempt I make to include spaces, including using the ASCII designation, results in the same thing. But to be perfectly frank, I dodn't really understand the need to exclude numbers from the FirmName field; there are many companies, today, whose names do include numbers.

Linq ;0)>
Aug 15 '08 #6
Don't mean to upset your apple cart, but you do realize by adding the "?" that you can actually enter anything now, letters, special characters and numbers! You essentially have no validation at all.

Every attempt I make to include spaces, including using the ASCII designation, results in the same thing. But to be perfectly frank, I dodn't really understand the need to exclude numbers from the FirmName field; there are many companies, today, whose names do include numbers.

Linq ;0)>
Firmname is just an example from many other fields. I have Person's name,county,city etc.
Can you tell me how can I be specific to only space and not any other characters regarding first paragraph of ur reply. It will be too helpful if you can suggest me the validationrule that only accepts alphabets from a to z and white space.

Thanks for pointing out.
Aug 15 '08 #7
I am having the same issue as jinalpatel.
When I enter in something that does not follow the Validation rule I get the error message which is correct and what I would like however when I try to correct the error the msg will not allow me to do so.
any suggestions?
Nov 10 '10 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

21
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...
41
by: CMAR | last post by:
What are the pluses and minuses of constructing and validating between XHTML Transitional vs. HTLM 4.01 Strict Thanks, CMA
67
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...
2
by: Stephen | last post by:
Hey everyone, I am trying to run some validation on the on-click event of a button to check and see whether a datagrid contains any rows inserted into it and if it does then I'd like it to work as...
5
by: Jeremy | last post by:
I have a vb .net 2003 app that uses access 2k as a backend. The main table has some validation rules (legacy stuff brought forward inadvertantly, and now we're stuck with 'em). The problem is,...
10
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...
7
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
by: Phil Latio | last post by:
I am designing a relatively simple CMS with the usual Item, Category and User scenario. My question here relates to how I implement the User registration on this application. Currently I have the...
3
by: Water Cooler v2 | last post by:
Sorry for asking this beginner question. I've written DTDs so far and read about XML Schemas. I understand that they are a replacement of the DTD fundamentally, and therefore allow for the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.