validation rule violations when there are no validation rules!

validation rule violations when there are no validation rules!

Post by J. Thomas » Sat, 27 Sep 2003 06:09:32

How can I get validation rule violations in an append
query when the table it appends to does not have any
validation rules? I created a table using a make-table
query. Then I changed the make-table query to an append
query. I added a few more fields to the newly-created
table, but no validation rules. When I run the append
query, I often get validation rule violations, even though
there aren't any validation rules.

Another anomaly: If I add extra fields in the make-table
query in the form "field:Null" so they will be in the
newly-created table, the created fields in the new table
have the data type "Binary". But this isn't even an
allowed data type when creating a table in design view...
The make-table query also creates text fields of size 255,
even for fields that only need one character of text, and
I have to tweak them all to make it run more efficiently...

1. Getting 'validation rule violation' when I don't have any validation rules?

2. Create a Validation rule for IBAN Account nos in a form field


I have a form linked to a table.
One of the fields in the table has this input mask (for IBAN account nos.):

This forces the first two characters to be upper case alphabetic, then up to
18 numbers (mandatory) followed by up to 8 optional numbers.

But I would like to be able to validate this on the form side with a
validation rule and validation text for the error message - as currently it
just shows the message 'not valid for this input mask' ... which is not very
user friendly.

Any idea how I can either create an Validation Rule like that for the form,
or get Access 2003 to show a nice error message when the data entry doesn't
fit the input mask?

thanks for any help or ideas


3. Validation Rules and Validation Expressions

4. Allow enty of data outside validation rule without removing rule

5. Validation Rule/Validation Text

6. Validation Rule and Validation Text

7. Validation Rule and Validation Text Property?

8. how do I set up a validation rules with two data rules

9. How do I find Lock and Validation Rule Violations?

10. exit sub on validation rule violation

11. INSERT INTO VALIDATION RULE VIOLATION How to identify specific records?

12. Validation rule - How to handle violation?

13. validation rules violations

14. access 97 append query fails due to validation rule violations - there are no validation rules in either source table or target table

15. DLookup function in ADP form Validation Rule