Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Quincy, Illinois
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Progress Bar Freezes (Access 2003)

    I've setup a common form (F_ProgressBar) that includes a text box and a Progress Bar (add-in from 'More Controls'). When I run a piece of code, I call this form and set the progress bar to the percent complete when looping through a recordset. I have a few pieces of code that can take up to 10 minuts to run so I want to go to another application to do other work, however when I do, the progress bar freezes and from that point forward I'm unable to find out where I'm at in the process. Is their any way to refresh this or keep the progress bar from freezing when I move to another application?

    As an FYI, I have dual monitors and keep Access up on one and do other work off the other.

    Thanks in advance for the help.
    Drew

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Progress Bar Freezes (Access 2003)

    Insert one or more lines

    DoEvents
    Me.Repaint

    in the loop

    If the code runs from another form, use

    Forms!F_ProgressBar.Repaint

    instead of Me.Repaint.

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Quincy, Illinois
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Progress Bar Freezes (Access 2003)

    Works perfect. Thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •