A
Atlas
I've just run into a well known problem (browsing through the internet)
about Access reporting an error (".........record violates the validation
rule..... ") even if:
- enforcing data checks in the Beforeupdate event. Cancel & Undo are
ignored.
- Validation rule is empty
- Validation text is empty
The text field is placed in a datasheet subform, bound to a date field
(required in the table properties).
Experts advise you stating that the error is managed at engine level, not at
VBA.
They advise you to manage the problem in the form's error event.
You see, it's the engine.....you know.......Only once, on the first go, then
no more errors.........
Nice to know, comfortable, well designed, as always.
================================================================
Windows XP + SP2
Access 2003 + SP1,
..adp project,
ADO 2.8,
MS-SQL Server 2000
about Access reporting an error (".........record violates the validation
rule..... ") even if:
- enforcing data checks in the Beforeupdate event. Cancel & Undo are
ignored.
- Validation rule is empty
- Validation text is empty
The text field is placed in a datasheet subform, bound to a date field
(required in the table properties).
Experts advise you stating that the error is managed at engine level, not at
VBA.
They advise you to manage the problem in the form's error event.
You see, it's the engine.....you know.......Only once, on the first go, then
no more errors.........
Nice to know, comfortable, well designed, as always.
================================================================
Windows XP + SP2
Access 2003 + SP1,
..adp project,
ADO 2.8,
MS-SQL Server 2000