Using SendKeys for Enter

  • Thread starter Thread starter kateri4482
  • Start date Start date
K

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?
 
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?
Click to expand...

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

HTH,
Chris M.
 
Back
Top