asked on

When should I use DoEvents in Access 2003

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.

SOLUTION

Lambert Heenan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Rey Obrero (Capricorn1)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sandra Smith

ASKER

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.

Sandra Smith

ASKER

Excellent information and thank you for teaching me.