F. Scott Barker's Microsoft® Access 2000 Power Programming

DISPLAYING A TASK'S PROGRESS WITH THE PROGRESSBAR CONTROL

The ProgressBar ActiveX control provides you with another way to inform users of the progress of processes that might take some time to perform. Using the ProgressBar control to show a task's progress is a great addition to a professional user interface.

Using SysCmd() to Display the Access Progress Bar

In the past, you could use the SysCmd() function to display a progress bar on the Access status bar. Creating a status bar by using SysCmd() is pretty straightforward. On the WindowsCommonControlsProgressBar form, the code in Listing 14.5 is attached to the OnClick event of the cmdShowOldProgress command button.

Listing 14.5. Chap14.mdb: Displaying the Old Access Progress Bar

Private Sub ...