A2003
I have a loop on a form, which imports records. During my main loop I display a text status message on the status bar showing how many records have been processed. During this import process I also do INSERT queries and perhaps some UPDATE queries for detail records attached to the main record I am importing. Something is triggering a progress bar to overwrite my text status bar, as the progress bar is in the same location as my status bar text. So in the status bar area I get a lot of flashing between my text I display, and the automatic progress bar.
How do I turn off the progress bar during my loop, then turn it back on at the end of my loop (to be used by other processes)?
Thanks.
(No, Access help was not useful. I tried it.)
I have a loop on a form, which imports records. During my main loop I display a text status message on the status bar showing how many records have been processed. During this import process I also do INSERT queries and perhaps some UPDATE queries for detail records attached to the main record I am importing. Something is triggering a progress bar to overwrite my text status bar, as the progress bar is in the same location as my status bar text. So in the status bar area I get a lot of flashing between my text I display, and the automatic progress bar.
How do I turn off the progress bar during my loop, then turn it back on at the end of my loop (to be used by other processes)?
Thanks.
(No, Access help was not useful. I tried it.)