From the course: Access: VBA

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a progress bar using the SysCmd object

Create a progress bar using the SysCmd object

From the course: Access: VBA

Start my 1-month free trial

Create a progress bar using the SysCmd object

“

- [Instructor] One common way to show something is happening in Access is by displaying a progress bar. In Access VBA this item is called a meter, and you can use a series of VBA commands to display, update, and remove a meter when you're done with it. I'll demonstrate how to do that in this movie, and I will base my work on the orders query, which I have opened in design view. I'll go ahead and right click in the details area of the query, and I'll make sure that I right click on a blank spot. So right click here, and then click build event. Click code builder in the choose builder dialogue box, and click OK. So here I have an event handler for when a spot in the details section is clicked. That is actually not the event that I want to use, so I will go up to the object down arrow and click form. Then I got a new event handler for when the form is loaded, and that is what I want to use. And I can leave the detail click blank, because it will run whenever the detail area is clicked…

Contents