Supressing unwanted 'update row warning' dialog

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ben Hiett - 07 Oct 2004 03:57 GMT

When running an SQL update from a subroutine, e.g.

DoCmd.RunSQL <update sql statement>

I get a dialog popping up warning me that a row is going to be updated and
do I want to continue (YES/NO)

Can I suppress/bypass this unwanted dialog box?

Reply to this Message

Joe Fallon - 07 Oct 2004 04:38 GMT

In code you can use:

DoCmd.SetWarnings False
'run query here
DoCmd.SetWarnings True

Signature

Joe Fallon
Access MVP

> When running an SQL update from a subroutine, e.g.
>
[quoted text clipped - 4 lines]
>
> Can I suppress/bypass this unwanted dialog box?

Reply to this Message

Tim Ferguson - 07 Oct 2004 17:34 GMT

> Can I suppress/bypass this unwanted dialog box?

db.Execute strSQL, dbFailOnError

This gives you _programmatic_ control of any errors that are produced,
rather than silently junking the update.

And you can have longer strSQL strings.

Hope that helps

Tim F

Reply to this Message