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!!
7 2190
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)>
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
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)>
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.
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)>
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.
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?
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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
|
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...
|
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...
|
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,...
|
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...
|
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
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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
|
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...
|
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...
| |