Macro that shows Start and Stop times of queries

[TBC]

I know there is away to in a macro show the start and stop times of the actions/queries that run in a macro.

Could someone please remind me how this is down again?

Thanks for your help
TCB

 

[SpentGeezer]

Chuck something like this in before and after action1

Dim Action1Start
dim Action1Finish

'about to start action1 so...
Action1Start = Now()

'code for action1 goes here
'code finishes here

Action1Finish = Now()

msgbox "Action1 started at " & Action1Start & vbnewline & "Action1 Finished at " & Action1Finish

 

[TBC]

I dont quit follow, would I just place this code in a vba

 

[SpentGeezer]

Yep, put it in the macro