Microsoft Access - Adding a Progress Bar

[@JWinAus]

Hi Daniel. I was shocked to see tonight that your Devhut site is no longer up. I hope all is well and that you will be back very soon. Your videos and material on the Devhut site were very valuable and I learned a lot from it all. I wish you all the best and hope to see you back.

[@DanielPineault]

The site will not be returning. As for the KZbin channel, I still haven't made a decision yet.

[@JWinAus]

@@DanielPineault I am sad to hear that, Daniel. Your material is brilliant and taught me a lot. I wish you well for the future. Thank you for all your effort of the years.

[@JWinAus]

Excellent video! This is exactly what I was looking for.

[@DanielPineault]

Thank you. The article and demo file will follow shortly.

[@johnclark851]

Excellent video Daniel...

[@DanielPineault]

Thank you

[@kiyabonhende8394]

Thanks you very much!

[@DanielPineault]

Your welcome. Glad you found it useful. Thank you for watching.

[@jeffgarrison5162]

I just came across this as this is something I've beeen looking for for some time. Stupid question though....How would I invoke the process? I tried to put the Generic Test in the code, but it came back after a bit and said I was out of memory. What I'm most looking for is the Test 2 approach using a dynamic overlay with the number of steps. The user would select the number of queries (which will determine the number of the iterations).

[@DanielPineault]

Without seeing your code I'm not sure what I can advise. You should be able to copy/paste any of the example routines and modify them to suit your need. Have you step through the code to see what values are being returned to see if your coding logic make sense? Perhaps post your question a forum.

[@lorenzogaruglieri7046]

Hi Daniel and Happy New Year. While waiting for any new developments for the progressbar, another idea came to my mind, perhaps a substitute for the previous one. That is: to have a double progress bar (the second optional). This solution would already allow managing very long processes which are often composed of sub-processes. Thus we would perhaps have the main bar that scrolls slowly (because it represents a process that contains others inside it) while the second bar would have a faster progress (precisely because it represents the sub-processes). What do you think about it. Thanks Lorenzo

[@DanielPineault]

Yes, I've done that for some clients. It is the exact same thing as demonstrated, just a question of adding another set of superimposed control with events and calling them in your loop. Not sure what 2023 has in store for me, but I'll see if I can't add an example to the demo file in the coming days/weeks.

[@lorenzogaruglieri7046]

Hi Daniel, great video. Question: In the past few days I asked you how to use the data export function in EXCEL to create a file with multiple cards. I saw that in your example, you perform just that function. I tried to download the demo file but the test function inherent to the export in Excel is not present? Is it possible to have that part, or better yet a quick video where you explain exporting multiple recordsets to the same EXCEL file? I would be very grateful Lorenzo

[@DanielPineault]

Sure Lorenzo, I'll create a video about this. I removed that export because the demo database with the sample data was huge, but I can certainly create something more manageable.

[@TreverMah]

How would this handle any errors that occur or user interaction to stop the process from completing?

[@DanielPineault]

Hide the progress bar and then code things to provide some response, rollback changes, ... It all depends on what process was being run. This is something you have to code yourself depending on what you are doing and how you wish to handle errors.

[@lorenzogaruglieri7046]

Hi Daniel, one more consideration: what do you think of the possibility, in order not to give the feeling of a blocked process, to insert a flashing semaphore option that makes the user understand that the process is not blocked? That is, the bar scrolls and obviously advances when a process ends and passes to the next. If a process is very long then it will visually hang at a certain percentage. Could implementing a sort of flashing message via the Timer event be a viable way? Should use be made of the DoEvents command? Thanks in advance for your opinion. Lorenzo

[@DanielPineault]

I'll see if I can fiddle with it some more as you've given me a couple ideas.

[@dbdata9836]

Fantastic

[@DanielPineault]

Thank you so much

[@dbdata9836]

Thanks

[@DanielPineault]

You're most welcome