In this screencast, Laura Rogers demonstrates a way to open a SharePoint list in Access, along with the UserInfo table from the site.

When we first started our SharePoint development efforts we had a requirement to write an application to track issues and projects as well as log time against them. All of our development had to be Out of the Box because of the development constraints with Custom development and well, because at the time we didn’t really know what we were doing. However, a couple of things came out of this development effort which I think will actually come in handy. One of these was creating a Parent / Child relationship between lists so that we could track hours for a project or issue.

A very common request for changes to SharePoint list views is how to set the column width. This is not possible to do using the ootb “List Settings”, and the common suggested fix is to use SharePoint Designer (SPD) and convert the view into an “XSLT Data View”: How can I manage columns widths in list views? Most large companies do, however, prevent the use of SPD.

SharePoint Designer (SPD) has been free from Microsoft since April. In those two months, some lines have been drawn in the sand. Some users are of the opinion that it should be completely locked down and not allowed in the organization. Others have the view that it makes everything better. Still others aren’t even sure what value it could possibly bring. It is free, so you get what you pay for, right? Not always!

When creating data view web parts in SharePoint Designer, and dealing with libraries or lists that contain folders, the Item and Folder Scope setting becomes pretty important. In SharePoint views, it’s always possible to create a new view of the list with no folders, by configuring the “Folders” section in your view settings. Unfortunately, the same functionality is not as obvious in SharePoint Designer. When you create a view with no folders, and then convert it to XSLT in SPD, the folders always reappear.

Since this initial article is really just to show you around in the DVWP, we’re not going to do anything fancy. We’ll just insert a regular SharePoint list as our data view. See, that now on the right side of the screen, there is a “Data Source Library” pane. 8. Now, in the pane on the right side of the screen, instead of the “Data Source Library” tab, you’ll see the “Data Source Details” tab, that shows the details of the source that was just selected. This means, that all of the fields in the list are displayed. There are even some extra fields listed there, that are usually hidden from views

This is an introduction to my new series of articles on the SharePoint 2007 data view web part (DVWP). These web parts can only be created using SharePoint Designer (SPD). Now that SharePoint Designer 2007 is free, this opens the door to a lot more people being able to create these web parts, widening the intended audience for these articles. What are these new DVWP articles all about? Well, various things. Usually I get ideas for blogs and articles that I write, from questions that people ask on forums. Some of my articles will actually be combinations or mutations of several different business solutions. These articles will contain easy to understand, step-by-step instructions. Most of them will pertain to WSS (Windows SharePoint Services) implementations, and every now and then, there will be some that pertain to MOSS only

Single tickets for the EndUserSharePoint.com live online Train the Trainer: Lists and Libraries are now available.
Train the Trainer is a series of workshops helping build in-house training communities. The workshop provides participants with a set of training materials as a base to build in-house training for Information Workers. Included in the series are all [...]

Browsing through some SharePoint stuff this morning I came across this JavaScript add-in for embedding videos into SharePoint list items.

In this screencast, Lee Reed covers the basic processes for multiple types of deletion in the SharePoint interface. This should turn out to be extremely valuable to the beginning SharePoint Site Manager.