How To Link Progress Bar

[jereece]

I am trying to implement the progress bar from this post.

I have a form (frmMain) with a button to launch my report (rptRoutineCA). The report is based on a query (qryRoutineCA). The query / report usually takes anywhere from 15 seconds to 3 minutes to run depending on which group I select the report for. My question is how to I call the Progress Bar so that it runs in front of the report that is building and how to I link the Progress Bar to show the progress of the query / report that is building?

I appreciate the help.

Jim

 

[gemma-the-husky]

i dont think so

to use the progress bar, you have to be able to calculate how far you have processed

so if you have 10 queries to run, you can advnace the bar 10% each time query.

--------------------
therefore i dont think you can update a progress bar within the middle of a single query - just put the hourglass up and wait. 3 minutes sounds too long though

 

[jereece]

Something makes this example progress bar slowly progress then go away. Is there a way I can slow it down, then not go away until my query is complete?

The reason this query takes so long is that it is calculating the number of times each record's "due date" has been reset. So sometimes there are thousands of records with a number of due date changes, so it has to count all of these for each report. If you have any suggestions on how to speed this up, I would love to hear it.

Thanks for the help.
Jim

 

[RuralGuy]

Dave's ProgressBar example uses the timer event of that form and has a constant at the top of the code module that he noted can be changed to change the speed of the progress bar. It sounds like you have one query that takes a long time. Since Access is single threaded, it can only do one thing at a time. As Gemma suggested, if you can break down your task into smaller parts then you could give the ProgressBar some time to update between tasks so the user knows the machine is not dead.