In this episode, we’re going to explore how to use the VBA Mod function with the DoEvents command, to allow form updates while your procedure is running. We’ll use a procedure to loop through about 23,000 records, while performing some task along the way. You will see that Access will lock up, and show “Not Responding” at the top of the screen while it runs. After changing our procedure to use the Mod function with DoEvents, you will see that Access does not lock up. It displays a progress counter on a form as the procedure runs, and does not show “Not Responding” at the top of the screen. This handy technique is extremely valuable for correcting procedures that take a lot of time, lock up users' computers, and prevent them from using their computer normally while some long process executes. It also allows you to give some feedback to the user as to how far a process has gone (and has to go). Related Videos: How to Use Recursive Functions in MS Access - Family Tree Example https://www.youtube.com/watch?v=TKSNBFEqiTo VBA Mod Function with DoEvents: Prevent Not Responding Messages and Provide Feedback on Access Forms You are watching this video now! How to Use Collections in Microsoft Access VBA https://www.youtube.com/watch?v=Z8MyC6TEEMg How to Handle VBA Errors in MS Access https://www.youtube.com/watch?v=13aFUK7tmus How to Use the Eval Function in Microsoft Access https://www.youtube.com/watch?v=-AhY6xw_E80 How to Switch from One MS Access Database to Another https://www.youtube.com/watch?v=lrknjXWO6zE Follow us on social media: https://www.facebook.com/mackenziedat... https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering DoEvents vba screen refresh, ms access status update, ms access prevent not responding, ms access freeze, ms access locks up, ms access doevents, vba recordcount, access doevent, vba creen, vba mod function, vba mod function with doevents, ms access not responding, ms access form refresh, ms access do loop, ms access recordset, sean mackenzie