The information in this article applies to:
SUMMARY
Moderate: Requires basic macro, coding, and interoperability skills.
MORE INFORMATION
The SysCmd() function is documented in the manual "The Secrets of
AccessWizards," which is included with the Microsoft Access Distribution
Kit (ADK) version 1.1. You can use this function to change the text that
appears in the status bar. For example, you might want to change the status
bar to read "Sorting..." while a sort operation is taking place, and then
remove it when the operation is complete.
Replace <action> with a numeric expression identifying the action to take. Valid entries are as follows:
Replace <text> with a string expression that will appear left aligned in the status bar. The SysCmd() function returns null, which is not used. Setting Status Bar TextWhen the action argument is 4, the string expression in the text argument will appear in the status bar. For example, type the following expression in the Immediate window and the message "Sorting..." will appear in the status bar:
Removing or Resetting the Status Bar TextWhen the action argument is 5, the status bar text set by the previous SysCmd() function is removed. For example, type the following in the Immediate window and the "Sorting..." message will be removed:
The text argument can contain about 80 characters. Since the text in the status bar uses a proportional font, the actual number of characters you can display is determined by the total width of all the characters in the text argument. You cannot set the status bar text to an empty string. If you want to remove the existing text in the status bar, set the text argument to a single space. How to Use SysCmd() in an Access Basic FunctionThe following sample function will place a message in the status bar, display a message box, and then remove the status bar text:
REFERENCESMicrosoft Access Distribution Kit "The Secrets of AccessWizards," version 1.1, page 30 Additional query words: statusbar progressmeter
Keywords : kbprg |
Last Reviewed: March 26, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |