Access Messages

[Nuno Gomes]

Hello,

I need to perform inserts and deletes in several tables of my MDB in a form.
I'm using the command DoCmd.RunSQL = "..."
But i have a problem: when a do a delete statement, appears the mesage: "You
are going to delete x records... bla, bla. bla";
If i do a insert statement, appears the message: "You are going to insert 1
record to the table... bla, bla, bla...";
They are Access messages... How to disable this messages????....


Thanks,

Nuno Gomes

 

[fredg]

Hello,

I need to perform inserts and deletes in several tables of my MDB in a form.
I'm using the command DoCmd.RunSQL = "..."
But i have a problem: when a do a delete statement, appears the mesage: "You
are going to delete x records... bla, bla. bla";
If i do a insert statement, appears the message: "You are going to insert 1
record to the table... bla, bla, bla...";
They are Access messages... How to disable this messages????....

Thanks,

Nuno Gomes

DoCmd.SetWarnings False
DoCmd.RunSQL "Your SQL Here"
DoCmd.SetWarnings True

Or better yet, don't use RunSQL...

CurrentDb.Execute "Your SQL Here.",dbFailOnError