disabling delete/append message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
how can I disable those
"you are about to append a row..."
"you are about to delete a row..."
in Access 2003

thanx

alek_mil
 
Alek,

It depends how the action queries are being run.

If you are using a macro, you can put a SetWarnings/No action in the
macro, ahead of the first OpenQuery action.

If you are using VBA procedure, with a DoCmd.OpenQuery or DoCmd.RunSQL
method, you can put this before the code running the query...
DoCmd.SetWarnings False
In this case, it is important to put
DoCmd.SetWarnings True
at the end.

However, you can also use this in your VBA code instead...
CurrentDb.Execute "YourQuery"
.... which does not generate the confirmation messages, so no action
needed to disable them.
 
Back
Top