Many people have reported left (or other) margins being cut-off when printing HTML messages from Outlook XP / 2003.

Changing the page setup in Outlook proves useless because HTML messages are not printed by Outlook itself – it uses IE’s print settings to print.

So if your margins are off you must change them within Internet Explorer to fix the problem.

1. Open Internet Explorer
2. Go to “File” in the menu bar
3. Choose “Page Setup”
4. Under “margins” all margins should be set to 0.75 inches

For Plain Text and Rich Text emails within Outlook, go to File and Page Setup from within Outlook and set the margins to 0.5 or 0.75 inches.

(No Ratings Yet)

11 Comments |  Print This Post |

I have found the need to account for duplicates and the number of duplicates in many databases. I’ve come across many people who have a minimal understanding of SQL and create wild php scripts to find duplicates, when really all that is needed is a single SQL statement.

Where COLUMN is the column (all the same) you wish to find duplicate entries for. It will display the number of duplicates as an integer in descending order grouped by each entry in the COLUMN column. TABLE is the database table you wish to analyze.

Ex. Find the number of instances of the same name in an employee database:

(average: 5.00 out of 5)

5 Comments |  Print This Post |

The thumbs.db file caches photo thumbnails in a directory for quick viewing when you browse that particular folder. I always like to turn this feature off since I often mirror directories across FTP servers that contain many photos. The thumbs.db is needless bandwidth and also plays with the synchronization settings. Be aware that turning this feature off does slow photo thumbnail viewing within folders.

To turn this feature off:

1. Control Panel -> Folder Options -> View -> “Do not cache thumbnails”
2. Search for “thumbs.db” in your drive and delete all thumbs.db files from the search window.

(No Ratings Yet)

No Comments |  Print This Post |

DOS and Windows allocate resources and use printers differently, so having a shared printer on LPT1/LPT2 in Windows may not work as LPT1/LPT2 in DOS.

1. Click “Start”, then “Run”, and type: cmd
2. Press OK.
3. At the command prompt type:

Where # is 1 or 2, COMPNAME is the name of the computer the printer is connected to, and PRINTER is the shared name of the printer (Pre-Windows 2000 name).

Ex.

To delete the printer type:

(No Ratings Yet)

1 Comment |  Print This Post |

With Windows XP many DOS programs only display in the top half of the screen when run in full screen mode. Follow the steps below to have the DOS window display properly.

1. When in the DOS program full screen, press ALT-ENTER.
2. Right-Click on the title bar of the DOS window and select properties.
3. Click the layout tab and change the height of the screen buffer and window size to 25.
4. Click the screen tab and select Full Screen and click OK.
5. A dialog box will pop-up and ask to “save properties for future windows with same title” select this and click OK.
6. Enjoy!

(average: 4.00 out of 5)

10 Comments |  Print This Post |