Visual Cue That Macro is running?

[cterjesen]

Is there a way (a visual cue like a status bar or something) to have the user of my database to know that a macro is still running and/or when the macro is finished running?

Thanks!

 

[Tanis]

What does the macro do?

 

[cterjesen]

The macro uses the TransferSpreadsheet action to import data from a number of different Excel files.

 

[Cbrine]

cterjesen,
Using the macros in Access you can turn the hourglass on or off. You might want to use a macro to turn on the hourglass, do the transfer spreadsheet, then turn the hour glass off again.

HTH
Cal

 

[Tanis]

Change the Hourglass to No in Actions of the macro. To stop warning messages from coming up set SetWarnings to No, but don't forget to set the Setwarnings back to Yes at the end of the macro.

 

[kevinnichols78]

Another option would be to create a form that is displayed while data is processing. Your code would look something like this:

Sub Form_Load()
updatingLabel.caption = "Please wait, updating."
End Sub

Sub After_Update()
updatingLabel.caption = "Update complete. Formatting data."
Call Format_Routine
updatingLabel.caption = "Done."
Docmd.close
End Sub

That would display different messages during different parts of your process and then close the form once your processes were complete.

Kevin