how to skip mannual work while running a macro.

D

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.
 
S

Steve Schapel

Dawn,

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

--
Steve Schapel, Microsoft Access MVP


Dawn said:
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.
Click to expand...



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

The message was checked by ESET Smart Security.

http://www.eset.com
 
Top