Access - How to avoid "Not Responding"?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Rklawton
    New Member
    • May 2008
    • 6

    Access - How to avoid "Not Responding"?

    I've got some CPU intensive VBA code that works just fine.

    However, I get the application "not responding" message in my task manager while it executes. When this happens (after a few seconds of running), my form also stops displaying its progress indicators (records processed, etc).

    If I leave the application alone, it eventually completes on schedule.

    However, this "not responding" message just isn't acceptable for software I eventually intend to sell.

    I'm using Access 2003 on XP Pro.

    Ideas?

    R.
  • Rklawton
    New Member
    • May 2008
    • 6

    #2
    Doh!

    DoEvents()

    Coolio,

    R.

    Comment

    Working...