Access macros - automatically hit enter/select OK

[BlackJack17]

Alright I've searched the forum and have found nothing on this subject so I'm hoping that you all can help me out.

I've put together a macro that contains a series of delete, update, and append queries. The problem is that with these queries, Access asks if you're sure you want to run them and tells you how many records it's deleting, etc. This is tedious to sit there and hit enter or select OK for all those text boxes. Is there any way to either select OK or automatically input a keyboard command (like hitting enter)? If not, is there any way to disable those pop up boxes?

[DThreadgill]

Alright I've searched the forum and have found nothing on this subject so I'm hoping that you all can help me out.

I've put together a macro that contains a series of delete, update, and append queries. The problem is that with these queries, Access asks if you're sure you want to run them and tells you how many records it's deleting, etc. This is tedious to sit there and hit enter or select OK for all those text boxes. Is there any way to either select OK or automatically input a keyboard command (like hitting enter)? If not, is there any way to disable those pop up boxes?

BlackJack17 - Add another line item at the beginning of your macro: Setwarning and set it to False. You can add another at the end to set it back to true.

[BlackJack17]

Awesome, thanks so much!