Microsoft KB Archive/103251

{|
 * width="100%"|

PRB: Macro with Two SendKeys Actions Loops Infinitely
'Article ID: Q103251

Creation Date: 19-AUG-1993

Revision Date: 01-DEC-1996' 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.

When you run a macro that includes two SendKeys actions, the macro enters an infinite loop and you must restart your computer to regain control.

CAUSE

When only one SendKeys action is used in a macro, you can stop the macro by pressing CTRL+BREAK and then choosing Halt. However, using a second SendKeys action toggles the default, or non-Single Step, macro mode so that you cannot terminate the macro without restarting your computer.

MORE INFORMATION

Steps to Reproduce Behavior

CAUTION: Save all work on your computer before you set up the example below. You will have to restart your computer after you run the sample macro.

  Open a database and create the following macro: Macro Name      Action -     Go Loop          SendKeys SendKeys Go Loop Actions --     SendKeys Keystrokes: " " Wait: No     SendKeys Keystrokes: " " Wait: No  Create a new, blank form in Design view. Add a command button to the form and set its OnClick property (or OnPush in version 1.x) to Go Loop. Switch to Form view, and then click the command button.

REFERENCES

For more information about the SendKeys action, search the Help Index for "SendKeys."
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED 'AS IS' WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kbusage

KBSubcategory: McrActn

Additional reference words: 1.00 1.10 2.00 7.00 8.00 97 reboot hang