I forgot how to check time elapsed (Second(time())?

[steve728]

What code do I use to determine how long a MS Access 2000 process takes?
The following doesn't seem to be accurate:

mStart = Second(Time)

Lengthy processing code...........

mEnd = Second(time)

Msgbox " Time elapsed = " & (mEnd - mStart) / 60

Please help me.

Steve

 

[VBAjedi]

Well, your approach would create problems if the process starts in one minute and ends in another. I dont work much with Access, but try just using Time:

mStart = Time

Lengthy processing code...........

mEnd = Time

Msgbox " Time elapsed = " & (mEnd - mStart) / 60


VBAjedi

 

[steve728]

Thank you so much for your help and speedy reply. All you guys are the greatest. You make life and our jobs much easier.

Steve