Jan 10, 2003 1 #2 randysmid Programmer Dec 12, 2001 801 US Hi, There is a Timer function in VBA. Just check the Access help file for more info. HTH, Randy Smith California Teachers Association Upvote 0 Downvote
Hi, There is a Timer function in VBA. Just check the Access help file for more info. HTH, Randy Smith California Teachers Association
Jan 10, 2003 1 #3 SBendBuckeye Programmer May 22, 2002 2,166 US In Declarations Section Public Declare Function GetAPITimer Lib "winmm.dll" _ Alias "timeGetTime" () As Long Sub(s) or Function(s) Dim lngTime As Long lngTime = GetAPITimer() '<== First call to start it MsgBox (GetAPITimer() - lngTime) / 1000 '<== End it Calculates in milliseconds and resets every 49 days if I remember correctly Good Luck! Upvote 0 Downvote
In Declarations Section Public Declare Function GetAPITimer Lib "winmm.dll" _ Alias "timeGetTime" () As Long Sub(s) or Function(s) Dim lngTime As Long lngTime = GetAPITimer() '<== First call to start it MsgBox (GetAPITimer() - lngTime) / 1000 '<== End it Calculates in milliseconds and resets every 49 days if I remember correctly Good Luck!