jwcolby54
Member
- Local time
- Today, 04:21
- Joined
- May 19, 2025
- Messages
- 123
Very cool. I will put that in now. Which of course brings up having to explain compiler directives.Hi John,
I'm a big fan of classes and I'm enjoying your work so far.
One thing I noted was in the very beginning you have a timer class which uses an Api. I run 32 bit at home and 64 bit in the office. Had to change the dec's use it.
Code:#If VBA7 And Win64 Then ' Declare for 64-bit Office Private Declare PtrSafe Function apiGetTime Lib "winmm.dll" Alias "timeGetTime" () As LongPtr Private lngStartTime As LongPtr #Else ' Declare for 32-bit Office (or older VBA versions) Private Declare Function apiGetTime Lib "winmm.dll" Alias "timeGetTime" () As Long Private lngStartTime As Long #End If
That change is made to both the book and the database. The DB itself is pushed to Github. And the book is too now.
GitHub desktop is really slick for helping me manage this stuff.
Last edited: