PRA: RunMacro May Not Work with Large Repeat CountArticle ID: Q100126
SYMPTOMS
Repeat Count argument in RunMacro action can't be less than 0 CAUSE Microsoft Access does not explicitly check for Repeat Count arguments greater than 32,767. Such values may wrap around either to a negative number or to an unexpected positive number. If the resulting value is negative, Microsoft Access displays the above error message. If the value is positive, Microsoft Access runs the macro using the Repeat Count argument that it evaluated. RESOLUTION
STATUS Microsoft has confirmed this to be a problem in Microsoft Access versions 1.0 and 1.1. This problem no longer occurs in Microsoft Access version 2.0. MORE INFORMATION
If the Repeat Count argument falls between 32,767 and 65,535, Microsoft Access returns the error message listed above in the "Symptoms" section. If the Repeat Count argument is greater than 65,535, Microsoft Access returns either the expected results (no repeat), the error message, or unexpected results. Steps to Reproduce Behavior
|
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.
Additional reference words: 1.00 1.10 macros RepeatCount ui
KBCategory: kbusage
KBSubcategory: McrActn