Threading and progressBar
Posted on 2005-04-20
I am looking to create a separate thread that maintains a status screen
whilst running long queries from macros. Currently i update a status bar
inbetween calls to long chain of macros.
Problem being that if the status form gets hidden temporarily then it will
not repaint unitil the next macro is called thus the user has no idea about
where the applicaiton is up to!
I have somewhere in the region of 100 queries run from approx 40 macros.
Each macro is called in turn from code.
I have a statusForm with a progressbar on it.
Ideally i would like to have text that updates every second displaying estimate
time to completion (time taken when last run - time elapsed) but how can
i force it to keep updating the screen in parallel with running my queries?