Suppressing alert messages

[reburton]

I have a routine that runs a series of 15 queries and I get three messages for each query. I answer with the default to each message. I know how to suppress alerts in excel, but the Access VBA does not support the command. I suspect there is a way but I can't find it.

[ItsMe]

This is some code I use

' turn off warnings for updates
DoCmd.SetWarnings False
DoCmd.RunSQL strSQL 'Delete the files. These are duplicates
' turn on warnings for updates
DoCmd.SetWarnings True

[reburton]

Thanks! I really appreciate it!

[pbaldy]

Another option:

http://www.baldyweb.com/SQLWarnings.htm

[ItsMe]

Thanks Paul,

Interesting, I have used both and never gave it much thought. I will have to look into that further.