<div>
So what your saying is that I have to create a record set and loop through it rather than using a query.
</div>


So what your saying is that I have to create a record set and loop through it rather than using a query.

<div>
Yes. &nbsp;Once an action query is started, Access takes over. &nbsp;Your code suspends execution at the line that opens the query, so there is no way to run code to update a status display. &nbsp;Also, Access does not provide any feedback from the query on it's current point in the process.<br />
<br />
Jim.
</div>


Yes.  Once an action query is started, Access takes over.  Your code suspends execution at the line that opens the query, so there is no way to run code to update a status display.  Also, Access does not provide any feedback from the query on it's current point in the process.

Jim.

<div>
 for montyq <br />
<br />
It's time to clean up this TA, so I will leave a recommendation in Community Support that this question has been answered by: JDettman &nbsp;<br />
Please leave any comments here within the <br />
next seven days.<br />
<br />
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !<br />
<br />
Nic;o)
</div>


for montyq

It's time to clean up this TA, so I will leave a recommendation in Community Support that this question has been answered by: JDettman  
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)

<div>
Per recommendation, force-accepted by<br />
Netminder<br />
CS Moderator
</div>


Per recommendation, force-accepted by
Netminder
CS Moderator

<div>
<div class="content wysiwyg-content">
Hey guys, I need to show the progress of an action query on a progress meter. I know that when I run these queries a progress meter shows on the status bar but I can't figure out how to pass values to a progress meter while these are running and to show the total records processed. If need more info let me know.<br />
<br />
&quot;Q&quot;.....
</div>
</div>


Hey guys, I need to show the progress of an action query on a progress meter. I know that when I run these queries a progress meter shows on the status bar but I can't figure out how to pass values to a progress meter while these are running and to show the total records processed. If need more info let me know.

"Q".....

Show Progress of an Update/Appeng query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.