In this video, I show you how to create a drilldown system using SQL Server Business Intelligence Development Studio 2005:
This tip shows you how to use VBA to alternate the row color of an Access report. Many times, when creating a report, we find it hard to read the details. By alternating the row color we can make life much simpler:
Here’s a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here’s the solution!
Here are some nice tricks on how to quickly insert formulas in Excel. Forget all that dragging of the fillhandle and stuff. With these tricks you will be inserting formulas in no time.