Browse other questions tagged access-vba ms-access. How may I create a dynamic message box/ progress bar with access. How to show progress on status bar. In microsoft access. Microsoft access progress bar. In microsoft access. Status Solved Priority Medium Security Public Views 158.
-->This topic shows how to use the SysCmd method to create a progress meter on the status bar that gives a visual representation of the progress of an operation that has a known duration or number of steps.
There are three intrinsic constants that can be used with the SysCmd method's action argument to manipulate the progress meter on the status bar. The following table describes them.
Intrinsic constant | Description |
---|---|
acSysCmdInitMeter | Initialize the progress meter. The maximum value that the process will attain is specified in the SysCmd method's value argument. |
acSysCmdUpdateMeter | Update the progress meter. A numeric expression that represents the current progress toward completion is specified in the SysCmd method's value argument. |
acSysCmdRemoveMeter | Remove progress meter. |
The following procedure uses the SysCmd method to update the progress meter as data from the Customers table is printed in the Immediate window.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
|