Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

StopWatch 2

Status
Not open for further replies.

JiggyPoo

Technical User
Dec 31, 2002
66
US
is there a stop watch function in Access?
 
Hi,
There is a Timer function in VBA. Just check the Access help file for more info.
HTH,
Randy Smith
California Teachers Association
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top