Office Tips and Hints Blog

↑

Home Page

Host your Web site with PureHost!

Sunday, May 31, 2009 – Permalink –

Unicode and other Characters

Why's A 65?

Underlying the intriguing prose spread across the monitor screen are numbers and more numbers.

Joel Spolsky, a New York software developer has written a combination history/tutorial about this numeric-literary liason.

He calls it:

"The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!)"

Unicode and Character sets

[Edited entry from 4/11/2006]

See all Topics

Labels: Expression Web, FrontPage, HTML, Word

<Doug Klippert@ 3:00 AM

Comments: Post a Comment

Saturday, May 30, 2009 – Permalink –

Free Articles

Choose a topic

Dave Paradi has written a number of articles about PowerPoint presentations. If you are putting together a newsletter or documentation for your company, you might want to see this list of topics.

You can reprint them with attribution.

Here is a selection:

Would you do business with your own company?
When Should You Use PowerPoint?
PowerPoint Does Not Make You a Speaker
How many slides is too many?
How to Get Better Images on Slides or Web Sites
How to Select and Use Fonts on Presentation Slides
How to Write Powerful Bullet Points
Using Graphs and Tables on Presentation Slides

PowerPoint Articles

[Edited entry from 4/10/2006]

See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:00 AM

Comments: Post a Comment

Friday, May 29, 2009 – Permalink –

Report Manager

Define Print & View Areas

The Excel 2000 Report Manager add-in is not included with Excel 2002+, as was the case with previous versions of Excel.

To use it, you must first download the Excel 2002 Report Manager add-in from Downloads on Microsoft Office Online. Follow the instructions on the Downloads page to install the Report Manager.
(For 2007 see Support.Microsoft.com)

from Microsoft Office Online

"Using the Report Manager add-in program, you can combine worksheets , views (a set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.), and scenarios (a named set of input values that you can substitute in a worksheet model.) into printable reports. For example, if you have a Best Case and a Worst case scenario, a Summary view, and a Details view, you can create a report that presents the Best Case scenario in the Details view and another report that presents the Best Case Scenario in the Summary view. Reports that you create are automatically saved with your workbook so that you can print them at any time."

Note If the Report Manager is not available on the View menu after downloading the add-in, click Add-ins on the Tools menu, and then select Report Manager.

You can use the Report Manager to do the following:

Create a report for printing

On the View menu, click Report Manager.
Click Add.
In the Report Name box, type a name for the report.
In the Sheet box, click the sheet you want to use for the first section of the report.
Do one of the following:
- To use a view for the first section of the report, select the View check box, and then click the view in the View box.
- To use a scenario for the first section of the report, select the Scenario check box, and then click the scenario in the Scenario box.
Click Add to enter the view or scenario as a section in the Sections in this Report box.
Repeat step 5 and 6 until you've created all of the sections you want in the report.
To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.

Note Microsoft Excel prints sections of a report in the order in which they're listed in the Sections in this report box.

Edit a report for printing

On the View menu, click Report Manager.
In the Reports box, click the report you want to edit, and then click Edit.
Do one or more of the following:
- To add a new section, click the sheet, view, and scenario you want under Section to Add, and then click Add.
- To delete a section, click the section in the Sections in this report box, and then click Delete.
- To change the order of the sections, in the Sections in this report box, click the section you want to move, and then click either Move Up or Move Down.
- To number the pages of the report consecutively, select the Use Continuous Page Numbers check box.
Note Microsoft Excel prints sections of a report in the order in which they're listed in the Sections in this report box.

Print a report

On the View menu, click Report Manager.
In the Reports box, click the report you want to print.
Click Print.
In the Copies box, type the number of copies you want to print.

Also see: Template Wizard with Data Tracking

[Edited entry from 4/9/2006]

See all Topics

Labels: Excel

<Doug Klippert@ 3:30 AM

Comments: Post a Comment

Thursday, May 28, 2009 – Permalink –

Time Flies Like an Arrow

Fruit Flies Like a Banana

Human Clock
TimeLine
Cable Clock
( See cable-clock under F7 Velocity on the left side)
Barcode Clock
Money Clock
Official US time
Mouse Clock
Clock Link

Here's a collection of clock sites.
There are also links to code to add a clock to your web site.

Internet Clocks, Counters, and Countdowns

[Edited entry from 4/7/2004]

See all Topics

Labels: Addendum, Internet

<Doug Klippert@ 3:05 AM

Comments: Post a Comment

Wednesday, May 27, 2009 – Permalink –

Grammar Rules!

Could Of or Could Have?

This web site sells a grammar and spell checker, but they also have a compendium of rules for free.

"Looking for a specific rule to help you in your writing? Trying to decide between two similar words? A grammar checker helps you, but does not tell you why. Grammar checkers also miss many errors, especially those having to do with names, punctuation, sounds, and style.

Some of you may have a full grammar textbook stored on your disk somewhere, but it is a nuisance to access and use.

Grammar Slammer takes care of both problems in an easy-to-use format. Grammar Slammer contains the rules and tips you need to write your best and make yourself clear. Grammar Slammer uses the familiar Web Page format to make it easy to find what you are looking for. It even has an easy-to-use glossary to help with those grammatical terms you can't remember. It will truly Slam your Grammar Agony!"

Grammer Slammer

(Could of does not exist. Neither do should of, will of, or would of as verbs.)

[Edited entry from 4/6/2006]

See all Topics

Labels: Word

<Doug Klippert@ 3:17 AM

Comments: Post a Comment

Tuesday, May 26, 2009 – Permalink –

Name that Range

How to use names in Excel

Named ranges are one of the more powerful tools in Excel.

Jan Karel Pieterse of JKP Application Development Services has written a tutorial that will help you understand this technique.

Here are some of the chapter titles:

How To Define Range Names
How To Use Range Names
Absolute And Relative Addressing
The Context Of Names
Special Names
A Step Further: A Formula In A Defined Name
Dynamic Names
Passing Arguments To A Defined Name Formula
Bugs in Excel's Name Object

Range Names in Excel

[Edited entry from 4/5/2006]

See all Topics

Labels: Excel

<Doug Klippert@ 3:52 AM

Comments: Post a Comment

Monday, May 25, 2009 – Permalink –

Backup Tool

Free utility

Backing up files is a "was gonna do that" activity. To make it a little easier, here is a free VBScript that will back up a selected folder to another location.
You will be walked through the process.

Of course your anti-virus software will give a burp, but it does work.

Vic Laurie is a retired chemistry professor. He maintains a site called Windows Tips and Tricks.

" My experience with teaching has made it clear that a lot of people simply refuse to do anything on a computer that involves more than a few simple steps."

Back up Files

And

Microsoft AtHome:

Backup basics: What should you back up?

Jake Ludington's MediaBlab:

Backup to your DV Camera

[Edited entry from 4/3/2006]

See all Topics

Labels: Windows

<Doug Klippert@ 3:18 AM

Comments: Post a Comment

Sunday, May 24, 2009 – Permalink –

Moxie Cola

What this country needs is plenty of Moxie

"Moxie outsells Coke"

The West coast was not a huge Moxie fan back in the day. Easterners had the advantage of a drink that has been described as a combination Dr. Pepper and cough syrup. It preceded and out sold Coke and Pepsi in the beginning, but lost market position.

How could it fail with a spiel like this:

"Contains not a drop of Medicine, Poison, Stimulant or Alcohol. But is a simple sugarcane-like plant grown near the Equator and farther south, was lately accidentally discovered by Lieut. Moxie and has proved itself to be the only harmless nerve food known that can recover brain and nervous exhaustion, loss of manhood, imbecility and helplessness. It has recovered paralysis, softening of the brain, locomotor ataxia, and insanity when caused by nervous exhaustion. It gives a durable solid strength, makes you eat voraciously, takes away the tired, sleepy, listless feeling like magic, removes fatigue from mental and physical over work at once, will not interfere with action of vegetable medicines.

BDragon.com

You can still buy Moxie and a bunch of other odd soft drinks. Here is some information on micro bottlers around the country.

Moxie Info

Information about Moxie, Moxie History, Moxie pictures, Moxie books, editorials about Moxie, Moxie Events, Moxie Horsemobile, Moxie Days, links to Moxie related sites, where to find Moxie Soda or bottlers and manufacturers, where Moxie is served with your food, Moxie collectibles, and more.

Here is a list of manufacturers.

Other soda sites:

The Soda Pop Stop:

PLANTATION STYLE MINT JULEP

Bubbles of fresh tasting mint in a soft drink. This one is so great! It's delicious alone, use it as a mixer or make ice cubes.

SodaKing:

LENINADE

Many people who once escaped from the Soviet Union, upon tasting Leninade, have overwhelmingly remarked that it is "BETTER THAN EXPECTED"; and those who prefer vodka in their potables have been known mix it with Leninade and ice to make a COMMIE KAZE. The Marx Brothers would be so proud. But even if you're a teetotaler you can get tired of Russky Chai and Drink As Lenin Drank!

The Soda Shop:

BOYLAN'S ORIGINAL BIRCH BEER

"Although we may be the smallest soda company around, our flagship brand is the most locally loved soft drink of its time. Rich with history, Boylan's Birch Beer started in a apothecary in the early 1890's and developed into the most popular flavor of The Boylan Sodaworks. Boylan was a bottling and keg filling operation located in the heart of Paterson, NJ, the first industrialized city in the country.

Competition increased however, and in the 1930's Boylan was forced to close its bottling lines, leaving Boylan's Draught Birch Beer as its only product. Shortly thereafter, the rights to the name, the formula, and the sole route was purchased by the driver. He, by himself, was responsible for pulling Boylan's Draught Birch Beer from near extinction to a beverage that is enjoyed by thousands at Fourth of July parades, town picnics, hot dog stands and many good times.

His reward for this accomplishment was a 7 day - 80 hour work week, but he would have it no other way.

In appreciation of our grandfather's effort, we honor him with this bottling project."

[Edited entry from 4/23/2006]

See all Topics

Labels: Addendum

<Doug Klippert@ 3:17 AM

Comments: Post a Comment

Saturday, May 23, 2009 – Permalink –

Compact-Repair Shortcut

Desktop convenience

You can make compacting and repairing databases easier by providing a desktop shortcut.

Right-click on the Windows desktop and select New>Shortcut from the shortcut menu. Then, set up a Command Line entry in the form:

"Path to Access.exe" "Path to Database.mdb" /compact

For example, to create a shortcut to compact Northwind, you might use:

"C:\Program Files\Microsoft Office\Office\Msaccess.exe" "C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb" /compact

Click Next and continue through the shortcut setup wizard, naming the shortcut appropriately.

In Access 2000+, the database is both compacted and repaired when the /compact switch is applied.

Access 97 executes these processes separately, so Access 97 shortcuts should use a Command Line in the form:

"Path to Access" "Path to Database" /compact /repair

Also note that you can compact to a different location by specifying a target database name after the /compact switch.

If you omit a target file name following the /compact option, the file is compacted to the original name and folder. To compact to a different name, specify a target file.

If you don't include a path in target database or target Access project, the target file is created in your My Documents folder by default.

(Even though a shortcut will open the database without it, in order for the command line flag to work, you MUST include the path to the executable - Access.exe)

[Edited entry from 4/1/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:29 AM

Comments:

yes, you are telling the truth we are able to repair our access file or mdb file in such a way but those file which are very less corrupted. For badly corrupted file you need the Access repair software which repair and recover your corrupted and damaged access file.

# posted by

David : 5/29/2009

Cost of a Bad Show

Avoid wasting time and resources

A bad PowerPoint presentation doesn't even make for good nap time. Some one is always jabbering about something.

Dave Paradi has written an article about this problem.

"If we assume some relatively conservative meeting parameters of four people per presentation, a half-hour presentation on average and the wasted time due to a poor presentation is one-quarter of the presentation time, we arrive at a waste of 15 million person hours per day. At an average salary of $35,000 per year for those attending the meeting, the cost of that wasted time is a staggering $252 million and change each day."

Bad PowerPoint costs money

He also provides a formula to figure out how much is lost in a sea of gradient blue.

[Edited entry from 3/31/2006]

See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:28 AM

Comments: Post a Comment

Thursday, May 21, 2009 – Permalink –

Styles not Applied to All Text

Word makes judgments

When text is selected, Word must examine the styles that have been applied and determine which to keep and which to overwrite.

Type the following text:

This line will test how styles and formatting work in Word.
Select all the text, and then apply italic formatting.
Select all the text, and then apply a style such as Heading 1.

You notice that italic formatting is not retained.
Select all the text, apply the Normal style, and then remove the italic formatting.
Select "work in Word" in the text, and then apply the italic formatting.
Select all the text, and then apply the Heading 1 style.

'This behavior occurs because Word uses a specific rule to determine whether to apply a style to selected text. According to this rule, Word applies a style depending on the percentage of the selected text that already has formatting applied. For example, if you already applied formatting to less than 50 percent of the selected text, this formatting is retained when you apply a style. If the selected text includes multiple paragraphs, Word first calculates the percentage of text that is formatted in the first paragraph. Then, it examines the paragraphs in the same range. If the formatting that is applied to the text in the paragraphs that follow the first paragraph differs from most of the formatting in the first paragraph, Word does not apply the style to the following paragraphs. Therefore, the formatting is retained in these paragraphs."

Support.Microsoft.com:
A style is not applied to all the selected text in Word

[Edited entry from 3/29/2006]

See all Topics

Labels: Word

<Doug Klippert@ 3:21 AM

Comments: Post a Comment

Wednesday, May 20, 2009 – Permalink –

The Grand Complication

By Allen Kurzweil

ISBN 0-7868-6603-9
Hyperion August 2001

About the Author
The Library of Congress has a reading by Kurzweil

Book Description
"Narrated by Alexander Short, a stylish young reference librarian of arcane interests, The Grand Complication propels the reader through a card catalog of desperation and delight, of intrigue and theft. It's a novel of suspense that comes full circle, with a clock-maker's precision and a storyteller's surprise, on page 360."

Quote

"THE SEARCH BEGAN with a library call slip and the gracious query of an elegant man.
"I beg your pardon," said the man, bowing ever so slightly. "Might I steal a moment of your time?"

He deposited his slip on the reference desk and turned it so that the lettering would face me. And if this unusual courtesy wasn't enough to attract attention, there was also the matter of his handwriting — a gorgeous old-fashioned script executed with confident ascenders and tapering exit strokes — as well as the title of the book he requested. Secret Compartments in Eighteenth-Century Furniture played right to my fascination with objects of enclosure.

"Let's see what we can do for you, Mr. — " I double-checked the bottom of the slip before uttering his improbably literary name. "Henry James Jesson III."

After I had directed him to the tube clerk, curiosity got the best of me, so I rang the stack supervisor and asked that she expedite retrieval. In a further breach of protocol, I pushed through the swing gate and planted myself near the dumbwaiter in Delivery, where I waited for the book to surface.

"This is terribly kind of you," Jesson said as I slid Secret Compartments under the brass grille.

"Glad to be of service."

I was professional enough not to mention the uncanny overlap of our interests — I don't meet many readers keen on lettering technique and enclosures. But that same restraint left me mildly disappointed. The call slip was so enticing, our exchange so stilted and brief.

Jesson settled himself at a table near the municipal tax codes. He quickly supplied further proof of a charmingly outmoded manner by digging deep into his capacious trouser pockets to extract a roll of paper, a tiny ink pot, and a calligraphy pen. Though he seemed to ignore the stares of nearby readers, he occasionally glanced in my direction, as if to confirm that I'd stuck around. Which, of course, I had. In fact, while he took notes on Secret Compartments, I took notes on him, convinced that the consonance of our uncommon pursuits demanded annotation.

He wore billowy trousers of moss-green corduroy that had wale as thick as pencils. These he partnered with a button-down shirt of subtle stripe and a dainty chamois vest tied at the back with a fat purple ribbon. He had an indulgent-looking face and blue-gray eyes that recalled the color of the buckram on my compact OED. Despite a bump at the bridge of his nose and teeth that predated fluoridation, he was undeniably handsome, a scholar who appeared unencumbered by the tattered frugality of most academics I assist. Those, in toto, were my preliminary observations of the elderly man wishing to steal a moment of my time."

A watch that shows the phases of the moon, for instance, is said to have one complication. A watch with five of these extra actions is said to be a grand complication.

[Edited entry from 3/26/2006]

See all Topics

Labels: Addendum, Books

<Doug Klippert@ 3:52 AM

Comments: Post a Comment

Tuesday, May 19, 2009 – Permalink –

UDF is not a Baby Alien

Things should to function

Frank Rice has written a "show how" about creating functions that are not included in the box.

"Excel allows you to create custom functions, called "User Defined Functions" (UDF's) that can be used the same way you would use SUM(), VLOOKUP, or other built-in Excel functions.
The Excel user who wishes to use advanced mathematics or perform text manipulation is often seriously disappointed by Excel's limited library of formulas and functions. A UDF is simply a function that you create yourself with VBA.

The following is a sample that is a good candidate for a UDF:
Function CtoF(Centigrade)
CtoF = Centigrade * 9 / 5 + 32
End Function
In the Worksheet you would enter something like:
=CtoF(A1)

frice's Weblog

Here are some other links:

Vertex42.com:
User Defined Functions

Support.Microsoft.com:
Functions to Calculate Light Years

[Edited entry from 3/27/2006]

See all Topics

Labels: Excel

<Doug Klippert@ 3:38 AM

Comments: Post a Comment

Monday, May 18, 2009 – Permalink –

Be Well, do good work, and keep in touch

A morning's home companion

The Writer's Almanac®, a daily program of poetry and history hosted by Garrison Keillor, can be heard each day on public radio stations throughout the country. Each day's program is about five minutes long.

Minnesota Public Radio will email the newsletter and link to you every morning.

It's a pleasant way to start the day with Garrison talking about some piece of literary history and then reading a short poem.

Try it, you'll like it.The Writers Almanac.org

Also, in keeping,
Prairie Home Companion Features

[Edited entry from 3/25/2006]

See all Topics

Labels: Addendum

<Doug Klippert@ 3:08 AM

Comments: Post a Comment

Sunday, May 17, 2009 – Permalink –

New Fields from Datasheet View

Table fields on the fly

We all, of course, pre-plan our table layouts. However, if you need to create a table field while working in Datasheet view, you don't have to switch to Design view.

There's a quick way to create a field from Datasheet view.

Right-click on the column heading of the column you want to the right of your new field.
Choose Insert Column from the shortcut menu.

Access creates a field with a name such as "Field1".

You can then immediately start entering data in. You can also use the shortcut menu to rename or delete the newly created field.

Later you can go to Design view to set the field's properties.

[Edited entry from 3/24/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:17 AM

Comments: Post a Comment

Saturday, May 16, 2009 – Permalink –

Delete It and Mean It

Turn off the questioning

Deleting an item in Outlook sends it to the Deleted Items folder. If you're sure that you want to eradicate the note, you can hold the Shift key when you delete an item.

You will receive a dialog asking if you are sure you want to permanently delete it.

To avoid the nagging you can turn off "Warn before permanently deleting items" under Tools>Options>Other>Advanced Options.

Be careful because you can delete items that might have benefited from one more moment's consideration.

(If you're using an Exchange server, you can probably get it back)

[Edited entry 3/23/2006]

See all Topics

Labels: Outlook

<Doug Klippert@ 3:42 AM

Comments: Post a Comment

Friday, May 15, 2009 – Permalink –

Tabs with the Number of the Week

Count to 52

Excel no longer has a theoretical limit on the number of worksheets in a workbook. One common use of this ability is to add a worksheet for each week in the year.

Here's a macro that does the trick:

Sub YearWorkbook()
Dim iWeek As Integer
Dim sht As Variant
Application.ScreenUpdating = False
Worksheets.Add After:=Worksheets(Worksheets.Count), _
Count:=(52 - Worksheets.Count)
iWeek = 1
For Each sht In Worksheets
sht.Name = "Week " & Format(iWeek, "00")
iWeek = iWeek + 1
Next sht
Application.ScreenUpdating = True
End Sub

ExcelTips.VitalNews.com:
Naming tabs for weeks

[Edited entry 3/21/2006]

See all Topics

Labels: Excel

<Doug Klippert@ 3:56 AM

Comments: Post a Comment

Thursday, May 14, 2009 – Permalink –

Forms on the Web

Fill in the blank

As long as you have FrontPage extensions on your server, you can create original forms for your site.

(yoiu can also create forms wth Expression Web)

You can use forms on your Web site to:

Retrieve contact information from site visitors (for example, guest books)
Receive feedback about your Web site
Accept orders and gather shipping and billing information
Conduct surveys
Provide online registration
Offer search box mechanisms
Prompt users to log in to your Web site

Expression.Microsoft:
Forms with Expression

Office.Microsoft.com:
About creating forms in FrontPage 2003

Feedback Forms:
Feedback Forms for Your Website

Flash tutorial
FrontPage Forms

[Edited entry from 3/20/2006]

See all Topics

Labels: FrontPage, Internet

<Doug Klippert@ 3:47 AM

Comments: Post a Comment

Wednesday, May 13, 2009 – Permalink –

PowerPoint Shows on DVD

Not a walk in the park

Commercial studios will convert your presentations for you, but if you want to get your hands dirty (at least the tips of your fingers), here is how to do it yourself.

PowerPointBackgrounds — Convert PowerPoint to DVD

Tutorial about how to convert PowerPoint to DVD

This tutorial guides you through how to convert your PowerPoint presentations to play on a home DVD player.
It's great for:

Showing presentations without the need for a computer
Distributing your slideshows to friends and colleagues
Unattended exhibition presentations, that automatically repeat/rewind
Giving your presentations more of a TV feel

And generally making you look more professional. Also see: PowerPoint to Video Sonia Coleman — PowerPoint to DVD RDPSlides.com: Convert presentations to VHS or DVD video Camtasia Studio — software Wondershare PPT2DVD And: Photos and PowerPoint [Edited entry from 3/18/2006] See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:48 AM

Comments:

Oh,it has the same function with Moyea PowerPoint to DVD Burner and Leawo PowerPoint to DVD

# posted by

geniusdwight : 11/03/2009

Byte, Nibble, Crumb, Bit

Umpty ump definitions and references — maybe even a googol.

We all know/knew that a nibble is four binary digits or half of a (eight-bit) byte and that a crumb is jargon for two bits (two binary digits). However, there must be some other definitions that don't pop into mind right away.

That's where Whatis, an IT-specific encyclopedia comes in.

"Every File Format in the World"

This is a list of file name extension or suffixes that indicate the format or usage of a file and a brief description of that format.

KAR: MIDI file (text+MIDI) (Karaoke)

[Edited entry from 3/17/2006]

See all Topics

Labels: Addendum, HTML, Vista, Windows

<Doug Klippert@ 3:35 AM

Comments: Post a Comment

Monday, May 11, 2009 – Permalink –

Free TIVO

(Almost, if you've got the parts laying around)

From the "Not quite too hard to do" file. Construct your own DVR from a leftover PC.

"I started with an old PC (a Dell Dimension 4500) that had unfortunately been destroyed by lightning. After some experimentation, I figured out that the only bad portions of the PC were the motherboard and the modem (which I didn't need anyway). I decided to replace the motherboard and keep the same case and other hardware because I really liked Dell's clamshell case design. I did some research at my local Fry's electronics store and got a motherboard that would allow me to use the same memory, processor, and case. After getting . . . . .

Makezine.com:
Build a Better DVR out of an Old PC

[Edited entry from 3/17/2006]

See all Topics

Labels: Addendum

<Doug Klippert@ 3:20 AM

Comments: Post a Comment

Sunday, May 10, 2009 – Permalink –

Shortcuts to Access Objects

Quick way in

If you often work with a certain Access objects (specific forms, queries, etc.) in a database, you can create a shortcut to it on your desktop.

Click on the Object and drag it to the desktop..

Access will create the shortcut on your desktop, or another location.

[Edited entry from 3/15/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:10 AM

Comments: Post a Comment

Saturday, May 09, 2009 – Permalink –

Custom Properties

Use your own

If you look at Properties on the File menu, you will see a number of entries. You can also create your own custom properties.

Click the Custom tab and add what you want.

To insert your own properties in a document, use Insert>Fields

Choose Document Information in the list of Categories
In the list of Field Names, choose DocProperty
Click the Field Codes button
Add the property name to the Field
Click OK
Click OK. Word to inserts the value.

Here's the "click path" for 2007:

Also: Office-Watch.com:
Creating word custom doc properties from code

[Edited entry from 3/14/2006]

See all Topics

Labels: Word

<Doug Klippert@ 3:41 AM

Comments: Post a Comment

Friday, May 08, 2009 – Permalink –

Data from the Other Sheet

Sometimes we must go next door

Here is a discussion about how to use data that may be on a different worksheet, or another workbook.

Getting data from other sheets can be very easy: or it can be very hard, it all depends on what you need to do. This article looks at some of the ways you can get data from other sheets.

The basics

Using the Indirect function

Back to the old school, XLM! (previous and next sheet)

VBA user defined functions (previous and next sheet)

Links

Methods In Excel

Also: BetterSolutions.com
Cell References

[Edited entry from 3/13/206]

See all Topics

Labels: Excel

<Doug Klippert@ 3:12 AM

Comments: Post a Comment

Thursday, May 07, 2009 – Permalink –

More Cascading Style Sheet Help

Tutorials, Tools, and Links

"Cascading Style Sheets separate the presentation from the structural markup of a web site. By applying a CSS style you have the ability to keep the structure of your document lean and fast, while controlling the appearance of the content.

HTML was intended as the structural markup language. This language focuses on the roles that the different elements of a document have to play, not how they have to look. CSS has been invented and developed for the Internet. It is not an adapted tool from print or programming, but a means of enhancing HTML."

Mako4CSS.com

CSS Creator site is a place for you to learn about and create CSS, Cascading Style Sheets. The CSS Forum is a place where you can discuss CSS page layouts, positioning, bugs and just about anything related to cascading style sheets. The forum is new, free and most of all needs people like you to create a community. Talk about CSS, ask questions, find solutions, and help each other learn at the CSS Forum.
The original CSS Creator is a CSS generator, which you can use to create styles and test them on your site. If you are learning CSS have a look and see how changes will affect your site and generate the styles. The CSS Creator has been used tested on 5266 urls.
The CSS Layout Generator will generate layouts with a flexible center column and fixed width left and or right column. All columns will be the same length, the layout can be centered on the page or full width and a header and footer can be easily added. 10545 CSS Layouts have been generated.
A light weight multi level menu, which uses a very small JavaScript file for browsers with bad CSS support. The markup of the menu is simply unordered lists, it can support multiple levels and will degrade to a simple unordered list if CSS is turned off.
A Useful CSS Links page has been added to the site and contains great links to CSS tutorials, tools, tips from all over the web.

CSS Creator.com Also see: New York Public Library Online Style Guide [Edited entry from 3/12/2006] See all Topics

Labels: Expression Web, FrontPage, HTML

<Doug Klippert@ 3:25 AM

Comments: Post a Comment

Wednesday, May 06, 2009 – Permalink –

Who was that font I saw you with last night?

That was no font, that was my typeface

You can find the Fonts supplied with some Microsoft products
Select a product name from the list to get a list of fonts supplied with that product.

Microsoft's Typography is an interesting site to poke around in.

Here are some books I use for reference material:

Words into Type

by Marjorie E. Skillin, Robert Malcolm Gay ISBN 0139642625

Stop Stealing Sheep & Find Out How Type Works

by Erik Spiekermann, E.M Ginger ISBN 0201703394

The Elements of Typographic Style

by Robert Bringhurst ISBN 0881791326

A font can be defined as a collection of characters with the same style and size. A typeface is the design of the characters regardless of size or style. The terms are used interchangeably today.

[Edited entry from 3/11/2006]

See all Topics

Labels: Access, Excel, Expression Web, FrontPage, PowerPoint, Windows, Word

<Doug Klippert@ 3:06 AM

Comments: Post a Comment

Tuesday, May 05, 2009 – Permalink –

High Level Presentation Tips

Extreme Tweaks

Learn by example

When you realize that tattoos are only skin deep.

"Some people may look at this website, browse through the portfolios, and come to the conclusion that they want to become part of Steve's art. Some others may immediately decide that they don't like what they see. They may be offended or horrified by the subject matter, by the form that Steve's art takes, by the extreme individualism exhibited herein.

So one person's idea of body modification is going to be a pierced ear lobe, and another person's idea of body modification is to look like the el Diablo himself. Just because you don't agree doesn't make it wrong."

Steven Haworth

Here's one of Steve's clients:
"Stalking Cat"

[Edited entry from 3/9/2006]

See all Topics

Labels: Addendum

<Doug Klippert@ 3:51 AM

Comments: Post a Comment

Sunday, May 03, 2009 – Permalink –

Crosstab Query Column Headings

Using Month Numbers

If you display a crosstab query as a datasheet, consider using a month's or day's number as a column heading instead of a text abbreviation (e.g., 1 instead of Jan or January, or 2 instead of Mon).

Text abbreviations are sorted alphabetically. Apr appears before Feb, Mon appears before Sun, etc. Number representations will sort in their proper order.

[Edited entry from 3/8/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:01 AM

Comments: Post a Comment

Saturday, May 02, 2009 – Permalink –

4-1-9

Nigerian Advance Fee Fraud

The Advance Fee Fraud (AFF) is known internationally as "4-1-9" fraud after the section of the Nigerian penal code which addresses fraud schemes.
(BTW, it is pronounced 4-1-9, not four-nineteen.)

You've most probably been approached via email to help some poor soul smuggle millions out of some war torn province in return for a generous finder's fee.

"A renowned psychiatrist from UC Irvine was duped into squandering at least $1.3 million of his family's fortune on a Nigeria Internet scam, according to a lawsuit recently filed by his son.

The son, also an Orange County doctor, said his father - Dr. Louis A. Gottschalk - gave as much as $3 million over a 10-year period in response to an Internet plea that promised the doctor a generous cut of a huge sum of cash trapped in African bank accounts in exchange for money advances.

Gottschalk - who at 89 still works at the UCI campus medical plaza that bears his name - said in court papers that the losses were caused by "some bad investments."

Guy Gottschalk is asking a judge to remove his father as administrator of the $8-million family partnership that was set up for tax purposes after the death of his mother in 1993. A hearing is set for March 14.

The suit alleges that Louis Gottschalk destroyed bank records to cover up the amount of his losses.

"While it seems unlikely, even ludicrous, that a highly educated doctor like [Gottschalk] would fall prey to such an obvious con, that is exactly what happened," wrote Guy Gottschalk's attorney in court papers."

LA Times March 2, 2006

If your willing to take the risk, here is a site that baits the scammers.

419Eater.com

[Edited entry from 3/7/2006]

See all Topics

Labels: Outlook

<Doug Klippert@ 3:26 AM

Comments: Post a Comment

Friday, May 01, 2009 – Permalink –

Vertical Selection with ALT

Old trick

This trick has been around for awhile, but it might be forgotten as new information in the right ear shoves old knowledge out the left.^*

If you hold down the ALT key while selecting in a Word document, you can select a block. This could be a vertical area, such as the prefixes of a list.

The selection can then be formatted or deleted.

^*Also see Michael Feldman's "Something I Said: "Innuendo and Out the Other""

[Edited entryfrom 3/6/2006]

See all Topics

Labels: Word

<Doug Klippert@ 3:23 AM

Comments: Post a Comment

Unicode and other Characters

Why's A 65?

Free Articles

Choose a topic

Report Manager

Define Print & View Areas

Create a report for printing

Edit a report for printing

Print a report

Time Flies Like an Arrow

Fruit Flies Like a Banana

Grammar Rules!

Could Of or Could Have?

Name that Range

How to use names in Excel

Backup Tool

Free utility

Moxie Cola

What this country needs is plenty of Moxie

PLANTATION STYLE MINT JULEP

LENINADE

BOYLAN'S ORIGINAL BIRCH BEER

Compact-Repair Shortcut

Desktop convenience

Cost of a Bad Show

Avoid wasting time and resources

Styles not Applied to All Text

Word makes judgments

The Grand Complication

By Allen Kurzweil

UDF is not a Baby Alien

Things should to function

Be Well, do good work, and keep in touch

A morning's home companion

New Fields from Datasheet View

Table fields on the fly

Delete It and Mean It

Turn off the questioning

Tabs with the Number of the Week

Count to 52

Forms on the Web

Fill in the blank

PowerPoint Shows on DVD

Not a walk in the park

Byte, Nibble, Crumb, Bit

Umpty ump definitions and references — maybe even a googol.

Free TIVO

(Almost, if you've got the parts laying around)

Shortcuts to Access Objects

Quick way in

Custom Properties

Use your own

Data from the Other Sheet

Sometimes we must go next door

More Cascading Style Sheet Help

Tutorials, Tools, and Links

Who was that font I saw you with last night?

That was no font, that was my typeface

Words into Type

Stop Stealing Sheep & Find Out How Type Works

The Elements of Typographic Style

High Level Presentation Tips

More than just a PPT tutorial

Extreme Tweaks

Learn by example

Crosstab Query Column Headings

Using Month Numbers

4-1-9

Nigerian Advance Fee Fraud

Vertical Selection with ALT

Old trick