Progress Indicator

[John liem]

I have an Append Query (Qy_Ship), inserting data into a table (Tbl_Devry), the number of lines vary daily from 300 to 1000.
Is someone can show me how to create a variable Progress Indicator ActiveX to see the progress of the inserting process and how the procedure has to be written in VBA as I have never done this before. Thanks.

 

[Kevin_S]

John -

Unfortunitely Access does not allow you to update an ActiveX Progress bar with query processing as when the query is running provides no feedback (another stellar feature )... so the only way you can tell the progress is by looking at the status progress bar located at the lower left corner of the screen... Search the forum for "query progress bar" for more info on this...

HTH,
Kev

 

[John liem]

Hi Kevin,

Thanks and appreciate your feedback. John

 

[ecniv]

Hi,

As you have now found out, queries and feedback to the user don't go hand in hand.

However there is always a workaround and here are a couple of options:
- Have a form pop up just before actioning the code warning the user that if they for whatever reason turn off Access via the taskbar all their data will corrupt.
- Process the updated via code and update a form every 3 seconds or so with the progress using a rectangle. (my preferred option).
- Somehow get an animation (gif or whatever) running on the pop up form so the user thinks it is running ok (not sure if this will work as access usually goes off for an electronical tea break whilst processing and doesn't tell windoze about it

If you want advice on the rectangle progress bar idea, post up and I'll see what I can rough out. Its best if you code it, I can give you the algorithm though...


Vince

 

[ghudson]

Why not use the built-in progress bar that Access provides you for when queries, importing, etc. processes are running? I prefer to hide the status bar but I do use it and call it when I want it.

    Application.SetOption "Show Status Bar", True 'turn it on
    Application.SetOption "Show Status Bar", False 'turn it off

That way the user will know that something is working [processing] and the built-in progress bar is accurate versus creating something that just looks like it is working.