How to change an SQL pop up message

[jrsitman]

I set one of the fields to not allow nulls and it is working.
Can this message be customized?

Thanks,



J.R.

[June7]

Not change but possibly trap error message and deliver your own with VBA.

How are you executing the SQL? Why not prevent event causing error?

[Micron]

If what you really want is a customized message then you need to trap that error number in the afterupdate event of the control. Then you'd present either a message box with your custom message, or your own form that looks like a message box.

[NoellaG]

Maybe better in the BeforeUpdate event, so you can prevent the error. Or simply set the validation rule not null in the form control?

[jrsitman]

If what you really want is a customized message then you need to trap that error number in the afterupdate event of the control. Then you'd present either a message box with your custom message, or your own form that looks like a message box.

I'll try this first.

[Minty]

Just to clarify - I'm pretty certain Access can't capture that error as it is returned by the ODBC driver.
Any Table level constraint must be validated in the forms before update event so that it doesn't actually trigger the table constraint.

It's one of the few downsides to setting table level constraints on SQL server.

[NoellaG]

In fact, in most companies the developers are briefed about existing constraints and structures on the database, and it is company policy that all restrictions are met in the front end before any commands are send to the database. If an error is returned from the database it is seen as a bug in the front end.