Formats distinguish values in a spreadsheet. You might add a currency character, align numeric values to the right, or change the font type or size for heading rows. The possibilities are endless and most of us go through a phase of formatting everything. Then, we get bored with the process and apply as few formats [...]
Posted on February 22nd, 2008 by admin
Filed under: Tech HOWTO | No Comments »
The number one complaint I have about Word is its dogmatic need to control everything I do. Now, I realize that Microsoft professionals put a lot of thought into Word’s default settings, and I don’t fault them for their choices — well, not too much. On the other hand, some settings annoy me. I could [...]
Posted on February 22nd, 2008 by admin
Filed under: Tech HOWTO | No Comments »
Your Access forms will be easier to use if users can simply type over existing data without having to select it first. By adding a short procedure to each text box control’s OnClick event to select the data automatically, users will not have to take time to click and drag over the existing data.
For example, [...]
Posted on February 22nd, 2008 by admin
Filed under: Tech HOWTO | No Comments »
If you find yourself copying the same paragraphs into your e-mail responses — for example, the same words to send out responses to confirm a customer’s appointment — you don’t have to compose each e-mail reply individually or copy and paste text from a previous e-mail. Here’s how to create an AutoText button in Word [...]
Posted on February 22nd, 2008 by admin
Filed under: Tech HOWTO | No Comments »
If you do not apply a fraction format to a cell before you enter a fraction into it, Excel will convert the fraction into a date. For example, if you enter 1/50 into a cell, Excel immediately converts it to Jan-50. If you then try to reformat the same cell to a fraction, Excel converts [...]
Posted on February 22nd, 2008 by admin
Filed under: Tech HOWTO | No Comments »
We’re all familiar with hyperlinks. By default, Office applications automatically create a hyperlink if you type http://www. They’re convenient, they’re fun, they’re cool — they can be dangerous. Be careful when including hyperlinks in a document. They’re easy to hijack!
Someone you don’t even know can alter the hyperlink and then forward it. The subsequent and [...]
Posted on February 22nd, 2008 by admin
Filed under: Tech HOWTO | No Comments »
A few weeks ago, our buddies over at SFSignal asked a bunch of top-flight sci-fi writers, editors, and bloggers what would happen if, say, a bunch of top-flight sci-fi fans ran Hollywood, rather than the usual collection of business-school rejects and soulless, jaded, film-school burnouts. Now that the Hollywood writer’s strike is over, it seems [...]
Posted on February 22nd, 2008 by admin
Filed under: GeekEnd | No Comments »
I am not sure how the rest of the world reads this, but there is a developing format war. I speak of the push for HD-DVD vs. Blu-Ray. I’ll describe the difference another day but the important issue for the normal person is not the format (yet) but the content on your existing format.
Don’t let [...]
Posted on February 20th, 2008 by pdone
Filed under: Tech HOWTO | No Comments »
There is not a single person who can do all they need to do by themselves. A President, Supervisor, Mother, or CEO needs to do have the help of others to complete their work. A President surrounds themselves with advisers who are delegated authority to complete a large number of important tasks like executing [...]
Posted on February 19th, 2008 by pdone
Filed under: Observations | No Comments »
First, a warm welcome to a number of new subscribers. Over the weekend I updated the list of those receiving updates by email. A reminder this is an email update of a blog I manage which can be found at http://pdone.dyndns.org/paul
Also over the weekend I was working on some GIS Projects a part of a [...]
Posted on February 18th, 2008 by pdone
Filed under: Observations | No Comments »