a) you forgot to turn warnings back on.
b) if you turn warnings off and code errors, code will cease and warnings will remain off. You should always have an error trap that will turn them back on if it fails.
c) the above is why the .Execute method is better for running action queries or sql statements. You don't affect warnings by using that method.
Please try to remember to use code tags (# on forum menu bar) and indentation for more than a couple of lines of posted code.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.