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?

cheers

Simon

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s


%d bloggers like this: