Query pop ups

[xlt-hunter]

After sorting out my issues with reporting multi amount of data to a report.

When I start a append query the database throws up

"You are about to apprend 1 row(s)" as a pop up window...

and the same when I close the data form down:

"You are about to run a delete query that will modify data in your table"

How do I turn these pop ups off from the queries?

Thanks

Mike

 

[FoFa]

Set Warnings off
Look up Docmd.setwarnings in help
Don't forget to reset it before exiting your code

 

[xlt-hunter]

Set Warnings off
Look up Docmd.setwarnings in help
Don't forget to reset it before exiting your code

Brilliant, thanks FoFa, hep suggested the use of SetWarnings in the marco as this is where its happening from.

Thanks!