Popup to Display Progress of Query (1 Viewer)

ootkhopdi · Oct 18, 2017

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 · Oct 18, 2017

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 · Oct 18, 2017

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 · Feb 23, 2019

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

apr pillai · Feb 26, 2019

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

Popup to Display Progress of Query (1 Viewer)

ootkhopdi

Registered User.

gemma-the-husky

Super Moderator

arnelgp

..forever waiting... waiting for jellybean!

Attachments

MW4

New member

apr pillai

AWF VIP

Similar threads

Users who are viewing this thread