<div>
Thank you all &nbsp;This really helped. &nbsp;I have a progress bar that keeps the user informed of what is going on, so it appears that I can dispense with the DoEvents as I have other visual clues for the user. &nbsp;Howver, updating a text box with DoEvents help would be helpful in another application. &nbsp;Am splitting as each of you gave me a good prespective.
</div>


<div>
Excellent information and thank you for teaching me.
</div>


<div>
<div class="content wysiwyg-content">
I have a rather lengthy procedure in ACCESS 2003 and was wondering what the benefit would be of using a DoEvents. &nbsp;I do not understand the advantage - does thi sallow the user to do other things in other applications while the procedure is running? &nbsp;If the user does open other applicatoins, the ACCESS procedure simply bogs down and takes longer. &nbsp;This is inherited code and I am trying to streamline and make more efficient.
</div>
</div>


I have a rather lengthy procedure in ACCESS 2003 and was wondering what the benefit would be of using a DoEvents.  I do not understand the advantage - does thi sallow the user to do other things in other applications while the procedure is running?  If the user does open other applicatoins, the ACCESS procedure simply bogs down and takes longer.  This is inherited code and I am trying to streamline and make more efficient.

Thank you all  This really helped.  I have a progress bar that keeps the user informed of what is going on, so it appears that I can dispense with the DoEvents as I have other visual clues for the user.  Howver, updating a text box with DoEvents help would be helpful in another application.  Am splitting as each of you gave me a good prespective.

Excellent information and thank you for teaching me.

When should I use DoEvents in Access 2003

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.

Microsoft Access

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.