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”

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”

How to Keep Content Fresh and Interesting

One of the hardest things about blogging can arise when the blogger runs out of things to say. As words are what keep your blog going, if your mind goes blank, so will your blog page. While this is a common occurrence, it does not have to be a fatal one. There are some ways to dig yourself out of this problematic hole without losing your blog.

A great way to get fresh content is to invite guest bloggers to your blog. Invite one or as many guest bloggers as you need. Even though you may blog about the same things, everyone thinks differently and has different opinions whether the issues are the same or not. Don’t worry that you will lose your readers to the guest blog as loyal readers will always be interested in what you have to say!
Continue reading “How to Keep Content Fresh and Interesting”

Fix WordPress Internal Server Error

I was writing an article earlier today on Blogging Tips and I received the famous Internal Server Error. When this happens you can still access non WordPress pages on your site and see your favicon however the site is unusable and you cannot access any pages, including the WordPress admin area,

This is the kind of message you will see if you have an Internal Server Error :

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@yoursite.com.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.

Continue reading “Fix WordPress Internal Server Error”

Rotate Screen in Windows 7

The standard orientation of our computer screens is generally horizontal (also known as landscape) but monitors placed in portrait mode (where height becomes greater than the width) can be pretty useful for performing tasks that require lot of scrolling (like reading lengthy web pages).

Windows 7 includes a new option under Display Settings that can help you flip the screen from portrait to landscape mode (and vice-versa) without requiring additional software.

This may come very handy if you are using a dual monitor setup with Windows 7 where you want one screen in the default horizontal mode and other one in vertical mode for reading content.
Continue reading “Rotate Screen in Windows 7”

An easier, faster solution for cross-browser testing with Adobe BrowserLab

Adobe BrowserLab is a new online service that will help you test the layout of your web pages across a variety of web browsers and operating systems.

Comparing web design in Firefox 3.0 & IE 7.0

You can use the Browser Lab service to view the design of your site in Firefox, Internet Explorer and Safari on both Mac and Windows. BrowserLab works by taking screen shots of your web pages in different browsers on different platforms and then displays these screenshot images side by side for easy comparison.
Continue reading “An easier, faster solution for cross-browser testing with Adobe BrowserLab”