Adjust White Balance

	Adobe Photoshop
	Figure 1: Image with Poor White Balance
	Have you ever been disappointed by a batch of photos that you thought were great when you took them, but later, they look only so, so? Even a little drab or dreary? Maybe your white balance wasn't set correctly. This article is to help you after the fact. I will post another that will help you set the camera up correctly

Cute Little Word Tricks Part 1

	Microsoft Word
	Trick #1 The Change Case Option
	There are several reasons that this trick may come in handy. You accidentally have the [Caps Lock] turned on.

Select Columns From Another Sheet With VBA

	Microsoft Excel
	(Figure 1) Control Sheet with Command Button and Yes/No Criteria
	Problem: You want to use VBA (Visual Basic for Applications) in Microsoft Excel to hide columns in a different sheet than the one with the controls. Solution: This example works with Excel 2003 or 2007. It uses a workbook with three worksheets named Control, Labor, and Report. (See Figure 1)

MS Access Record Navigation Keys

	Microsoft Access Record Navigation Keys
	This is a basic topic, but I have found many people that are unaware of this feature. When using a form in MS Access (any version: 1997 or later) a navigation toolbar is displayed by default at the bottom of the form, as seen in Figure 1. These buttons are quite self evident, but here we go starting from the left:
	Figure 1: The Record Navigation Bar
	First Record Button: This moves the record pointer to the first record in the table and the data is displayed. (In some versions of MS Access) If you are already positioned on the first record, this is

Compact and Repair Your Database

	Microsoft Access
	This came up again, so I thought I would share it with you. As an Access database is used and records are both added and deleted, the datbase grows. BUT, the allocated space (on disk) for any deleted records is not actually removed. For example: You have a table with 5000 records and you go through and clean up any outdated or obsolete records. This seems like it should help make the database as a whole perform faster and more efficiently. However, if you look at the total size on disk before

Number Field Loses Decimals

	Microsoft Access
	Problem: A field created in Access (2007) is specified as a number with two decimal places (non currency). When data is entered, it rounds to the nearest whole number. This may still occur with the decimals showing as .00 Solution: This is not a difficult problem, but can be really frustrating if you do not know the correct combination of field properties. The problem is in the definition of the field. The example below is for a field to hold the

Gone Phishing

	A Phishing Scam is an email message sent by unknown persons that are looking for valid email addresses to sell to spammers. The way they do this is to send you a message that looks too good to be true. The message will ask you to go one of several things, any of which tells the 'Phishers' that your email address is valid. call a phone number, they will ask for your email address. click a link within the message (this promises something that is rarely delivered) open an attachment go to a certain website and enter your email address etc. This situation can result in:

Vista Wireless Connection, Local Only: SOLVED

	Figure 1: Connected to Router only
	Works in Safe mode or normal mode In my PC Cleanup/Virus removal/Performance tuning work I have seen several PCs and Laptops that don't/won't connect to the Internet with the System Tray message:

The Windows Registry and Registry Cleaners

The windows registry is a vital system file that is basically a large list of every program or data file/document that was ever installed using the standard windows installation program (msi).

Think of the windows registry like a big phone book. It lists programs and settings for anything you install or create on your PC.

Most uninstall utilities leave fragments behind in the registry. When something is not completely and cleanly

Speed up your Computer - USE Extreme Caution !!

Caution !! Caution !! Caution !! Caution !! Caution !! Caution !! Caution !!

DISCLAIMER !!

This is a set of steps I copied from techpirates . com
Here is the exact link:

TechPirates Posting

Don't use most of those listed on their link if you don't want to totally mess up your Windows installation.....

I have included (and Renumbered) only those that are easier to do and less harmful if you don't/can't follow

Protect your PC part 2

Forwarded Email Messages

There are some very funny, cute or shocking emails passed across the Internet everyday.

There are also some very dangerous viruses passed across the Internet everyday.

A lot of the time they are linked together.

Protect your PC part 1

This post will discuss the evils of viruses and malware that can come from social networking sites.

As you know I clean individual and corporate PCs that get bogged down, locked up or incapacitated from viruses, spyware and other malware.

I try to get as much history of the problem as I can before I begin. Too many times the

Welcome to...SPAMmmalot

	Figure 1: Never heard of Chris Newton..
	Ok, just for fun... Here is a link to a youtube video of a legomation version of Monty Python's Holy Graile Camelot musical number: "Welcome to Camelot!" Hence the name of this blog. (video opens a new window) Back to the topic at hand.

Our Files Are Back!

Hey Stuart,

Our computer is running great! Thanks for all you did and for getting the files back! We are really enjoying having our computer back up and running.

Sincerely,

DCH
Idaho Falls, ID

Young people will love this

The cups and water visual aid was wonderful! That was one of the best object lessons I have ever seen.
That explained your point so well. Anyone can easily understand what you were teaching. Very good!
HJB

Idaho Falls, ID

Wow, That Was Great

My Father had Taught me some of these same financial topics, but several things you taught today became very clear.

You are very good at explaining things.

M.B.

Idaho Falls, ID

Always a Pleasure to Sit in a Class with Stuart

After I left I realized I had a recording device in my pocket.
I sure wish I had used it!

T.S.
Idaho Falls, ID

That Was Awesome

Thanks, Stuart.
That was a very amazing presentation.

R.S.
Idaho Falls, ID

His Work Was Exceptional!

July 9, 2009
"To Whom It May Concern:
Earlier this year my office contracted with Stuart Purser of Purser Consulting Services, Inc. to complete some database work for us. He had to manipulate a very complex database to produce a merged letter for 2000 students. This letter was composed of information derived from many of the tables in the database.

I was so very pleased with Mr. Purser`s work. He was fun to work with, yet very professional. His database knowledge was

You Made My Day

"I was very put out... the Internet connection for my PC had suddenly stopped. My wife`s laptop could connect just fine..

I called Stuart at Purser Consulting Services and he came over later that same day.
Not only did he quickly fix the Internet connection, but Stuart solved 5 other problems I was having all in one and a half hours...

You made my day!"
M.C. Idaho Falls

Thanks So Much

"Stuart is the most awesome teacher! He is patient, knowledgeable and just a super guy. Thanks for all your help."
Anonymous - Eastern Idaho