Results 1 to 3 of 3
  1. #1
    J Bhujanga is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2016
    Location
    Colorado
    Posts
    27

    Showing Run Progress Status

    I have some vba code that operates on very large record sets. Because they are so large, the queries that I am invoking use up all the system resources unless I break the table up during the execution and process it in manageable partitions. Even so, the code can take a couple minutes or so to complete. Hence, I want to show the user ongoing status so they don't freak out and start pressing keys.


    My plan is to show a message each time the partition loop enters a new cycle that says "Now processing Pass x of Y passes."
    I've tried two ways:
    1. Updating a text box on the form that they invoke the process. The code works but the screen itself isn't refreshing so they can't see the messages.
    2. So, I thought calling a separate pop-up form, closing and opening it each time, might solve the problem. The form opens and you can see it close and reopen, but the message is not visible.

    In both cases, if I pause the program with a message box, the current message shows up, but of course I don't want to punish the patient folks by making them sit there responding to message boxes.
    Is there a way to get these forms to display properly? (I tried a refresh command which didn't help.)
    Or perhaps a better way to go about this?
    Thanks.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    After you update the textbox or label, run
    doEvents.
    this should refresh the screen.

  3. #3
    J Bhujanga is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2016
    Location
    Colorado
    Posts
    27
    Jolly Good!!!
    Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-20-2013, 10:26 PM
  2. Replies: 1
    Last Post: 04-26-2013, 09:53 AM
  3. Progress Bar
    By pkstormy in forum Code Repository
    Replies: 3
    Last Post: 09-21-2012, 10:27 AM
  4. Form Progress/Status Bar
    By Tomfernandez1 in forum Forms
    Replies: 2
    Last Post: 06-09-2011, 01:01 PM
  5. Progress/Status Bar on Form
    By Tomfernandez1 in forum Forms
    Replies: 5
    Last Post: 05-10-2011, 04:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums