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
• How to Use Recursive F...
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
• How to Use Collections...
How to Handle VBA Errors in MS Access
• How to Handle VBA Erro...
How to Use the Eval Function in Microsoft Access
• How to Use the Eval Fu...
How to Switch from One MS Access Database to Another
• How to Switch from One...
Follow us on social media:
/ mackenziedat. .
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/...
Got a KZitem Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenz...
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
Негізгі бет Ғылым және технология VBA Mod Function with DoEvents: Prevent Not Responding Messages and Provide Feedback on Access Forms
Пікірлер: 15