![]() ![]() ![]() 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. 'Print the contact name and number of orders in the Immediate window.ĭCount("", "Orders", "='" & MyTable! & "'") SysCmd acSysCmdUpdateMeter, Progress_Amount SysCmd acSysCmdInitMeter, "Reading Data.", Count ' Move to last record of the table to get the total number of records. ![]() Set MyTable = MyDB.OpenRecordset("Customers") Sub ProgressMeter()ĭim MyDB As DAO.Database, MyTable As DAO.Recordset The following procedure uses the SysCmd method to update the progress meter as data from the Customers table is printed in the Immediate window. A numeric expression that represents the current progress toward completion is specified in the SysCmd method's value argument. The maximum value that the process will attain is specified in the SysCmd method's value argument. 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. 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. The status bar is the horizontal bar at the bottom of the screen that displays information about the current condition of the program, such as the status of. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |