[AccessD] uSecond timing

Stuart McLachlan stuart at lexacorp.com.pg
Wed Sep 2 16:31:20 CDT 2020


LongLong only works with 64bit VBA.  A lot of people are still using 32bit Office.

An alternative:using a UDT LongInteger

https://stackoverflow.com/questions/198409/how-do-you-test-running-time-of-vba-code




On 2 Sep 2020 at 17:24, Gustav Brock via AccessD wrote:

> Hi John
> 
> To prevent the scaling up/down of Currency he suggests, why not use
> Decimal which, in VBA, isn't buggy at all, or simply LongLong which is
> a 64-bit integer?
> 
> Looking forward to your video. I always wonder where people find the
> time to experiment with such things.
> 
> /gustav
> 
> ________________________________
> Fra: AccessD <accessd-bounces at databaseadvisors.com> på vegne af John
> Colby <jwcolby at gmail.com> Sendt: 2. september 2020 18:42 Til: Access
> Developers discussion and problem solving
> <accessd at databaseadvisors.com> Emne: [AccessD] uSecond timing
> 
> I got a class implemented to do uSecond timing as opposed to the
> normal mSecond timing.
> 
> Based on;
> 
> https://rotchvba.wordpress.com/2016/12/12/a-high-resolution-timer-in-v
> ba/
> 
> I am preparing to do my very first YouTube video ever.  I'm doing a
> crash course on OBS Studio now.  Once I get the first video figured
> out, then I hope to do one weekly or so.  About (what else) how to do
> OOP in access. And the first lesson will use a timer class to
> demonstrate why you would use a class and how to do so.
> 
> Ease us all into the subject. 
> --
> John W. Colby
> Colby Consulting
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list