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

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

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