Setup Multiple Detail Sections on Microsoft Access Reports


Sometimes, when developing a report in Access, one might wish for more than one single Detail Section. Perhaps 22 inches is just not enough, perhaps conflicting settings should be applied to different areas of the section, perhaps a section break could serve as a conditional page break.

There is a simple trick to obtain as many Detail Sections as needed. Well, there is a limit — isn’t there always? — often user-defined sections on any report (and 200″ total height). There is also a prerequisite: the rows must have a unique identifier.

If there is an “identity” field, or a combination of fields that serve as unique key, then you can create a group on that field or fields. Since the key will change for every record, the “group” will contain only a single record, and thus both the group header and the group footer will behave just like the detail section.

For example, if you are designing a complex financial report for your customers, based on the Customers Table, having the field ID as key field, you simply create a group on that field:

* Open the report in design view,
* activate the “Sorting and Grouping” sheet,
* select the field ID as “Field/Expression”,
* (if you have more than one key field, select them one by one on succesive rows),
* set “Group Header: yes” (on the last field of multi-field keys),
* optionally set “Group Footer: yes” for a total of three Detail Sections.

Tip: If you need to sort the records (e.g. by customer name or by country), the sort order must be given at the very top, before the key fields used to create multiple detail sections. That is because in “Sorting and Grouping”, the “sorting” portion cannot be turned off. Naturally, the same is true for real grouping you might need also: they must be created “before”.
Continue reading “Setup Multiple Detail Sections on Microsoft Access Reports”

Add Microsoft Office 2007 Hotfix as Setup Prerequisite with BMG tool


In this article, I will show how to use the Bootstrapper Manifest Generator (aka BMG) tool to build a bootstrap for MS Office Hotfix (You can use similar steps for any hotfix). This tool will help us to build the folder required in the Visual Studio packages folder and it will show in the prerequisite window for the developer to add to its project window.

This list of Prerequisites, generated by Visual Studio, is based on the content of this specific folder:
[Drive:]Program FilesMicrosoft SDKsWindowsv6.0ABootstrapperPackages

Each sub folder in this Packages folder represents a Prerequisite (Redistributable package) and contains the following files:
– Product.xml manifest file
– Package.xml manifest file
– Redistributable files (Optional. If not found, the software will be downloaded over the Internet.)

The Bootstrapper Manifest Generator tool can downloaded from http://code.msdn.microsoft.com/bmg.

We will be generating the Prerequisite for MS Office 2007. A recent hotfix (KB976811 available through KB976477) for Office 2007 allows us to register and load VSTO add-ins under HKLM for Office 2007.
Continue reading “Add Microsoft Office 2007 Hotfix as Setup Prerequisite with BMG tool”

Back up files in Linux to avoid losing important data


Losing files and data, especially precious holiday photos and music downloads, can be a traumatic experience. Like other operating systems, Linux has tools that allow you to back up and restore files when the hard drive or some other component fails.

Simple Backup
This is a simple open source backup software that is easy to use and does its job well. To download and install the software, go to Synaptic Package Manager (System > Administration), search for sbackup and mark the software for installation. Then, click Apply to install the package.

Once installation is completed, launch Simple Backup Config, which can be found under System > Administration. You will then see a range of backup options available to you. In the General tab, choose the recommended settings if you wish to backup user files in the /home, /etc, /usr/local and /var directories on a periodic basic.
Continue reading “Back up files in Linux to avoid losing important data”

Create sample text with Microsoft Word


Do you ever need to create a 20 page Word document for some testing purpose? Are you tired of copying & pasting old boring “lorem ipsum” text over and over again, increasing font size and line space in order to make the document 20+ pages long? Look no further! I will show you a small trick in Microsoft Word (2007 and above) to create a large test document with random text in less than 5 seconds, and then you can impress your colleague or your boss with this little secret trick.
Continue reading “Create sample text with Microsoft Word”

MouseFix.exe solved Optical Mouse Single Click Problem


Have you ever faced a problem with your optical mouse(any brand – specially the lesser expensive ones like: techcomm, frontech, zebronics etc) ? After usage of 7-8 months(the duration differs) many optical mouse users face a problem of multiple clicks(2 or more than 2) on clicking just once. It becomes really hard to control the mouse clicks while browsing. This is a very common problem and I have faced this problem on three different optical mouses till date.

Well, after searching for solutions on many sites I finally found a solution.

Mousefix.exe is a very small free application which you will need to put in your startup folder and which will always run in the background in case your mouse is having the problem i said. It will monitor your mouse clicks and won’t let it make false clicks. For interested people the entire source-code is also freely available.
Continue reading “MouseFix.exe solved Optical Mouse Single Click Problem”