Unisng SendKeys For Make Table Query

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

Guest

I have a make table query that takes about thirty seconds to run. I am trying to create a macro to run the query at a scheduled time. A make table query prompts you three times for a yes no answer. I can use the Sendkeys action to send a Y for a yes response but the query seems to be taking too long to accept the final Y. What can I do to get it to answer the prompts with out any interaction from me.
 
You'd be much better off using VBA rather than a macro: it gives you far
more control.

However, I suspect you're getting the "Do you want to add..." type messages.
To suppress them, SetWarning False before running the query, then True once
it's complete

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)



Chris said:
I have a make table query that takes about thirty seconds to run. I am
Click to expand...
trying to create a macro to run the query at a scheduled time. A make table
query prompts you three times for a yes no answer. I can use the Sendkeys
action to send a Y for a yes response but the query seems to be taking too
long to accept the final Y. What can I do to get it to answer the prompts
with out any interaction from me.
 
Back
Top