Tuesday, February 28, 2017

Monday, February 27, 2017

Sunday, February 26, 2017

Snow Flakes


Your online guide to snowflakes, snow crystals, and other ice phenomena ...


See all Topics

Saturday, February 25, 2017

Count Unique

Distinct entries

A common query is needed to determine the number of different items in a data base. Here is the code:


See all Topics

Friday, February 24, 2017

Charts and Tables


Word 2007-13 handles charts in a different manner than previously. The Excel Charting program is used instead of MSGraph.

Word Ribbon Tips

See all Topics

Thursday, February 23, 2017

Reliability Monitor

Track the behavior of your system

"This utility provides you with a canned set of preconfigured counters that you can easily use to monitor the reliability of your system over time. An overview of Windows Reliability Monitor and show you how to use its System Stability Chart to track the behavior of your system over its lifetime."

Windows 10

See all Topics

Wednesday, February 22, 2017

Sliding Slide Show


  • The Push Left slide transition
  • A background with no vertical borders
  • One or two continuous horizontal lines
  • Other optional horizontal elements


See all Topics

Tuesday, February 21, 2017

Resolve Names

CC search

”When you have more than one Contacts folder or address list enabled as an address book Outlook will use the folder when it resolves names provided it's on the check names list.

When you type a name in the To, CC or BCC fields, Outlook begins searching in the address list at the top of this list and works its way down the folders on the list, until it finds a match. For example: if you type Bill in the To field and have Bill Smith in the first contacts folder and Bill Jones is in the second folder on the list, typing just Bill will resolve to Bill Smith. You'll need to type Bill J to resolve to Bill Jones, or reorder the list.

If names in the address book are not resolving, open the address book
(Ctrl+Shft+B) and look on its Tools, Options menu. If the contacts folder is not listed in the 'When sending mail, check names using these addresses in the following order:' dialog, you'll need to click Add to add it to the list.”
Diane Poremsky


See all Topics

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