turn off prompt when running VB in Access

[dharkangel]

Hi,

I have converted my queries to be run as modules written in VB in Access 2003. I am going to set up a task scheduler to run this VB code every night, by opening access at a certain time. The problem is, as I was testing the code, I get these prompts that say 'You are about to delete 133 rows' or 'you are about to update 33 rows'...Can I turn these off? How do I do that?

 

[psemianonymous]

Docmd.Setwarnings false

... then when you're done,

Docmd.setwarnings true