Timer event on forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2002 db and while building a rather complicated report I
would like the users to see a progress bar or timer that lets the user know
that the system is working. I built a ‘lazy mans’ progress bar using objects
and making them visible at various points in the process. There are about 10
steps which utilize DoCmd.RunSQL. If I try and add a timer event to show a
progress bar the SQL running takes over the CPU and the event does not run or
refresh. Any suggestions?
Thanks for your time.
Mark
 
I solved my own problem. The timer event was in a loop and did not give focus
to the event timer, it stayed in the loop..
Thanks
 
Back
Top