Full Version: determine time between 2 events
UtterAccess Forums > Microsoft® Access > Access Forms
swaziman2
HI,
I have a form that takes a while to open , In the on_open event of the form I have quite a bit of code , I would like to check how long it takes from the beginning of the code to the end....is this something that is possible?
thanks
theDBguy
You could do something like:
im dteStart As Date
Dim dteEnd As Date
Dim intMin As Integer
dteStart = Now()
... rest of your code here...
dteEnd = Now()
intMin = DateDiff("n", dteStart, dteEnd)
MsgBox "This form took " & intMin & " minutes to open."
Hope that helps...
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.