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