Turn off Alerts

  • Thread starter Thread starter Hanksor
  • Start date Start date
H

Hanksor

I have looked everywhere and can't find the VB to turn off/on the alerts
when updating a record from a form. The "You are about to update (1)
record" and such... Any help will be appreciated.
 
DoCmd.SetWarnings False

Be sure that you turn them back on again... and be sure that you include the
"turn it back on" step in all error handlers:
DoCmd.SetWarnings True
 
Thanks Ken.. Is it possible to turn off the "Write Conflict" Alert? I have
a form that shows current values and the user clicks a button to add to the
current value. Everything works fine until the form is closed and the
"Write Conflict" Alert comes up. I know we can just click on save record
but I don't want to "freak" anyone who would be using the form.
 
Write conflict, meaning "another user has modified the data since..."? You'd
have to trap that error in VBA in an event (probably the form's Error
event?) and not let the error show to the user.
 
Back
Top