Recent content by Sorrento

Thank you, very clear explanations of the many aspects of system time I never thought about before. You clarified a lot of things on how they "normally" work. The different behaviour of the 4 machines remains a mystery. You've helped me to get a better understanding, and maybe the time will...

Ah, I just found the oddest log entries on both machines that did hiccup: 12 hours too late, i.e. UTC+12, which happens to be our time zone in New Zealand, there is a log entry on both these machines that adjusts the time by 1 hour backwards!!! In other words, just after 2 PM (!), the clock...

Interesting and helpful stuff, The_Doc_Man! Thank you! The two machines that did not hiccup: They show a single event each referring to DST change, showing a different from/to time, and both ending in Z. The two machines that did hiccup: They show multiple events each referring to DST change...

This is getting more bizarre as we go. Thank you The_Doc_Man. It's also getting rather technical, so I hope I can grasp your comments and reply in a meaningful manner. My machines are in a home network, no domain server as such. Just a home router which does the DHCP and some local host name...

Thank you The_Doc_Man. A bizarre issue indeed. My app does not use the now() function in a query, nor use a captured value, making it impossible for me to work out why this was happening. What puzzles me also is the Windows 10 Event: "The system time has changed to...

I have not been able to shed any light on why my log timestamp using the Now() function remained unchanged when the system clock went backwards an hour. If I manually change the time or timezone, the Debug.Print Now() correctly reflects the change in time. Can't figure out what happened that day...

Thank you isladogs for the form. Works fine on my Win10 Pro with MS Access 2007, and also on a Win10 Home with MS Access Runtime. Looks like you say, there's something wrong in the application. I'll update here when I find out what it is … Many many thanks to all who helped me get to this point.

Thank you everyone, very helpful, but something at my end seems to differ to produce your same expected results. The Windows event shows the time change: (at 3am back to 2am: end of DST) The system time has changed to ‎2019‎-‎04‎-‎06T14:00:00.006044100Z from ‎2019‎-‎04‎-‎06T14:00:00.006044100Z...

Yes, the log that my application is producing is being identically written to the Immediate window as well as to a file. In the meantime, I found a (perhaps unrelated and quite old [2009]) message stating that .Net is caching the system time as well, and showing the same behaviour. See...

Hi, Today is the day in New Zealand when Daylight Saving Time DST returns to Standard Time ST. I observed in my Access VBA application that at 3am, Windows 10 shifted its time back to 2am - as expected. The VBA code however, which produces a log with timestamped entries using the Now() function...

Thank you sneuberg. yes, I did see that. The code is very helpful, but I think this post left me with quite a few questions unanswered about: Did it actually send the data at the end? Possible in MS Access versions (2007) AND Access 2007 RUNTIME version? Possible in Windows 10 versions (32 + 64...

Hi, I have been searching online for some time now, but not found a clear answer to: Is it possible in MS Access 2007 on Windows 10 Pro (64bit) to have VBA code send and receive UDP? Once developped, I would need to deploy the same code on Windows 10 Home 32bit and MS Access RUNTIME version...