SQL Error trapping

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Fisher - 22 Feb 2006 19:51 GMT

I have a column that does not allow nulls and it works just fine. When a user
trys to enter a new reccord and leaves the field blank they get an error.
How do I trap the error from the server so I can write my own message and
perform vba code once the user acknowleges the message.
Thanks.

Reply to this Message

Sylvain Lafontaine - 27 Feb 2006 05:12 GMT

The easiest way would be to make the verification before trying updating the
database: use the Form_BeforeInsert event and cancel the insertion if a
required field has been left blank.

Signature

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

>I have a column that does not allow nulls and it works just fine. When a
>user
> trys to enter a new reccord and leaves the field blank they get an error.
> How do I trap the error from the server so I can write my own message and
> perform vba code once the user acknowleges the message.
> Thanks.

Reply to this Message