Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    123

    Question Unanswered: How do I create a custom status bar using a pop-up form?

    I would like to create a status pop-up like one sees when downloading from the internet or installing an app. I have a procedure that takes between 5-60 seconds. I would like to use a pop-up with a status bar that shows how far along the process is. There are actually five distinct sub-processes, so when each one is done, the pop-up status bar should update. But no matter what I try, I get a pop-up that opens up at the beginning, and than only updates after the whole VBA routine is done--nothing in between.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Personally I use the status bar to update users on the process (see SysCmd in VBA help). To get a form to update, you probably need to add a DoEvents in your code.
    Paul

  3. #3
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    Have you tried
    YourStatusForm.Repaint
    method after each status update ?

    Like pbaldy I generaly use the SyCmd and the Access status bar.

    MTB

Posting Permissions

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