Let's make a Custom Progress Bar in Microsoft Access

[@baldev_81]

Great tutorial !!! It worked fine on my test form but i couldn't able to associate it with my append queries. I really appreciate your great help..

[@jorgeluistorrescastaneda9527]

solo quiero decir ere un master saludos desde mexico, i only want to say you are a master thanks so much greetings. from mexico

[@johndavy3820]

Great video! I am going to try it. Thanks John

[@yelirnoed]

Hi Access Jitsu, great video. You might want to spare a thought for those of us who are hearing impaired; your audio volume level being too low. You might want to adjust it a little higher. Those who have excellent hearing perhaps could turn down their volume. My opinion only. Cheers, Yelir

[@Accessjitsu]

I will see what I can do.

[@pltc71]

Very helpful, thanks

[@freebird7556]

Great!! Thank you so much!!!

[@davegoodo3603]

I also commend the video. But agree with other comments regarding hearing. I do have a hearing impairment and find myself running out of volume that I can raise it to. Any help would be welcomed.

[@spiderko]

Hi Dave, here is an advice which helped me: "One thing can help is the following. Right click the speaker icon in the Taskbar and select 'Playback Devices'. Left click the default device once to highlight it ( it's usually 'speakers & headphones' ) then click the Properties button. Click the Enhancements tab and put a tick in the box next to 'Loudness Equalization'. Click Apply to save the change and then click OK in all remaining windows and see if this has helped at all." (Source: h30434.www3.hp.com/t5/Notebook-Audio/sound-is-not-enough-how-to-increase-volume-of-my-laptop/td-p/1708461)

[@christhorne77]

I really like this tutorial - Awesome to use an image!! However I am stuck and could use a little help here... I have a splash screen that has a timer interval of 6000. For aesthetic purposes only, I would like to add a progress bar that starts on the splash screen loading and has a timer interval of 5000 thus getting to 100% complete 1 second before the splash screen disappears and opens the database main form. How can I use this tutorial to do that?

[@janezklun]

great video, thank you

[@RK-fp7ob]

hi, thanks for the great tutorial. works fine, only thing is my progress ba blinks the whole time.... know something for that ???

[@johnw6013]

Please forgive my ignorance, I'm learning. I was able to get your progress bar working as you designed it and it looks great, exactly what I need. However, I can't seem to figure out how to make it work with my task. I am importing a table from another database using: {DoCmd.TransferDatabase acImport, "ODBC Database", _}. Thank you in advance for the help. More importantly, Thank you for the video.

[@Accessjitsu]

In order to be able to really use a progress bar, you must be able to get "inside" the task you are performing. If it is a task that Access is performing for you, such as transferdatabase, you have no way of knowing where Access is on the task, at the beginning, the middle, etc. You must be performing the task with your own code, so you can do the counting as it progresses, and then you can do the math to know if you are 20%, 50% complete, etc. Any taskbar that "we" create, can't see inside a Microsoft written function, Microsoft doesn't show us that. You could use this task bar if you were performing four queries, and you could estimate that you are 25% complete after the first query, and 75% complete after the third, but Microsoft doesn't expose to us how far is within any one of those queries (except Microsoft does "show" us via its own progress bar sometimes).

[@howtolearncomputernisar7054]

I have created but after restart why it is not working

[@ManocChen]

Cannot access your site. It is blocked by antivirus software.

[@RGBisFREE]

well done!

[@sunejvv]

Good day could you please tel me how to use your progress bar which I have now done simultaneously with copying files for a backup. I need to backup from c: to E:

[@Accessjitsu]

+Sunè Jansen van Vuuren I think the challenge will be in knowing how many files your operation will copy before you start the copy process. In other words, in order to be able to show you are 25% complete when you have copied 1 of 4 files, you must first know that you will be copying 4 files. So you will need to count the files you will be copying first, which will give you a "denominator", and then count off each file as it is copied so you can perform the math needed for the progress bar.

[@lizravenwood5317]

slick. Thanks.

[@jessetribbey8062]

can you use the same progress bar if you have several different task to perform? For example, I have a db that has one button to load a file into the db, a second that runs the new data through a set of stepped queries to group/identify data and then its give a total dollar figure for the processed lines and a third task that then loads the formatted data into the final table and gives you a total again to make sure you havent loaded the data more than once. Your thoughts?

[@Accessjitsu]

+Jesse Tribbey If you run the tasks one after the other, yes, you can make each task use that same taskbar.

[@jessetribbey8062]

awesome....thanks!

[@Runawaygeekchannel]

If i have multiple tasks, eg a list of "Append Queries" to run, would i need to call the bar for each one, or could i group those tasks and just have the bar reset each time? (kind of like the mini bar does at the bottom of the screen?) Also, i was unsure how i would link this to another button on another form, could you point me in the right direction, thank you. :-)

[@Accessjitsu]

You can reset the progress bar to zero whenever you like (as each query starts), or you could say query one is 10%, query two is 20%, and when the last query completes, your progress bar shows 100%. I don't understand linking the progress bar to a button on another form. If you mean the other button would start a task that the progress bar should track, then that form will need to refer to progress bar on its form. Put the form name in front of all references to the progress bar. Make sure that any progress bar properties are public in scope.

[@abdulridi1364]

Hello Sir, I was able to get the progress bar to work and open a form after its done loading - But after "Task Complete" message appears MS Access takes around 15 sec to open form. How can I modify that where form will open immediately after message "Task Complete". Thank You

[@Accessjitsu]

There must be some code still running after the task complete message. Can you step through the code in the editor to see what is causing the delay?

[@CampfireEditor]

Open the other form in hidden mode just before the 'progress bar' form opens. When the 'Task Complete' message is done and the progress bar form closes, just unhide the other form.

[@antoniomarques1727]

Very Good

[@johndavy3820]

Any chance that you might send me a copy of your image??

[@land8705]

Where would I add the code to run my Update/Apend queries?

[@Accessjitsu]

In cmdStart_Click, the Do While loop is meant to simulate an long running process, so you would replace that entire structure with the "thing" you need to do. If you are adding one row at a time to a table, you could call update progress, insede your loop, after you insert each row into a table. If you are executing a query to do the insert or append, you might not get what you really want from this progress bar. We are not able to "get inside" the execution of a query and keep track of its progress. If you needed to execute three queries, you could set the progress bar to 33% after finishing the first query, 66% after the second and 100% after the third.

[@joesanders2037]

Horrible Video. The sound makes impossible to watch.