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:
• Display a Custom Progr...
BECOME A MEMBER:
/ @599cd
LINKS TO TOPICS MENTIONED:
Get on my Mailing List: 599cd.com/YTML
Sleep VBA: 599cd.com/sleep
Developer 18: 599cd.com/acd18
ADDITIONAL RESOURCES:
FREE Access Level 1: 599cd.com/Free1
FREE Customer Template Database: 599cd.com/XCDT
$1 Access Level 2: 599cd.com/1Dollar
Your Questions Answered: 599cd.com/TechHelp
Learning Connection 50% OFF: 599cd.com/Connection
Survey: 599cd.com/survey
Richard's Blog: 599cd.com/blog
Access Forum: 599cd.com/AccessForum
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: [e-mail]
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.

[@AccessMentorTips]

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

[@599CD]

It's not THAT old.

[@zuberareef8655]

amazing.well done

[@599CD]

Thanks a lot!

[@Ziahasan222]

Awsme sir. Thank you very much. 😁

[@599CD]

Most welcome 😊

[@kamleshjain6872]

Awesome.....💕💕

[@599CD]

Thank you! Cheers!

[@yvesbuhlmann252]

Your a very goog teacher!!

[@599CD]

Thanks!

[@malikstudio7331]

Very nice dear sir

[@599CD]

Thanks

[@akterhossain9548]

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

[@599CD]

I'm working on some barcode seminars right now. Unfortunately it will be for 1D barcodes. 2D barcodes (and QR codes) are difficult to create in Access without major programming, 3rd party plugins, or API calls to the web. I might cover this in a Developer course, but it's beyond the scope of a free TechHelp video.

[@chaiwajustine8532]

WOW woow that good

[@599CD]

Thanks!

[@joanlinzy3041]

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.

[@599CD]

Sounds like a fun project. Feel free to submit it: 599cd.com/TechHelp - give me as many details as you can.

[@richpertgen3005]

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?

[@599CD]

"Your stuff" is whatever you want to do. Run a query. Update the progress bar. Run another query. Update bar. Run a macro. Update bar. Make coffee. Update bar. Get it?

[@richpertgen3005]

@@599CD I'll have to research how to put in there the import macros and queries then. Not a programmer if you could tell. lol

[@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.

[@599CD]

Absolutely! Have fun with it. I thought about the color changing thing too, but I didn't want to get too carried away. These are supposed to be SHORT lessons. LOL

[@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 (100*rs.AbsolutePosition)/(rs.RecordCount)

[@599CD]

Depends on the size of the recordset. 100 records, sure. 100,000 records, maybe display every 1000. Also depends on how long each record takes to process. I like to try to update the display at least once every second. Lets the user know something is going on and the DB isn't frozen.

[@johnsonofjohn1678]

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?

[@599CD]

Still in my version of Access. MS 365 subscription.

[@zakirkhan24]

I think MVP like u should shift to RPA tools like Kryon studio to do all such automation. But still I liked this video.

[@599CD]

Thanks for the feedback, but I'll stick with Access. Been using it for 26 years and I have no plans to switch to anything else.

[@haydeecastillo4621]

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

[@599CD]

Everything you need is shown in the video

[@howtolearncomputernisar7054]

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

[@599CD]

I don't understand.

[@howtolearncomputernisar7054]

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

[@599CD]

Without seeing your database, it's impossible for me to tell what's wrong. If you followed my instructions, step-by-step, it will work.

[@jamesrutino5285]

CAN THE PROGRESS BAR OPEN A FORM

[@599CD]

Well, not by itself. You could code it in your loop so that at some certain point a form could open. Something like: If PercentComplete > 80 then DoCmd.OpenForm "MyFormF"

[@jamesrutino5285]

@@599CD thanks 😊 it worked

[@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.

[@599CD]

Well... you know where the door is. Don't let it hit you on the way out. Aww, man... I just noticed that you've got Neil deGrasse Tyson as your profile picture. That means you can't be THAT much of an asshole. LOL