Team-Based Development in Microsoft Office SharePoint Server 2007
Learn to properly conduct team-environment development of Microsoft Office SharePoint Server 2007 sites and assemblies (Web Parts, site templates, custom list templates), as well as develop Microsoft Office SharePoint Designer artifacts (master pages, workflows, CSS sheets). (13 printed pages)
Eric Charran, Microsoft Corporation
http://msdn2.microsoft.com/en-us/library/bb428899.aspx
This is a newbe question I get a lot. It's a really basic request but many people don't know about.. I even saw custom developments to overcome this when you already have this Out Of the Box!
The question is: 'Can we filter a list by a range of values?'
Say you have a list of tasks. You know you can filter the list to show only tasks that are due to a certain date, but can you filter it to show all the tasks that are due to this week? Sure you can create a view and specify a complex filter but then the values are hard coded into the view, and we want to allow users to pick their own range values. Although it is quite hidden in the UI, and is pretty limited, it is possible Out Of the Box.
Here is how you do it:
With the list opened, go to datasheet view.
Then, click the column you want to filter by, and choose '(Custom Filter...)'
In the dialog box you can enter filter that are not necessarily of the 'equals' operator, like shown in the picture below.
So, If you want are range of values, just use the 'is greater than' and the 'is less than' operators somehow like this:
This results in a view the shows only tasks with due date between June 1st and 7th. (click to enlarge)
That's it, simple and usefull. If you want some more complex queries, and don't want to develop a custom solution, you can purchase the Bamboo solutions list search WP.
For those of you who have been waiting for this, its here.
As for now its a beta version and available only in the professional edittion.
Here is a a link to Nick Swan's original post. Enjoy!
This is really wierd but after installing VM additions on my VPC2007, the mouse cursor just disappears when it hovers over a text field and this is really annoying!
The only reference that I found was this discussion. That guy called Paul Adare suggested to change the mouse pointers color scheme to black.. and guess what, it works!
In fact, changing it to anything else but the 'Windows standart' scheme will do the job.
Great tip, thanks.