Set timer event

[amillia]

I need to use the timer event when I run a macro which opens two queries. I need to find out how long it takes to run the macro. How do I do this?

 

[PHV]

In VBA:
tStart = Now
' do your stuff here
tEnd = Now
MsgBox "Elapsed time = " & Format(tEnd - tStart, "h:nn:ss")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886