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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top