Providing feedback on data refresh form SQL Server

[RRinTetons]

I have a button handler that connects to a SQL Server back end, calls to sp's to update two summary tables and then refreshes lookup tables in the workbook. The whole process can take as long a 2 or 3 minutes.

How can I let the user know that a) it's working, and, b) what stage its at (which one of the updates it's doing), and, c) when it's done?

-
Richard Ray
Jackson Hole Mountain Resort

 

[xlbo]

easiest option would be to use the Statusbar

application.statusBar = "Updating Table1...."

application.statusBar = "Updating Table2...."

application.statusBar = "Refreshing Lookup Tables...."

application.statusBar = "Returning Refreshed Data...."

application.statusBar = false ' return to default state

There are other options including a modal form or even modifying the statusbar to show inremental progress but both of these options require a lot more code

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Look at VBA Help on StatusBar Property. It will give you a good example of initializing and finalizing this process gracefully.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}