Display a Custom Progress Bar in Microsoft Access Forms. Status Bar. Progress Meter Percent Complete

Learn how to use the Microsoft ActiveX ProgressBar control that comes with Microsoft Access. I don't like using external controls, however. So, I'll teach you how to create your own custom progress bar using a text box.

Melissa from San Diego, CA (A Learning Connection Member) asks: I have a monthly report that I run which requires a series of action queries, imports, and exports that takes forever. Is there any way I can show some kind of a progress bar so I know how far along it is?

BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to create a cool-looking 3D progress bar with shadowing, the percent complete, and an ABORT button to cancel the loop.

MEMBERS ONLY VIDEO:

BECOME A MEMBER:

LINKS TO TOPICS MENTIONED:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, microsoft access progress bar, microsoft access progress bar template, ms access progress bar during query, ms access vba progress bar, ms access status bar progress meter, progress bar, status bar, progress meter, percent complete

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[AccessMentors]

Thank you. I know that this was old content but it was helpful to me.

[johnsonofjohn]

Hey Richard, I was going to check out the activeX progress bar control, but it's not in the list. Did Microsoft nix it in Access 2016?

[richpertgen]

Refreshing and learning a lot thank you. When you say "put your stuff" where it says other stuff, what exactly to do you mean? I'm looking at using it to show the two imports and 3 queries in a macro, how do I represent those items in the code?

[joanlinzy]

Thank you so much Sir for sharing your knowledge, Me personally I have Learnt a lot from you, but I Have one Request, I work in a medical setting where I am required to create a system which tracks patients upcoming appointments and also notify you on the missed appointments like the day after. Thank you very much in advance.

[akterhossain]

Thank you Sir, for your video. Would like see a video on QR Code soon.
Thank a lot
Mr. Hossain from Bangladesh

[bumpersmith]

How about overlaying one text box over another. The back textbox being wider and a different color than the one on top. Then grow the one on top as the progress increases and you could also put the percentage completed in the top text box which would be right aligned.
I haven't tried this but it seems reasonable that it could work. The top textbox could even change color at different intervals or post what's happening in another text box below with changing text at each step.

[wsitech]

Very nice video as always! I wonder... If you were paging through a long recordset, would you update the progress bar at the end of every individual iteration? Like saying

PB1

[howtolearncomputernisar]

Sir i have created the successful . but one problem is there . when ever i restart my access so it did not run

[haydeecastillo]

So I’m green to access but I missed the part on how to integrate into the macro steps

[howtolearncomputernisar]

Hi sir . sir i have create loading form . when i restart access so why it didn't work .. Plz kindly solve my that problem

[zakirkhan]

I think MVP like u should shift to RPA tools like Kryon studio to do all such automation.

But still I liked this video.

[iamplaceholder]

Wish you would have said the best progress bar you've shown here is members only at the beginning of the video and not the end. Waste a lot of peoples time who have not seen your channel before. Will not support because of that. Best of luck.