Recent content by vjimmers
-
V
Table Field Validation Rules triggering in Forms
Some guy (me) posted some code above before enough testing. The code below works as intended! I'm new at this but there are hardly any examples anywhere online so hopefully this will help someone get going in less time than it is taking me. I'm not entirely sure where we have to account for NULL... -
V
Table Field Validation Rules triggering in Forms
You have a point about the SQL versions. IDD10Ts! I don't really care what my data is displayed with as long as all the business logic is in SQL Server or the lowest level possible and that every table has a real data unique record constraint. SharePoint lists don't exactly instill confidence... -
V
Table Field Validation Rules triggering in Forms
Re: Table Field Validation Rules triggering in Forms <<So, this is the event where you would put any multi-field validation or any not-null rules that can't be implemented by RI.>> "that can't be implemented by RI" is the key phrase. If people could die or lose billions of dollars from any... -
V
Table Field Validation Rules triggering in Forms
I slapped some code up in one of my last posts. Here is a fix for the table trigger / Before Change macro. I am expericed at SQL Server but this is my first Access Web app so I'm playing around seeing how and what can be done. /* implement muti-column unique record constraint*/ If [IsInsert]... -
V
Table Field Validation Rules triggering in Forms
<<Many experienced developers, rather than doing validation at the table level, do it at the form level, either in the control's BeforeUpdate event or the form's BeforeUpdate event, depending on the exact type of validation.>> More experienced developers put validation at the lowest level...