Input SendKeys in a MS Access 2007 Macro to press the enter key

fasteddie565
fasteddie565 used Ask the Experts™
on
Good Morning,
I have a macro that runs several queries, to initially update a table based on user input and then add the records from that table to another table.

The update and append queries generate about 6 requirements to click "Enter" as we are updating and appending tables.  My question(s) is (Are)

What is the best way to make this one smooth operation?

Is there a way to inject the Enter key at the appropriate time? (with some delay built in)
Is there a way to suppress the verification messages so the actions just take place?

Do I need both functions?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
To suppress warning messages in action queries, use tha macro action SetWarnings with a No setting - make sure you add another Setwarnings action at the end of the macro to switch them back on again.

You will need to press the Show All Actions button on the ribbon to see the SetWarnings action.

Author

Commented:
That was it, thanks

Author

Commented:
Quick and easy. Thanks Peter57r

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial