Pupuweb

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”

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”

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”

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”

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”

If the hacking group called iPhone Dev-Team won’t release their Jailbreak, it seems like someone else will. Developer George Hotz has released the Purplera1n jailbreak software for iPhone 3GS and by all accounts, it seems to work.
Continue reading “Purplera1n jailbreak software for iPhone 3GS”

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”