How can I put a message box with a progressbar?

[Daniel]

Hi,


I am trying to show a message box that shows a progressbar
while the database is performing its actions.

Example, I have a print queue. When the print out button
is clicked, I want to show a message box that shows a
progress bar of how much percent mdb has sent to the
printer.

Also I have a copy records button. When this button is
clicked it asks the user how many copies of the record it
would like to copy. So if they say 20 copies (each
created with a unique id), while the access does the
copying a message box will pop out a show its progress
status.

Would i need threads to do the copying and the message box
at the same time? And if so how?
Does anyone know how to do this in VBA? Please help!

Thank you.

 

[Dev Ashish]

Would i need threads to do the copying and the message box
at the same time? And if so how?
Does anyone know how to do this in VBA? Please help!

You're limited to defining your own progress form. VBA/Jet run on single
threads, so I wouldn't suggest creating new ones as you will most likely
run into problems.

Try the ProgressBar sample at

[ http://www.mvps.org/access/resources/downloads.htm ]

-- Dev