How to disable dialog boxes?

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

Guest

I have the following problem: when I run a script with a sql query that
deletes a row in a table, a dialog box pops up and asks if I really want to
delete the row. How can I disable that box?
 
Use DoCmd.SetWarnings False before running the SQL (and DoCmd.SetWarnings
True afterwards)

If this is an MDB or MDE you're talking about, it's better to use the
Execute method of the Database or QueryDef objects.
 
Another possibility would be to uncheck the "Record Changes" Confirm option
under the Edit/Find tab in the Toos | Options menu.
 
I believe that if you use this

CurrentProject.Connection.Execute

it won't prompt

there's some sort of really easy trick like that.. I assume right now that
you're using DOcmd.RunSql?
 
Back
Top