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

--
Nuno Gomes


Departamento de Informática
domp - Desenvolvimento Organizacional, Marketing e Publicidade, SA
Rua Capitão Pombeiro, 13/15
4250 - 373 PORTO
Telf.: + 351 22 509 19 43
Fax : + 351 22 551 19 14
Site : www.domp.pt
_______________________________________________________________________

Note: this message may contain confidential information or privileged
material, and is intended only for the individual(s) named. If you are not
in the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have received
this e-mail by mistake and delete this e-mail from your system.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required please
request a hard-copy version.

 

[raskew via AccessMonster.com]

Hi -

Place this in the line above the DoCmd.RunSQL command

DoCmd.SetWarnings False

To reset:

DoCmd.SetWarnings True

HTH - Bob

 

[Linq Adams via AccessMonster.com]

And ***ALWAYS*** remember to reset it!