Share via

Disable MS Access MsgBox when running UPDATE SQL statement

Anonymous
2012-11-30T04:33:12+00:00

When you run an UPDATE query or UPDATE sql, is there any way to disable the default box in MS Access that says "You are about to update 1 row(s)."?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Duane Hookom 26,825 Reputation points Volunteer Moderator
2012-11-30T04:38:16+00:00

You can run some code to SetWarnings = False before and then set back to True after.

DoCmd.SetWarnings = False

I expect you can also do this with a macro.

Duane

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-11-30T06:14:24+00:00

    Thanks so much Duane!  I didn't need the =, just DoCmd.SetWarnings False.  Other than that, it worked like a charm.  Thanks, again!

    Was this answer helpful?

    0 comments