Progress/Status Bar on Form

[Tomfernandez1]

Greetings,

I have a Form with a command button that when executed will copy a database from one location and pastes it into another location. This command usually takes up to 20 seconds to complete. During that time, I would like to show a progress bar on the Form, so users know that work is being done behind the Form.

Any ideas for how this can be done? I have little VBA knowledge.

I currently use 2003 Access. Your help is much appreciated!

Tommy

[alansidman]

Tommy;
See if this helps

http://msaccesstips.com/2008/01/progress-bar-on-form/

Alan

[ajetrumpet]

also do make sure to make the form modal. otherwise the users might start clicking around everywhere. clicking a lot when something is processing will always confuse the processor even if the clicks are just on the screen in various places. clicking is a command regardless of where you click.

ms also has an article on how to do it with timers here: http://support.microsoft.com/kb/304581

[Tomfernandez1]

Adam - I was able to insert the Progress Bar Control, Version 6.0, but I have no idea on how to use it. Essentially what I need is for the Progress Bar to run while the command is running. Might you have a sample code that I could use?

-Tommy

[alansidman]

Tommy,
My posting had sample code and downloadable examples.
Alan

[Tomfernandez1]

I see. Perfect! Thanks for the help!
-Tommy