Display form during query

[bmoremu]

I have a SQL query set to run and return a recordset from Access to Excel. When the user hits the 'Search' button on the form I hide the search form and would like a small 'Please wait...' form to display while the query is running and then close when the results are returned to Excel. My problem is, I have a loop on the wait form changing the number of '.' after 'Please wait' so that the user knows the query is running. So I'm having trouble having that caption loop run AND the query run in the background simultaneously. Any advice would be much appreciated, thanks!

 

[VBAjedi]

Unless you want to play around with modeless forms (which are only available in the latest versions of MS Office), you won't be able to move the focus off of your first form until your code stops running.

Why not just reconfigure the appearance of your form to display your "Please Wait" message? For example, you could have a multi-page control on your form, and while the query is running you could display the second page (which would have your message on it). Or you could get into showing/hiding controls, resizing the form, etc. Either way, the form containing the code still has the focus, and everybody is happy.

VBAjedi