Access macro

D

Dan at Munlake

In my Access macro the copyobject stops and prompts if I want to replace the
table, and the default button is NO. How can I use Sendkeys or something
else to switch to YES and ENTER. Does this need to precede the copyobject
line? Thanks.
 
D

Dan at Munlake

I was hoping to learn the string value syntax for these specific Sendkeys. I
noticed the SetWarnings answer earlier elsewhere in the postings, but was
hesitant to use it because I was uncertain if it stops all types of warnings
indefinitely or just until the macro finishes. Thanks for your help.
 
M

Michael Shannon

You can set the warnings back on after the particular section within the
macro has run if you are worried. I normally do this with my macros.
 
Top