[AccessD] Resolution of Time call

Gustav Brock gustav at cactus.dk
Tue Sep 27 07:20:10 CDT 2022


Hi Arthur

Use Timer, much simpler. 
It returns seconds since machine launch with about 1/18 s resolution and two decimals:

Dim StartTime As Currency
Dim Duration As Currency

StartTime = Timer
' Run Process ...
Duration = Timer - StartTime

Debug.Print Duration

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces+gustav=cactus.dk at databaseadvisors.com> På vegne af Arthur Fuller
Sendt: 27. september 2022 14:09
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: [AccessD] Resolution of Time call

I'm trying to time the duration of a test procedure. When I set a variable to Time, I get back something like "8:05:31 AM." First, what data type is this? Second, how can I grab just the seconds part?

--
Arthur 


More information about the AccessD mailing list