While I am doing some work...

[Carlos Martinez]

This should not be uncommon, so I apologize if this is trivial as well.

In a simple form, I have a button that, after requesting confirmation (in a
msgbox), launches a sub that takes some time to do the work. I have set the
hourglass to true, and that is nice; however, when the msgbox goes away after
the confirmation, my form is still in focus and buttons enabled. Needless to
say, clicks on it are stacked up until the command finishes... not a pretty
sight.

What is the "standard know" on dealing with this problem? I am thinking a
progress bar would do the trick...

 

[Daniel Pineault]

Below are a few examples on how-to implement a progress bar into your db

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=187
http://www.datastrat.com/Download2.html (the ProgressBar2K example)
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Carlos Martinez]

Thank you so much, Daniel. These examples were very useful, and helped my
obtain what I wanted.

Carlos