Access macro

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

 

[KARL DEWEY]

You can SetWarnings No

 

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

 

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

 

[Steve Schapel]

Dan,

SetWarnings automatically resets to Yes when the macro finishes.