Popup to Display Progress of Query

[ootkhopdi]

Hi,,

i m doing some events in loop
in this loop
a update query run "n" times
then another select query runs and closed
then again update query runs..

it loop "n" times

i want to create a pop up form for displaying query run "n1" times and to run "n2" times where n1+n2=n
and displaying massage "Please Wait, Updation in Progress"

please give me solution

how can i do it,,

Thanks in advance

 

[gemma-the-husky]

try the inbuilt progress bar first.
it uses acsyscmd, to add a small progress bar in the status line at the bottom.

acsyscmd initmeter arguments
acsyscmd updatemeter arguments
acsyscmd removemeter (when done)

if you get the logic worked out for this, then you could replace that meter with a larger "progress form" of your own - a bit more work, but a similar idea.

 

[arnelgp]

here is a sample db, you should be able
to incorporate the form (frmStatusMeter and
the Module to your db.

examine the code behind the TestForm.

 

[MW4]

Where do you put the queries that you want to show progress for?

 

[apr pillai]

Hope you will find this Post and two other posts on it will be useful to you:
https://www.msaccesstips.com/2008/01/progress-counter.html