Macro that shows Start and Stop times of queries

[Dave Smith]

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

[pod]

starttime = now
 
' the beginning of the macro 
...
...
...
...
'end of the macro
endtime = now
 
msgbox "start time " & starttime & vbcrlf & "end time " & endtime  
 

[Dave Smith]

Thanks POD, what would i select for the action in my macro. I tried typing just "starttime = now" but it wouldnt let me.

Thanks again for your help
TCB

[pod]

I am not certain where you are trying to write this.... there are probably more than one way to do what you want.

The way I do it, is in the VBA editor: in there you can write the code in Modules or directly behind the Form in an Event Procedure of the Form or any Form Element such as "OnLoad", OnClick...

If this is new to you, I suggest read up on this. A keyboard shortcut to display the VBA Editor for Access or Excel for that matter is Alt-F11


... does that help you in any way?