ACC: SendKeys Macro Does Not Run (96579)


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97
This article was previously published under Q96579
Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

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


  1. Create the following macro named TestMacro: 
          Macro: TestMacro
      --------------------------
      Action: SendKeys
         Keystrokes: %FX
         Wait: No
      Action: MsgBox
         Message:  "HELLO WORLD"
  2. Save the macro.
  3. 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.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbprb KB96579
©2002 Microsoft Corporation. All rights reserved.