Dawn,
I answered this question yesterday, based on my understanding of your
problem. If you didn't like the answer, please let us know why.
In the meantime, can you please tell us why you have to keep pressing Alt+Y
as some more details about what you are experiencing will help us to know
what is happening.
Thanks.
--
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.
__________ Information from ESET Smart Security, version of virus signature database 4132 (20090604) __________
The message was checked by ESET Smart Security.
http://www.eset.com