Solved

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

Posted on 2012-12-28
3
804 Views
Last Modified: 2012-12-28
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?
0
Comment
Question by:fasteddie565
  • 2
3 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 500 total points
ID: 38727290
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.
0
 

Author Comment

by:fasteddie565
ID: 38727498
That was it, thanks
0
 

Author Closing Comment

by:fasteddie565
ID: 38727502
Quick and easy. Thanks Peter57r
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question