Bypassing table update confirmation screens....

[glove008]

I'm "automating" a lot of table creation and updates in VBA. I don't want my user to have to click ok every time I update a table. Is there a way to either cancel this confirmation screen or do a "click" in VBA? The "OK" button has emphasis, so a simulated enter or space bar would work, but I don't know how to do those.

 

[gemma-the-husky]

either tols/options/advanced (i think) somewhere in there are 3 flags to control this - confirm action queries etc

but safer to turn them off and on with code

docmd.setwarnings(false) and
docmd.setwarnings(true)