When you create a new site in Sharepoint set the time zone before you add hundreds of events ;-).
I spotted an advanced VBA course in my Outlook Calendar at 2:00 AM. Whilst we all know what a keeny I am, I suspect not many delegates would have made it!
Easily fixed though – I made a full copy of the SP list in Access, corrected the SP site time (which changed all the event times by 8 hours) then did another update query to apply the old times over the new.
I love the power of a server product with the richness of Acces as the client – shame they messed up the Access UI even more than Excel, but hey ho.
I suppose I wouldn’t need the rich client if I didn’t mess up so often. but if you’re not falling you’re not learning, right?
cheers
Simon
Leave a Reply