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

Friday, January 20, 2017

Make Templates

How to

This link tells what you need to know to create templates for your own or organizational use.


See all Topics

Thursday, January 19, 2017

Background Sound

All the way through

In some circumstances you may want music to play throughout the presentation.


See all Topics

Wednesday, January 18, 2017

Lines next to response

Choose your mark

Don’t like those vertical lines next to an e mail response?


See all Topics

Tuesday, January 17, 2017

Blog Control


Using CSS on Blogs is not difficult. Here is a site that shows how to do many things including using different background images for different times of day.


See all Topics

Monday, January 16, 2017

Need a Doctor?

Look up site

”Celebrating its 20th Anniversary in 2016, the AIM DocFinder was the only online physician directory of its kind when it was launched in 1996. The DocFinder is still recognized for its easy to use search engine. DocFinder remains the only combined database of all licensing jurisdictions that has its direct source of data from and controlled by state licensing boards and remains free of charge to the public.”


See all Topics

Sunday, January 15, 2017

Auto Space Controls

Even it out

Access' automatic control spacing feature easily adjusts the horizontal or vertical distance between controls. Learn more in this tip.


See all Topics

Saturday, January 14, 2017

Line Numbers

Count them all

  1. In Word, click Page Layout (File > Page Setup).

  2. Click Line Numbers.

  3. Choose Line Numbering Options.

  4. Click Line Numbering . . . .

  5. Put a check in the box labeled "Add line numbering."

  6. Set "Start at" to 1, "From text" to "Auto," and "Count by" to 1.

  7. Under "Numbering" select "Restart each page."

  8. Click OK.

  9. Click OK.

  10. Make sure you're looking at Print Layout.

See all Topics

Friday, January 13, 2017

Edit Control Panel

Add items

”Have you ever wondered where the Display Settings icon or Network Connections folder went in the Control Panel’s Classic View? For that matter, why can’t you search for them using the start menu search? Because they are prohibited from loading in the registry - that’s why.”


See all Topics

Thursday, January 12, 2017

PPT Photo Album


How to use PowerPoint to create a photo album.
In this article:

Step 1 – start a photo album
Step 2 – insert pictures
Step 3 – create the album layout
Step 4 – create titles and subtitles
Step 5 – format pictures
Step 6 – edit the photo album

Create a photo album in PowerPoint in 6 steps

See all Topics

Wednesday, January 11, 2017

Increase DLs

More bits

This is a registry hack that controls the number of downloads you can have at one time.


See all Topics

Tuesday, January 10, 2017

Mail a Range

Combine Excel and Outlook

"The subs will send a newly created workbook with just the visible cells in the selection or range.
The cells will be PasteSpecial as values in the workbook you send. 
It saves the workbook before mailing it with a date/time stamp. 
After the file is sent, the workbook will be deleted from your hard disk."

See all Topics

Monday, January 09, 2017

How to Lace Shoes

Two trillion Ways

Forget about Velcro. Here are 33 illustrated ways to lace your shoes.


See all Topics

Sunday, January 08, 2017

Change Splash

Make it your own

A splash screen appears when you start Access. Here is how to customize what is displayed.

Adding Splash

See all Topics

Saturday, January 07, 2017

Barcodes in Word

Print your own

Printing bar codes in Microsoft Word documents.



See all Topics

Friday, January 06, 2017

Time to Dump PowerPoint

Presentation questions

"One of the findings mentioned in the article: it is more difficult to process information if it is coming at you both verbally and in written form at the same time."

See all Topics

Thursday, January 05, 2017

Hold Back the Mail

Timing is everything

Outlook allows you to choose when your mail is sent. For instance, set up a birthday greeting ahead of time so you will not forget it.


See all Topics

Wednesday, January 04, 2017

CSS Templates

Free samples and suggestions

"Solucija offers a selection of some of the most popular web templates available today. Whether you're looking for a free web template, premium one, or an inspiration - you'll find it here. All our templates are hand coded, standards compliant and can be easily used as a standalone templates or in combination with CMS to create a fully dynamic site."


See all Topics

Tuesday, January 03, 2017

Spreadsheets in Education

Samples and papers

"SIE is an electronic journal devoted to the publication of quality refereed articles concerned with studies of the role that spreadsheets can play in education. Our aim is to provide a focus for advances in our understanding of the role that spreadsheets can play in constructivist educational contexts.
Spreadsheets in Education (eJSiE) is a free facility for authors to publish suitable, peer reviewed articles and for anyone to view and download articles."


See all Topics

Monday, January 02, 2017

Sgt. Pepper

If you're old enough

The Oxford Dictionary presents an interactive version of the cover.
Oxford Dictionary of National Biography

See all Topics

Sunday, January 01, 2017

Package up Runtime

Runtime solutions

"The Package Solution Wizard provides a simple way to bundle and deploy Office Access 2007-13 database applications. The wizard guides you through the steps that are required to bundle stand-alone Access 2007-13 applications into deployment packages. You can use the Package Solution Wizard to include the Access 2007-13 Runtime in your packages and to create shortcuts that start the appropriate Access file. The output of the Package Solution Wizard is a Windows Installer (.msi) Setup file that guides users through the installation of your Access application."


2013 Runtime

See all Topics