Status while running long queries (2003 allSPs)

Topic

New Reply

I have a large number of queries that are run in sequence, some of which take minutes to run. Is there any way I can provide some sort of status as to how far through the process is. Along the lines of”I’m about to start, get 2 beers from the fridge” then “I’m 25% though (or finished all XX updates), you can start on your second beer” – Jokes aside, I am concerned that the user will think nothing is happening because of the time taken, and may close the program
TIA
Steve

Reply | Quote

Replies

What I usually do is to show which query is running via a text control on the form.
eg.

sJ = “Running query 1”
DoEvents
Run “Query 1”

sJ = “Running query 2”
DoEvents
Run “Query 2”

etc etc

Reply | Quote

As Pat suggests, just listing the query is a helpful thing – with a bit more sophistication you can show the status bar and the progress of each query. To get really fancy, you can use an Active X control and show progress in a progress bar or similar tool.

Reply | Quote

Thanks for the info but I cant even spell sofisticated let alone be it!!
At present the queries are just in a macro that runs each one in sequence. The Macro is chosen from a switchboard item. I tried messages in the macro but as these require you to click on OK, it defeats the purpose of letting this loong process run unattended.
Any illumination on either Wendells or Pats approach would be much appreciated
Steve

Reply | Quote

If you really want to avoid any forms or VBA, turn on the Status Bar in the Tools/Options on the View tab – it will show the progress of an individual query. Then you could use a simple Beep command before each query to indicate you are starting the next query. Otherwise, I would suggest you convert your macro to VBA using the wizard, and then put it behind a form which will let you display each of the query names as you run them – and you can still use the status bar to display the progress of each individual query. (The wizard can be found under Tools/Macros/Convert Macros to Visual Basic.)

Reply | Quote