help

[igg via AccessMonster.com]

need my access 2003 module to insert queried data from one table to another.
it works but i have to click on OK button to confirm it. IF i need to run
this automatically then this will stop the application. How can i bypass the
confirmation?.

 

[Steve Schapel]

Igg,

Put a SetWarnings/No action in your macro before the OpenQuery action.