Monday, February 20, 2017

Sunday, February 19, 2017

Formatted Input Boxes

Use text boxes

"You can use a Data Validation Input Message to display a message when a cell is selected. However, the font can't be changed, nor can message box size be controlled.

To overcome these limitations, you can create a text box to display the message, and use programming to make it appear if cells that contain a data validation Input Message are selected."

See all Topics

Saturday, February 18, 2017

First Aid

Do it yourself

Got a foreign object in your nose? The Mayo Clinic has some advice on First Aid.

See all Topics

Friday, February 17, 2017

Grouping in Sections

Enhance grouping in your Access reports

Discover a quick way to put these groups in sections and then enhance these sections by providing summary details about the group.

See all Topics

Thursday, February 16, 2017

Style Sets

Formatting collections

Here is a tutorial about Style sets. You can develop and reuse your own collection of font/attribute choices.

How to use:

See all Topics

Wednesday, February 15, 2017

Shuffle Windows Media Player

Sort repeat

You have control over how Media player shuffles, repeats, and sorts content.


See all Topics

Tuesday, February 14, 2017


How to even in earlier versions

Sandra Johnson demonstrates how to create reflections in PowerPoint. 2007-13, of course, but also in earlier versions.

See all Topics

Monday, February 13, 2017

Calendars on line

Available to all

You can publish a calendar to Office Online. People that do not have Outlook can still view the team calendar using the Office Online web site.

See all Topics

Sunday, February 12, 2017

CSS Menus

For the coder

Alan Gresley from Australia has an interesting site that includes the CSS code to create menus. One of the styles is called "Sons of Ursidae Menus".

See all Topics

Saturday, February 11, 2017

Friday, February 10, 2017

Color in Access

Not dull

You can now use more than 16 colors in your datasheets.
You can pick any colors you want for gridlines, background and alternate background.
New themes and more color control in 2007+.

See all Topics

Thursday, February 09, 2017

Language Formatting

Spell Check

When you use another language in your document, the spell checker will find errors in the text.
To avoid that, format the words with a language style.

See all Topics

Wednesday, February 08, 2017

Excel to PPT

And Access

This example shows how to place the VBA code in PowerPoint, retrieve data from Excel and or Access and display it in a PowerPoint table.

See all Topics

Tuesday, February 07, 2017

YouTube Time Link

To the second

You can link directly to a specific time in a YouTube video. All you have to do is add a #t= anchor to the end of the URL that indicates the time position in minutes and seconds.

Here are the instructions:

See all Topics

Monday, February 06, 2017

Saturday, February 04, 2017

Cut the Shortcut Arrow

Clean icons

If little things bother you, try this suggestion to remove the arrow that appears on shortcut icons.

See all Topics

Friday, February 03, 2017

YouTube on a Slide

Good trick

YouTube is a treasure chest of material. This link shows how to add a YouTube video to your PowerPoint presentation.

See all Topics

Thursday, February 02, 2017

Storage Option

Alternate method

Sent mail can be stored with original message.

See all Topics

Tuesday, January 31, 2017

Code Copy

Excel to Word

You can select, copy, and paste to put Excel data into a Word document, but this piece of VBA automates to process.

See all Topics

Monday, January 30, 2017

Tag a Collection

Basic naming and tagging protocol

Here are some suggestions about indexing a collection. In this case pictures on Flickr.

Deciding on classifications and inputting the tags is the hard part. Once all of the tags are in place your collection is searchable, and you can make sets based on any of the criteria used.

See all Topics

Sunday, January 29, 2017

Drag Query to Word

Drop in

Rather than duplicate the effort, an Access query can be dragged into a Word document.

See all Topics

Saturday, January 28, 2017

Quick Parts


Word 2007+ uses the term Quick Parts for Building Blocks.
You can use any kind of content, including pictures, tables, document properties, hyperlinks, and more to create a building block.

See all Topics

Friday, January 27, 2017

Autoshapes to Pictures


You can, sometimes, do more with AutoShapes if you change them into Pictures.
Scaling and formatting choices are different with pictures.

See all Topics

Thursday, January 26, 2017

Exclude Words

Not every one

Outlook 2007+ uses Word as a Spell Checker. Here’s how to omit certain words from the process. One reason might be to exclude words that are spelled correctly, but are really typos. One example might be Public and Pubic.

See all Topics

Tuesday, January 24, 2017

Custom Functions

Write your own

Excel allows you to create your own functions. If =SUM() is not enough for you, look at this link:

Custom Functions - User Defined Functions

See all Topics

Monday, January 23, 2017

One Summer America, 1927

EVERYTHING happened in the Summer of 1927!

by Bill Bryson

"It’s amazing what a talented writer at the top of his game can do with a seemingly narrow topic. The title of Bill Bryson’s latest sums up the simplicity of his task: to document the “most extraordinary summer” of 1927, beginning with Charles Lindbergh’s successful flight across the Atlantic. 

Even though we know many of these stories--Lindbergh’s flight, Babe Ruth’s 60-homerun season, the Mississippi River flood, Al Capone’s bullet-ridden reign over Chicago--in Bryson’s hands, and in the context of one amazing summer of twentieth-century ingenuity and accomplishment, they feel fresh, lively, and just plain fun. The book is so jammed with “did you know it” nuggets and fascinating origin stories (the opening of the Holland Tunnel, the first Mickey Mouse prototype, the source of the term “hot dog”), the effect is like sitting beside a brilliant, slightly boozy barstool raconteur, who knows a little bit about everything

From a tabloid murder trial to a flagpole-sitting record to the secret origins of the looming Great Depression, One Summer offers a new look at a transitional period in history, re-introducing us to such characters as Capone, Jack Dempsey, Al Jolson, Charles Ponzi, and Herbert Hoover. Ultimately, this is a book about the moment when important things, for good or ill, began happening in the US. With a giddy narrative voice and keen eye for off-kilter details, Bryson has spun a clever tale of America’s coming of age." --Neal Thompson

See all Topics

Sunday, January 22, 2017

Healthy Computing

10 tips

Neck hurt? Wrists ache? Back pain?
Here are some suggestions.


See all Topics

Saturday, January 21, 2017

Access FAQ

What's to know

Some interesting questions answered. Links are included for more detail.


See all Topics