Topic profile page for Validation rule.
This page has aggregated data from forum posts, threads, listings, online discussions, newsgroups, messageboards, and other online sources which contain user generated content for the term: Validation rule.
Topic "Validation rule" was discussed 0 times on 0 sites in last 3 months
Started 1 day, 8 hours ago (2010-01-05 00:24:00)
by Steve Stad
Can you tell me how to write a data validation rule I can use in the table design mode for a phone number field that will not allow blanks (eg Not null) and allow user to write N/A if phone number is not known or available AND allow user to type a phone number as (123) 123-3456 if phone number is available. Thanks.
Started 1 day, 17 hours ago (2010-01-04 15:23:00)
by Steve Stad
Can you tell me how to write a data validation rule I can use in the table design mode for a phone number field that will not allow blanks (eg Not null) and allow user to write N/A if phone number is not known or available AND allow user to type a phone number as (123) 123-3456 if phone number is available. Thanks....
Started 6 days, 19 hours ago (2009-12-30 12:54:00)
by Eager-2-Learn
Hello All, The Validation rule shown below works for me until I enter a second line in the Description field. We are using the Description field like this. Each month the user is expected to enter some kind of feedback pertaining to the Opportunity. The format is that the begining of the line must start with the date as mm/dd/yyyy format. I have two issues the most important ...
Started 6 days, 19 hours ago (2009-12-30 12:54:00)
by Eager-2-Learn
Hello All, The Validation rule shown below works for me until I enter a second line in the Description field. We are using the Description field like this. Each month the user is expected to enter some kind of feedback pertaining to the Opportunity. The format is that the begining of the line must start with the date as mm/dd/yyyy format. I have two issues the most important ...
Started 1 week, 5 days ago (2009-12-24 10:53:00)
by Prem_Carmony
Hi Guys, Im creating a web test where "I run a set of urls from a csv file ( using data binding)". I need to validate some texts on each page that is loaded for each url. Note : CSV file contains, first column with url and second column with the text to validate. ( for eg : http://google.co.uk ,david http://google.co.uk,sam) So can any one help me to implement this test successfully. ...
Started 2 weeks, 4 days ago (2009-12-19 06:12:00)
by praxis1949
Greeting all, I want to put in some validation rules without using a "save button" (for a combination of reasons, not least of which is sloth). I have been experimenting with table level and form level validation using the "validationrule" property, and it seems to work pretty well. 1. Is there some way to do an "is numeric" test on a numeric field in the validation rule property to ...
Started 4 weeks ago (2009-12-08 16:10:00)
by therock003
I am experimenting with a new database i just created in Access 2k7 in order to get the grasp of things. I have created a checkbox field, and i'm trying to set a validation rule, that checks another fields value, and if the value is not the one i set, then the checkbox cannot be applied. So far this is what i've come up with, but it return invalid syntax Code: [Field1] Not...
Started 4 weeks, 1 day ago (2009-12-08 06:31:00)
by rakeshg
Hello,All, I added a custom module in my application and on that module i have one edit view form while setting layout i had only one validation schema as required now i want to add more custom validation rule on the fields for example i want values of two fields should be same otherwise the error message should be displayed in the bottom of the text box.I want to add my custom ...
Started 20 hours, 33 minutes ago (2010-01-05 12:13:00)
by Steve Stad
Thanks for reply DB guy, You hit the nail on the head. i.e., the internal mask would not enable the 'n/a'. I used 'is not null' validaion rule with a 'message' and no zero length string. "theDBguy" wrote: > Hi, > > Not sure how you can create an Input Mask to allow both "N/A" and "(999) > ...
Started 1 day, 5 hours ago (2010-01-05 03:04:00)
by Allen Browne
In table design, set the field's properties (lower pane) like this: Validation Rule Not Null Validation Text Enter something (even N/A) for phone. Allow Zero Length No -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Steve Stad...
Started 1 day, 20 hours ago (2010-01-04 12:43:00)
by Eager-2-Learn
This was exactly what I needed. Thank you so much. My second part question must not have been asked correctly because you code does exactly what I needed. My code worked only if i had one line but as soon as I entered a second line of text the code wouldn't work!!! You code works with multiple lines. Thanks again.
Started 1 day, 20 hours ago (2010-01-04 12:08:00)
by bmartinez76
You have to use LEN for text fields as all text fields will never be null. so in your case you would use LEN (Rejected_Reason__c )=0 or NOT(LEN (Rejected_Reason__c )=0
Started 1 week, 1 day ago (2009-12-28 16:48:00)
by dajense
Hi, thanks a lot for your help. In the end dav1mo's solution worked after some slight adjustments: Code: CREATE TRIGGER VALIDATION AFTER UPDATE OF VALUE ON DATA_VALUE REFERENCING NEW AS N OLD AS O FOR EACH ROW INSERT INTO RULE_VIOLATION VALUES (N.CELL_ID, N.QUESTIONNAIRE_ID, case when n.value > 10 then 111 when n.value > 20 then 222 when n....
