ACC: SendKeys Macro Does Not Run
ID: Q96579
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
A macro that includes a SendKeys macro action does not run the SendKeys
action.
CAUSE
If the Wait argument for the SendKeys action is not set to Yes, the
macro action is run after some delay. Depending upon the following
macro action, the keystrokes that are sent may not be valid. If the
keystrokes are not valid, the SendKeys action appears not to have run.
RESOLUTION
Set the Wait argument for the SendKeys action to Yes.
MORE INFORMATION
Steps to Reproduce Behavior
- Create the following macro named TestMacro:
Macro: TestMacro
--------------------------
Action: SendKeys
Keystrokes: %FX
Wait: No
Action: MsgBox
Message: "HELLO WORLD"
- Save the macro.
- Run TestMacro.
The first macro action should quit Microsoft Access. However, the
Wait argument is set to No and the message box is activated before
the SendKeys action is run. When the keystrokes are processed, they
are not valid, and you hear beeping instead. If the Wait argument
were set to Yes, the SendKeys action would have completed before
moving to the next action, thus quitting Microsoft Access.
Additional query words:
key strokes
Keywords : McrActn
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Issue type : kbprb