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

Saturday, December 31, 2016

Autofit Table

Fit to page

Select the table and right-click.
Scroll to Autofit and then select AutoFit to Window.

Word will automatically adjust the table width to any margin or page orientation changes.

Here are some more table fit suggestions:

See all Topics

Friday, December 30, 2016

Resize Alt-Tab

Registry hack

Here are the instructions about how to size the thumbnails in Vista/Win7 to fit your screens resolution.

Windows 7

See all Topics

Thursday, December 29, 2016

Wednesday, December 28, 2016

Who's to Blame

The hammer or the carpenter?

Farhad Manjoo places the blame where it belongs, the show's producer, not the software.

No More Bullet Points

See all Topics

Tuesday, December 27, 2016

Excel to Outlook

Concatenate Excel Outlook

A common task is to bring a contact list into Outlook from Excel. Usually Excel will have names separated into columns. Other information, such as addresses may also be divided.
Here’s how to format the Excel file for a seamless import.

See all Topics

Monday, December 26, 2016

Ribon Guide


”These interactive guides show you where your favorite menu and toolbar commands are located in Office 2010-13. Just click the command or button that you want to find, and the guide will show you its location in the 2010-13 version of the program.”

See all Topics

Sunday, December 25, 2016


Web monitor

Versionista monitors web sites and alerts you by email of any changes. It also displays the changes visually on the page.
Here's one mention from the news:

Rachel Maddow

See all Topics

Saturday, December 24, 2016

Windows Split

Easy trick

Here's how to split the open window and/or create new windows.


See all Topics

Friday, December 23, 2016

Office 2010-2013

Preview review

Ed Bott has been writing about Office since 1996. Here is his take on the latest version.

Ed Bott Office 2010

Office 2013

Office 2010: Product Guides

Office 2013

See all Topics

Thursday, December 22, 2016

Runtime is Free

No need for Access

"If no end-user customization is required (including report modifications), you may choose to distribute these Access solutions so that they run without requiring a full installation of Access."

Access 2007 Runtime

Access 2010 Runtime

Access 2013 Runtime

See all Topics

Wednesday, December 21, 2016

Set Your Kindle Free


You can program your Kindle to accept screensavers, and other aps.

How to

See all Topics

Tuesday, December 20, 2016

Monday, December 19, 2016

Last Doc Shortcut

Back Quick

"A separate shortcut with a special switch that will open the last document that was open in Word."

Last Document

See all Topics

Sunday, December 18, 2016

Undelete Deletes

Get it back

"It’s happened to most of us. You delete a file and realize you need it back. This guide will explain when you can get that file back and how to go about it."

 How to Recover a Deleted File

See all Topics

Saturday, December 17, 2016

Move Up the Page

The old fingers walking trick

If you want to move words, paragraphs, bullets, up or down the keyboard shortcut is Shift+Alt + Up/Down/ arrow.

See all Topics

Friday, December 16, 2016


Full control

If you are overly confident about your skills, you might want to look at Greg Schultz's discussion on Administrator power.
”You should use the real Administrator account very sparingly - never make it your default modus operandi! Please note that you use this technique at your own risk.”

See all Topics