Using SendKeys for Enter

[kateri4482]

I have tried to find the answer to this question in these posts but was
unable to. I have been reading that SendKeys is not the way to go. Makes
sense since I switched to Access 2007 and now my SendKeys statements DON'T
work. My question: I am running a Delete Table Query and it always asks the
question "This table will be deleted" and it wants a Yes or No answer. I
want this to be answered automatically so the user does not have to even see
that message. If I don't use SendKeys, what should I use? I tried using a
macro, but didn't know how to create this from the macro selections. Any
suggestions?

 

[Allen Browne]

Use the Execute method to run the query.

Details in:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

 

[mcescher]

I have tried to find the answer to this question in these posts but was
unable to.  I have been reading that SendKeys is not the way to go.  Makes
sense since I switched to Access 2007 and now my SendKeys statements DON'T
work.  My question:  I am running a Delete Table Query and it always asks the
question "This table will be deleted" and it wants a Yes or No answer.  I
want this to be answered automatically so the user does not have to even see
that message.  If I don't use SendKeys, what should I use?  I tried using a
macro, but didn't know how to create this from the macro selections.  Any
suggestions?

Try DoCmd.SetWarnings False
But, make sure to turn it back on after you're done.

HTH,
Chris M.