Microsoft KB Archive/100126: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 39: | Line 39: | ||
If the Repeat Count argument falls between 0 and 32,767, Microsoft Access returns the expected results (no repeat). | If the Repeat Count argument falls between 0 and 32,767, Microsoft Access returns the expected results (no repeat). | ||
If the Repeat Count argument falls between 32,767 and 65,535, Microsoft Access returns the error message listed above in the | 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. | 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. | ||
Line 83: | Line 83: | ||
Caption: Repeat | Caption: Repeat | ||
OnPush: RepeatCount Test</pre></blockquote></li> | OnPush: RepeatCount Test</pre></blockquote></li> | ||
<li>Open Test Form in Form view. Type | <li>Open Test Form in Form view. Type "1" in Field0, then choose Increment. Note that each time you choose Increment, the value in Field0 increases by 1.</li> | ||
<li><p>Type | <li><p>Type "1" in Field0, then choose Repeat. When the RepeatCount Test macro has run, the message "Done" is displayed. Note that the value in Field0 is now 32,767.</p> | ||
<p>To test different Repeat Count arguments, open the RepeatCount Test macro in Design view, change the Repeat Count argument, and repeat step 5.</p></li></ol> | <p>To test different Repeat Count arguments, open the RepeatCount Test macro in Design view, change the Repeat Count argument, and repeat step 5.</p></li></ol> | ||
|} | |} | ||
Line 91: | Line 91: | ||
----- | ----- | ||
<blockquote>THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED | <blockquote>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.</blockquote> | ||
''<span>©1997 Microsoft Corporation. All rights reserved.</span> <span>Legal Notices</span>.<br /> | ''<span>©1997 Microsoft Corporation. All rights reserved.</span> <span>Legal Notices</span>.<br /> | ||
'' | '' |
Revision as of 12:40, 19 July 2020
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