Unisng SendKeys For Make Table Query

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

 

[Douglas J. Steele]

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)

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.