<div>
The form to displays the status message, open it as a Pop-up and Modal form. &nbsp;By being a Modal form, it will stop the execution of VBA code right where it is opened. &nbsp;Set the Timer value to 10 seconds (10 x 1000). &nbsp;Set the OnTimer event procedure to close the form. &nbsp;<br />
This will cause the OnTimer event to fire after 10 seconds, and the on timer event will close the form. &nbsp;At this point your VBA code will start executing again, right after the line that opened this status message form.<br />

</div>


<div>
<div class="content wysiwyg-content">
I would like to pause an execution of VBA code in the MS ACCESS, I have a loop that will run multiple times and update a table records with each loop. I would like to pause for 10 sec after each time loop goes to next record and display a status bar message that I know how to do. I do not want use the MsgBox for user to click OK, I want this to be controlled by VBA code and set to specific time.
</div>
</div>


I would like to pause an execution of VBA code in the MS ACCESS, I have a loop that will run multiple times and update a table records with each loop. I would like to pause for 10 sec after each time loop goes to next record and display a status bar message that I know how to do. I do not want use the MsgBox for user to click OK, I want this to be controlled by VBA code and set to specific time.

The form to displays the status message, open it as a Pop-up and Modal form.  By being a Modal form, it will stop the execution of VBA code right where it is opened.  Set the Timer value to 10 seconds (10 x 1000).  Set the OnTimer event procedure to close the form.  
This will cause the OnTimer event to fire after 10 seconds, and the on timer event will close the form.  At this point your VBA code will start executing again, right after the line that opened this status message form.


How to pause execution of VBA code in MS ACESS

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.