Monday, March 31, 2014


A few good ones

Here are some keyboard shortcuts that can be used when running a show:

N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or the SPACEBAR (or click the mouse)
Perform the next animation or advance to the next slide

Perform the previous animation or return to the previous slide

Go to slide number

  • B or PERIOD
    Display a black screen, or return to the slide show from a black screen

    W or COMMA
    Display a white screen, or return to the slide show from a white screen

    S or PLUS SIGN
    Stop or restart an automatic slide show

    End a slide show

    Erase on-screen annotations

    Go to the next hidden slide

    Redisplay hidden pointer and/or change the pointer to a pen

    Redisplay hidden pointer and/or change the pointer to an arrow

    Hide the pointer and navigation button immediately; prevent the pointer from appearing if your mouse is moved.

    Hide the pointer and navigation button in 15 seconds

    SHIFT+F10 (or right-click)
    Display the shortcut menu

    Go to the first or next hyperlink on a slide

    Go to the last or previous hyperlink on a slide

    ENTER while a hyperlink is selected
    Perform the “mouse click” behavior of the selected hyperlink

    SHIFT+ENTER while a hyperlink is selected
    Perform the “mouse over” behavior of the selected hyperlink

    • Ctrl-M: New slide
    • Ctrl-D: Duplicate the current slide
    • Ctrl-Shift-C: Copy Autoshape style
    • Ctrl-Shift-V: Paste Autoshape style
    • Ctrl-Shift G: Group objects
    • Ctrl-Shift H: Ungroup objects
    • Shift-F9: Toggle the grid on and off
    • Alt-F9: Toggle the guides on and off
    • F5: Start presentation
    • Right arrow: Next slide or build
    • Left arrow: Previous slide or build
    • Home: First slide
    • End: Last slide

    Also see: Support.Microsoft

    See all Topics
  • Sunday, March 30, 2014


    All things auto

    "Jalopnik loves cars.

    Secret cars, concept cars, flying cars, vintage cars, tricked-out cars, red cars, black cars, blonde cars
    sometimes, cars just because of the curve of a hood."

    In Washington state:
    The GreenCar Company

    See all Topics

    Saturday, March 29, 2014

    SQL Statements Automatically

    Hidden code

    If you're having trouble figuring out a complex SQL statement for use in code, you may be able to simplify the process by first setting it up the query you want in the query design grid.

    Once you've got it configured correctly, choose View >SQL view to reveal the underlying SQL statement, which you can copy and paste into your code.

    You may have to make minor modifications, but this technique often eliminates much of the hassle of manually constructing SQL statements.

    You can also tweak the underlying SQL code to adjust your Query. This code can also be copied and reused in other Queries after a little customizing.

    See all Topics

    Friday, March 28, 2014


    Pick a card

    If you wish to share information about yourself and your company when networking with others a handy solution is electronic business cards, called vCards (virtual business cards), which can be sent using Outlook 2000+.

    To send a vCard to an individual, open the contact and on the Actions menu, click "Forward as vCard". Outlook attaches the contact information in a vCard file called .vcf

    Note You can automatically include a vCard every time you send a message. Just add the vCard to your signature!

    If you want to be able to insert a vCard in a message that you have already started, save the file for that vCard to a convenient location where you can access it.

    Open the contact, on the File menu, click "Export to vCard". Specify the location where you want to save the file, and then click Save. When you want to insert the file in an item that you have opened, on the Insert menu in the item, click File, and then select the .vcf file.

    In the message that contains the vCard you received, double-click the vCard attachment.
    Add any other information you want about the contact, and then on the File menu, click "Save and Close".

    How to Use vCard in Outlook

    Signed, Sealed, and Delivered: Outlook's Signature and vCard Features

    Sharing Microsoft Outlook Calendar and Contacts

    See all Topics

    Thursday, March 27, 2014

    Easy Reading

    Clean up the screen

    Word 2003 introduced a view of documents that eliminates a lot of the distractions of Task Panes and toolbars.

    It's called Reading Layout.
    Word Reading Layout View

    Demo reading layout view

    In 2007-13 it's View>Full Screen Reading

    See all Topics

    Wednesday, March 26, 2014

    Color Safe Not

    The other side of the wheel

    Death of the Websafe Color Palette?
    One of the givens of Web design, the holiest of holy truths, is the sanctity of the 216 websafe color palette. It's a rite of initiation for every Web designer or developer: Use only these colors, we were told, and don't question why.

    By David Lehn and Hadley Stern. David is a senior information architect and interface developer in the Milan office of Razorfish. Hadley is a senior designer in Razorfish's Boston office.

    See all Topics

    Tuesday, March 25, 2014

    Before Windows

    The old days

    Here's Guidebook, a website dedicated to preserving and showcasing Graphical User Interfaces.

    Remember GeoWorks?


    How about HP's NewWave.

    I bought NewWave when it came out, because surely HP would be beat out those new guys at MS.

    See all Topics

    Monday, March 24, 2014

    Random Slides

    Vary the show

    Here is the code that can be used to mix up the order of your slides.

    Sub sort_rand()
    Dim i As Integer
    Dim myvalue As Integer
    Dim islides As Integer
    islides = ActivePresentation.Slides.Count
    For i = 1 To ActivePresentation.Slides.Count
    myvalue = Int((i * Rnd) + 1)
    ActiveWindow.ViewType = ppViewSlideSorter
    ActivePresentation.Slides(islides - 1).Select
    End Sub

    PowerPoint Tools:
    Randomize the order of a PowerPoint presentation

    See all Topics

    Sunday, March 23, 2014

    Legal Understanding

    See what they mean

    Through precise definitions, an act can be compared to what's allowed and what is prohibited.

    This very process of clarification can make the statutes difficult for the layman to understand.

    " Welcome to Nolo's Legal Glossary, your life-raft in the sea of legal jargon. Do you need to know the meaning of sprinkling trust, toxic tort or some equally puzzling legal term? Look it up here. Our glossary contains plain-English definitions for hundreds of legal terms, from the common to the bizarre."

    Toxic tort
    A personal injury caused by exposure to a toxic substance, such as asbestos or hazardous waste. Victims can sue for medical expenses, lost wages and pain and suffering.
    Willful tort
    A harmful act that is committed in an intentional and conscious way. For example, if your neighbor builds an ugly new fence and you intentionally run it down with your truck, that's a willful tort. But accidentally backing into the fence as you pull out of your driveway is not willful, though it's still a tort.

    Everybody's Legal Glossary

    See all Topics

    Saturday, March 22, 2014

    View Multiple Pages of an Access Report

    More than one at a time

    When you preview an Access report, you may want to see several pages at one time to examine the layout of the report.
    You may know that you can do so by choosing View >Pages from the menu bar. However, this technique limits how you view the pages -- you can only view 1, 2, 4, 8, or 12 at a time.

    For more control over how the pages are displayed, right-click on the report preview itself, and choose Multiple Pages from the shortcut menu.

    The default layout grid is 2 x 3 pages. However, if you click and drag with your mouse, you can select a range of up to 4 x 5 pages.

    See all Topics

    Friday, March 21, 2014

    Click to Type


    When you open a template for a Memo, Letter, or Fax, you will see a field like this:

    [Click here and type Name]

    When you click and type the field goes away.

    Here's how to create on of your own.

    1. Place the Insertion point in the document where you want the field.

    2. Hit Ctrl+F9 to create field brackets {}.
      (they can not be just typed in)

    3. Between the brackets type:

      {MACROBUTTON NoMacro [Click here and type junk]}

    4. Press Alt+F9 and the field code will disappear.

    For more information see The Word MVP site:
     Using MacroButton fields.

    See all Topics

    Thursday, March 20, 2014

    Automatically Renumber Records

    Been looking for this

    What happens to a list when one record is deleted?

    If you need to correct the numbering, see these instructions.

    Automatically renumber the records in an Access table when one is deleted

    from Martin Green -

    See all Topics

    Wednesday, March 19, 2014

    Bricks as Pets

    Is it right?

    Tired of picking up after your pet?
    "Red Bricks (Brickus vermillius) are found around the world. Their association with humans is a long one, for bricks have been found in archaeological sites from the very ancient to the modern.

    The vast majority of bricks are working bricks, used mainly in construction of human houses and other buildings. A tiny minority of bricks, however, are unfortunately kept for human consumption, a use that is thankfully dwindling under the force of anti-brick-cruelty laws."

    Pet Brick FAQ

    The site also has more than enough information about rats.
    Rat Behavior and Biology

    See all Topics

    Tuesday, March 18, 2014

    One Icon, One Doc

    Separate buttons

    Rather than have Windows group all open documents under one single toolbar button, display one icon for each.

    1. Right click on the taskbar.

    2. Choose "Properties."

    3. In the Taskbar and Start Menu Properties dialog box, uncheck the "Group similar taskbar buttons." — "Always combine, hide labels

    4. Click the OK button.

    See all Topics

    Monday, March 17, 2014

    Happy [Blank} Day

    Use Office for more than the office

    Microsoft provides a step by step on how to create a message for any occasion, using PowerPoint.
    "Microsoft PowerPoint is a robust tool for creating powerful presentations. But you can also use PowerPoint to create multimedia cards to send in e-mail to friends and family - perfect for vacations, holidays, and numerous other occasions.

    With PowerPoint, you can easily personalize the colors and design, include your own videos and photos of the family, and choose just the right message for each recipient."

    Create a greeting card in PowerPoint

    See all Topics

    Sunday, March 16, 2014

    Grandma Knew Best

    Advice from the past

    History does repeat itself, so we might learn from advice from the past.

    "Take a step back in time as I share words of wisdom from my collection of about 1,000 classic advice books in a quest to solve modern-day dilemmas.

    The books span from 1822 to 1978 and cover the age-old topics of dating, love, living together, marriage, health, beauty, puberty, sex, etiquette, housekeeping, home economics, and home repairs. I've spent years scouting out used bookstores and thrift shops to locate these treasures of self help. "

    See all Topics

    Saturday, March 15, 2014

    Send E-Mail with Access

    Automate the drill

    You can use Access as a data source and use Word to merge to Outlook. Here, however, is a way to do it from Access itself.
    "You can use the SendObject method to send a MAPI mail message programmatically in Microsoft Access. However, the SendObject method does not give you access to complete mail functionality, such as the ability to attach an external file or set message importance.

    The example that follows uses Automation to create and send a mail message that you can use to take advantage of many features in Microsoft Outlook that are not available with the SendObject method.

    There are six main steps to sending a Microsoft Outlook mail message by using Automation, as follows:

    1. Initialize the Outlook session.
    2. Create a new message.
    3. Add the recipients (To, CC, and BCC) and resolve their names.
    4. Set valid properties, such as the Subject, Body, and Importance.
    5. Add attachments (if any).
    6. Display/Send the message.

    Use Automation to send a Microsoft Outlook message using Access
    Access to E-Mail

    See all Topics

    Friday, March 14, 2014



    Create a new Contact, or edit an existing entry.

    At the bottom right corner of the dialog box is a button labeled

    You can assign your contact to multiple categories. You can add new ones to the Master Categories list.

    Now you can use Categories to sort entries and use them for Mail Merges.

    Microsoft Office Online has this article:
    Power tips for organizing your Outlook 2002 Inbox

    Up to Speed with Outlook 2007

    Getting Started With Outlook 2010

    Basic Tasks in Outlook 2013

    See all Topics

    Thursday, March 13, 2014

    A Way Cool Paint-Picker

    Just slap it on

    If you have decided to paint your home, or just this inside of the downstairs coat closet, the Behr paint people have a neat tool.

    Color Smart

    You still have to slop the paint on yourself, though.

    Here's another color generator:

    Top 8 Color Tools

    EasyRGB matches generated RGB values to paints, inks, etc.

    See all Topics

    Wednesday, March 12, 2014

    Internet History

    Two tin cans

    From the FCC:

    The Internet: A Short History of Getting Connected.
    When the Defense Department issued a $19,800 contract on December 6, 1967, for the purpose of studying the "design and specification of a computer network," the world didn't take notice. But it should have. For, from that small, four-month study grew the ARPANET. And, from ARPANET emerged the Internet.

    NSF Presentation

    Living Internet
    "An elegantly organized tour of the history of the Internet -- both fun and informative -- a rare combination!"
    Steve Crocker, invented the Request For Comments.

    All About the Internet

    Hobbes' Internet Timeline v11.0

    A Brief History of the Internet

    "When the late Senator Ted Kennedy heard in 1968 that the pioneering Massachusetts company BBN had won the ARPA contract for an "interface message processor (IMP)," he sent a congratulatory telegram to BBN for their ecumenical spirit in winning the "interfaith message processor" contract."

    See all Topics

    Tuesday, March 11, 2014

    Auto Show

    Also Dumb No Dot

    A PowerPoint show can be set up to run automatically when it is opened.

    To do this, you could go to File>Save As and choose PowerPoint Show (*.pps) from the Save as type: list.

    Another way is to change the extension (the three letters that appear after a file name such as Report.DOC).

    PowerPoint uses .PPT for normal files, .POT for templates.

    A PowerPoint show uses .PPS.

    Microsoft "dumbed down" Windows Explorer so that, by default, extensions are not displayed.

    To see them:
    1. Go to Windows Explorer.
    2. On the Menu bar go to Tools>Folder Options
      (Organize>Folder and Search Options in Vista)
    3. Click on the View tab.
    4. In the Advanced settings list, remove the check mark from "Hide file extensions for known file types."
    5. OK your way out.
    To change a regular PowerPoint file to a show:
    1. Locate the file in Windows Explorer.
    2. Right click the file name and choose Rename.
    3. Touch the End key on the keyboard and the Backspace three times.
    4. Enter the letters PPS
    5. Hit Enter.
    You now have a PowerPoint show that will automatically run when it is opened.

    (This also works with *.PPTX files

    See all Topics

    Monday, March 10, 2014

    Be a Local Scoble

    Photo Walk

    Robert Scoble, tech evangelist, has been touting the fun of Photowalking. Getting together with a group of like-minded people to just walk around and take pictures.

    Robert has made a number of videos that you can see on his blog The ScobleShow on

    Locally Kevin Freitas, a web developer and community supporter, solicited participation in a Tacoma area walk.

    Since digital film is free. After you've got a camera, why not set a walk up in your city?

    The results of our stroll can be seen at theses links:

    Sunday, March 09, 2014

    New Line in Memo

    Labels and Text boxes

    When you're using a form to enter text in a memo field, pressing [Enter] within the text inserts a line break.

    However, when you're working with a memo in a table's Datasheet view, pressing [Enter] moves the focus to the next field.

    You can force line breaks when you're entering text by pressing [Ctrl][Enter]. This technique also works with text fields and can be applied when you're entering text in labels or text boxes on a form.

    To permanently configure a text box so that pressing [Enter] inserts a new line, set its EnterKeyBehavior property equal to New Line In Field.

    See all Topics

    Saturday, March 08, 2014

    Did You Know?

    Nerd Conversation Nibblets

    Here's a part of the list of knowledge tidbits from Kelly's Bar

    Did You Know?
    • Barbie's measurements if she were life size: 39-23-33.
    • The dollar symbol ($) is a U combined with an S (U.S.)
    • Our eyes are always the same size from birth, but our nose and ears never stop growing.
    • The Statue of Liberty's tablet is two feet thick.
    • There are two credit cards for every person in the United States.
    • Hacky-sack was invented in Turkey.
    • Cat's urine glows under a blacklight.
    If you have doubts about these "facts", look at the Snopes Urban Legends Reference Pages

    See all Topics

    Friday, March 07, 2014

    Can the Narration


    PowerPoint and Narration
    By Geetesh Bajaj from Indezine

    "Narration is one of PowerPoint's least-used and most-misunderstood aspects. Many people try narration within PowerPoint only to get frustrated and give up.

    Surprisingly, most PowerPoint narration problems stem from outside PowerPoint - from incompatible sound cards to loose microphone cables or messed-up Multimedia properties in the Windows control panel.

    Or maybe you set your microphone volume settings very low or even mute! That's why I've provided a checklist of things you should do before you even attempt to begin narration in PowerPoint."

    See all Topics

    Thursday, March 06, 2014

    Progress Bars

    Don't go away

    If your macro is going to take a bit of time to complete, it is good manners to inform your users what is going on. If screen updating is turned off, they may think their machine has frozen.

    Andy Pope has some great charting examples and also demonstrates a number of
    Progress meters

    Here's a static example:

    Progress display

    John Walkenbach, also, has tips about how to create a Progress indicator

    also see:
    Chip Pearson

    See all Topics

    Wednesday, March 05, 2014

    Color Blind

    Be seen by all

    Books on web design warn against using the colors red and green.

    One out of twenty people have problems with some form of color blindness.

    Here is a site that will let you check your web pages. You will be able to see the page as it appears to someone with one of the three main types of color deficit.



    Deuteranope color blindness

    hats, deuteranope

    Colorblind Web Page Filter

    How do things look to Color Blind People

    Web Colors

    See all Topics

    Tuesday, March 04, 2014

    Presidents' or President's day


    The third Monday in February is officially Washington's birthday, not Presidents' Day according to the federal government.

    Individual states may designate the day as anything they want, but the federal holiday is Washington's birthday.

    Interestingly enough, although Georgia celebrates Washington's Birthday, the Governor is accorded the right to designate when state holidays occur. In Georgia, Washington's Birthday is recognized the day after Christmas.

    There is an urban legend that when the Uniform Monday Holiday Act was implemented in 1971, President Richard Nixon issued a proclamation calling for a Presidents' Day on the third Monday to honor all U.S. presidents.

    Each February both the Law Library at the Library of Congress and the Nixon Library field an upsurge in calls on this question. No evidence of this exists in Nixon's official papers.


    See all Topics

    Monday, March 03, 2014

    Open 2007-2010 200-2003

    Not everyone is going to jump at once

    How to open and to save Word 2007, Excel 2007, and PowerPoint 2007 files in earlier versions of Office
    Microsoft Office Word, Microsoft Office Excel, and Microsoft Office PowerPoint versions 2000 through 2003 cannot natively open documents that are stored in the Office Open XML Formats in 2007 Microsoft Office programs.

    You can install the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats to open or to save 2007 Office files.

    Microsoft Office XP and 2003
    Word, Excel, and PowerPoint

    After you install the Compatibility Pack, you can use your existing version of Word, Excel, and PowerPoint to open, edit, and save the file formats that are new to Word 2007, Excel 2007, or PowerPoint 2007. For example:
    • You can open Word, Excel, or PowerPoint 2007 files by double-clicking them exactly as you do with your existing Word, Excel, and PowerPoint presentation(s).
    • You can save Word, Excel, or PowerPoint 2007 files by clicking the Save button in your version of Word, Excel, or PowerPoint.
    Microsoft Office 2000
    Word, Excel, and PowerPoint
    Word 2000
    • After you install the Compatibility Pack, you can open, edit, and save the document file formats that are new to Word 2007 within Word 2000.
    • You can open files in the formats that are new to Word 2007 by double-clicking the files.
    • You can save files in the formats that are new to Word 2007 by clicking Save in Word 2000.
    Excel 2000 and PowerPoint 2000
    • After you install the Compatibility Pack, you can open and save the file formats that are new to Excel 2007 and to PowerPoint 2007 from the Microsoft Windows operating system.
    • You can open files in the formats that are new to Excel 2007 and to PowerPoint 2007 by double-clicking the file on the desktop, in the My Documents folder, or in Microsoft Windows Explorer.
    • You can save files in the formats that are new to Excel 2007 and to PowerPoint 2007 by right-clicking an Excel 2000 file or a PowerPoint 2000 file and then clicking Save As.
    Compatibility Pack Functions

    Compatibility Pack Download

    See all Topics

    Sunday, March 02, 2014

    Saturday, March 01, 2014

    Non-Designers Type Book

    By Robin Williams

    ISBN 0-201-35367-9
    Peachpit Press 1998

    About the Author
    Williams teaches electronic typography and has written some excellent books on digital design.

    Anyone who has witnessed the horrific use of type on many personal web sites knows how badly these books are needed. Clear explanations and good illustrations are the hallmarks of both volumes.

    Also author of The PC is not a typewriter.

    Book Description
    Each short chapter explores a different type secret including use of evocative typography, tailoring typeface to project, working with spacing, punctuation marks, special characters, fonts, justification, and much more. It is written in the lively, engaging style that has made Williams one of the most popular computer authors today.

    It uses numerous examples to illustrate the subtle details that make the difference between good and sophisticated use of type. The non-platform specific, non-software specific approach to the book makes this a must-have for any designer's bookshelf - from type novices to more experienced graphic designers and typesetters.

    "Most packages also have a discretionary hyphen, affectionately called a "dischy." If you type Ctrl+- (Control Hypen on a PC), the word will hyphenate at that point, that hyphen will disappear when the word moves to another location.

    Also (and this is the point), if you type a discretionary hyphen in front of a hyphenated word, it will not hyphenate at all, ever."

    See all Topics