Not Responding Message when running a report...can I use VBA?

[DB_Michael]

I have a report that is run from a form using a button. This report (and underlying query) takes some time to complete, resulting in the Not Responding message. I have seen articles on using DoEvents but frankly I am not sure how to use it in this case. Should the DoEvent be on the button on the form or on the report itself? I have very basic knowledge of VBA, and am wondering how to format the code. A counter or progress indicator would be helpful but not absolutely necessary.

[ranman256]

if the report is a single query then a progress indicator wont work since the query must complete before it can update Progress control.
you cant: pause the query, update control, continue query.

[DB_Michael]

Thank you, that is what I thought, the report is based on a single query. User will have to be patient

[Micron]

Maybe your query can be optimized. I can't recall using it, but there's this
https://support.microsoft.com/en-us/...b-30b86082d792

Probably lots like this out there
http://allenbrowne.com/QueryPerfIssue.html

[isladogs]

Here's another page on Optimising Queries Speed Comparison Tests 8 (isladogs.co.uk)

[DB_Michael]

Thank everyone for the information. I have been able to speed up the query by about 1/3. I also added the DisplayHourglassPointer = Y before running the report and then set it to "No" after running the report. The error message does not display on the top of the application but does appear on the form the is used to launch the report and user knows that something is processing. Not the most elegant solution but it works.