Skipping Access MsgBox while running a Macro

[MsfStl]

Good Afternoon-

I have created a Macro that runs 21 append SQL statements. I want to run this without the Access Msgbox popping up 21 telling me that it will append x-rows to the tables. I want to automatically answer Yes, to all 21 msgboxes. Is there a way to catch these msgboxes and automatically answer yes? If so, does anyone have any sample code that I can look at.

Thanks

 

[Rich]

Use the SetWarnings, although this would be better done in vba with the .Execute method

 

[MsfStl]

Thanks, I'll check that out.

Thank you. Do you know if I can use a SendKey instead? I am playing around with it now. I attempt it bothways.