Access macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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.
 
Back
Top