how to skip mannual work while running a macro.

[Dawn]

I have a macro which contain some update/alter table queries, which need
mannul pressing key ALT+Y during macro-running(All I have to do is keep
pressing these two keys down). How to skip the mannual work?Thx.

 

[Steve Schapel]

Dawn,

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

--
Steve Schapel, Microsoft Access MVP

I have a macro which contain some update/alter table queries, which need
mannul pressing key ALT+Y during macro-running(All I have to do is keep
pressing these two keys down). How to skip the mannual work?Thx.

__________ Information from ESET Smart Security, version of virus signature database 4129 (20090604) __________

The message was checked by ESET Smart Security.

http://www.eset.com