Timer event vs. longrunning line: concurrency issue

[GlistEngineering]

I have a single line of code that takes a long time to run. (This is because it is either accessing or writing to a network location.)

I want to run a Form_Timer event during this to animate a rotating hourglass (just to show the user something is happening so they don't go click-crazy).

I learned VBA doesn't support concurrency, which I take to mean I can't run the Timer event while my longrunning subroutine executes. Because my longrunning subroutine really is a single longrunning line of code, I can't use DoEvents to free up the processor.



Is there a concurrency workaround for this case, or should I find another way to let the user know their system is at work?

[ssanfu]

I want to run a Form_Timer event during this to animate a rotating hourglass

You can set the cursor to busy (hourglass) using Docmd.hourglass True and Docmd.hourglass False.

Or you can check out:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=929

or
http://www.dbforums.com/microsoft-ac...nd-cursor.html

or maybe
http://www.ehow.com/how_7523999_change-cursor-vba.html

Or maybe even
http://access.mvps.org/access/api/api0044.htm