I'm a MCTS in WSS 3.0 Config

Woot! I'm a MCTS. I passed my "70-631 Microsoft Windows SharePoint Services 3.0, Configuring" exam this morning. Really wasn't as hard as I was expecting. Although I've been doing SharePoint stuff since 2005. Hum, I might have to book myself in for the "70-630 Microsoft Office SharePoint Server 2007, Configuring" exam.

Edit a Sharepoint Page with the Edit Page Link

Have you ever come into a situation where you need to edit a Sharepoint page and the Site Actions or Edit Page links aren't available? I have. Here's a nice quick solution to that issue:
http://abstractspaces.wordpress.com/2008/05/05/trick-the-sharepoint-query-string-url/

In summary you need to add the following query strings to the end of the page address:
Add Web Parts/Browse ToolPaneView=2
Add Web Parts/Search ToolPaneView=3
Edit Mode mode=edit
View Mode mode=view
Shared Mode PageView=Shared
Personal Mode PageView=Personal

Installing Vista drivers on Windows 7

I've just moved from XP to Windows 7 64 bit. Some of the hardware wasn't 100% supported. My Logitech QuickCam Orbit was one of them. The only software available was for Vista x64. The software won't install on Windows 7 x64.

So here's the workaround:
Install 7-zip.
Download the Logitech Quickcam Orbit Vista x64 driver.
Right click the downloaded file (qc1150.exe).
Go to 7-Zip > Open Archive
Then extract the files somewhere.
Open up the extracted folder.
Go to QuickCam > x64
Double click QuickCam.exe
The driver is also there but Windows 7 should have already loaded it.

Good luck! If you need a hand drop me a comment.

Sharepoint Datasheet View + Office 2003 Pro + Office 2007

I've been scratching my head over this one for a little while and was motivated today to fix it. So here it is.

My office has MS Office 2003 Professional and MS Office 2007 installed.

And we obviously use Sharepoint.

Users who try to get into the Datasheet view would get the following message:
"The list cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled."

Users who try to open the list in Excel get the following:
"The Column_name column is a read-only column that cannot be modified."

If you get those above symptoms. Try checking this KB:
http://support.microsoft.com/kb/952608

It worked for me.

Good luck

WSS 3.0 and MOSS SP2 Released

As the title says. A new service pack has just been released for WSS 3.0 and MOSS.

WSS 3.0 SP2

MOSS SP2

Infopath: Displaying the Outlook email fields

I've been struggling with this for a little while. I found this MSDN article:
http://msdn.microsoft.com/en-us/library/microsoft.office.infopath.mailenvelope(VS.80).aspx

Which stated that I should be able to:
// Set a reference to MailEnvelope object.
MailEnvelope myEnvelope = this.Application.ActiveWindow.MailEnvelope;

But for the life of me the MailEnvelope wasn't there in my Infopath form.

That was until I turned off Browser compatibility:
Uncheck the following setting:
While designing the form > Tools > Form Options > Compatibility > Design a form template that can be opened in a browser or Infopath

After disabling this setting the EmailEnvelope became available and I could open the Email panel and set all the values (To, cc, subject etc).

All I have to figure out now is if I can catch the send event and close Infopath.

Infopath: Getting the Form Version in C#

It took a bit of hunting so I thought I should post it up for next time.

To get the Form version of the Infopath template use the following code:
this.Template.Version

Here's a sample of what I did:
XPathNavigator nav = this.CreateNavigator();
string formVersion = this.Template.Version;
nav.SelectSingleNode("/my:FormVersion",
this.NamespaceManager).SetValue(formVersion);