Sharepoint tip

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?



Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: