How to use Interactive Progress Bars in Microsoft Access - Step-by-Step Guide w/ 2 Examples

In this video, you will learn how to use progress bars in Microsoft Access with VBA. This will allow you to see the relative
progress of a task or set of tasks. I'll provide two examples and do my best to guide you through the process, step-by-step, from finding and inserting a progress bar control, to writing the VBA code that makes it work. Once you get through the first example, it becomes easy to make your own tweaks from there.
Code for Example 1 (Progress Bar Counting Loop): controlc.com/23f036c5
Code for Example 2: (Relative Progress for Data Entry): controlc.com/5725267e
VIDEO SUMMARY
Intro: 0:00
Overview: 0:05
First Example - Progress Bar Counting Loop: 0:15
Second Example - Relative Progress for Data Entry: 1:52
Second Example - Ensure Progress Bar's Settings are Maintained on Form Current
Outro: 5:37

[@dbdata9836]

Great

[@TLDW_Tutorials]

Thank you so much!

[@Rojin.Marzooki]

I want to write also percentage like 50%60% ..

[@TLDW_Tutorials]

It's actually a bit easier. In my video example, you have 4 things and 4/4 = 100%. Basically, start with 0 and and then create a rule up to 4. Using my video example, add a new text box called "progresstext". This is where the percentage will go. We just change the Private Sub UpdateProgressBar() - See code here: controlc.com/ab0439df

[@Rojin.Marzooki]

@@TLDW_Tutorials thanks for help💕

[@sjoerdvandermeer8979]

The Microsoft Progressbar control is not availble in Access 2016 and also not in Access 365

[@TLDW_Tutorials]

Thanks for the comment. I actually have a version of Access 365 and was able to use the Progressbar control just now. I do not have Access 2016 anymore (I replaced with 2019), but I can probably check that out to see as well. if you are using this at your work, I wonder if they are blocking ActiveX by default? If that's the case, you may be able to enable this by going to Trust Center Settings -> ActiveX Settings and enabling them.

[@sjoerdvandermeer8979]

@@TLDW_Tutorials I have a Office 365 subscription at home and at my work we are working on a Access 2016 version and ActiveX is not blocked.
I can use all available controls etc. there.
I'm sure the Progressbar is not availeble in both versions here.
I don't no why but they are also not available by friends of mine who also have Office 365 subscriptions.
Maybe i'ts because whe are using the 64-bit version?
But Colin Riddington shows us a nice method for making nice progress bars without the need for ActiveX controls or API's that works in both 32-bit and 64-bit Access
Just 3 smal subroutines
Link:
ruclips.net/video/F4Vjw8kPzIk/видео.html

[@TLDW_Tutorials]

@@sjoerdvandermeer8979 That’s interesting. I was able to get it with Access 2016 as well. Some ActiveX controls require a specific license or specific installation steps to work correctly or it could also be a registry issue. Who knows? I’ll check out the video you sent though, always like to see what others are doing.
Nevertheless it sounds like you found a solution that works for you and that’s the most important thing.

[@sjoerdvandermeer8979]

@@TLDW_Tutorials Maybe it has something to do with the use of the 32-bit version or the 64-bit version of Office 365.
I know that not all ActiveX controls are compatible with the 64-bit versions. Or maybe is there a difference in the distributions in Europe or something like that.
But eitherway for users that can use this ActiveX control, you made an excelent tutorial how to use it.😄

[@TLDW_Tutorials]

@@sjoerdvandermeer8979 If you ever do find out let me know. Anyway, I appreciate your time and comment. Take care!