Office Tips and Hints Blog

↑

Home Page

Host your Web site with PureHost!

Wednesday, August 31, 2011 – Permalink –

Quick Subforms and Subreports

Drag 'em on over

When you need to create a subform or subreport, you probably use the Subform/Subreport tool from the Toolbox to draw where you want to add the control.

You can also create subform and subreports using drag and drop.

Simply open the main form or report in Design view, then drag the appropriate form or report from the Database window to where you want the control created.

Note that you'll still need to set Link Child Fields and Link Master Fields properties on the new control.

See all Topics

Labels: Access

<Doug Klippert@ 3:06 AM

Comments: Post a Comment

Tuesday, August 30, 2011 – Permalink –

Curly Quotes be gone

Stop them up front

Word, by default, uses curly (“ ”) rather than straight quotes(" ").

Here's an article that shows how to go into Word options and turn this Auto feature off.

Next we need to turn off Moe and Larry

Curly quotes

See all Topics

Labels: Word

<Doug Klippert@ 3:02 AM

Comments: Post a Comment

Monday, August 29, 2011 – Permalink –

Tweak Vista-Windows

Tune-up suggestions

There are third party apps that you can use to improve Windows/Vista's performance. If you want to do it on your own, here are some Redmond suggestions:

Delete programs you never use
Limit how many programs load at startup
Defragment your hard drive
Clean up your hard disk
Run fewer programs at the same time
Turn off visual effects
Restart regularly
Add more memory
Check for viruses and spyware
Check your computer’s speed
Disable services you don’t need
Don’t settle for slow

Optimize Windows Vista

Also:

TweakHound

Tweaking Windows 7

Optimize Windows 7

See all Topics

Labels: Vista, Windows

<Doug Klippert@ 3:09 AM

Comments: Post a Comment

Sunday, August 28, 2011 – Permalink –

Bartleby Quotations

Wha'd I say

Churchill, Winston S.: ..."man will occasionally stumble over the truth, but usually manages to pick himself up, walk over or around it, and carry on."

Here are a few of one hundred + reference sources available free:

Bartleby.com

American Heritage Collegiate Dictionary
Brewer's Phrase & Fable
Bulfinch's Mythology
Cambridge History
Columbia Encyclopedia
Columbia Gazetteer
Dickinson, E.
Einstein's Relativity
Eliot, T.S.
Farmer's Cookbook
Fowler's King's English
Gray's Anatomy
Lawrence, D.H.
Mencken's Language
Oxford Shakespeare
Presidential Inaugurals
Roget's Thesaurus
Strunk's Style
The King James Bible

Also see: Project Gutenberg

Quotes: Yahoo Reference

See all Topics

Labels: Addendum

<Doug Klippert@ 3:21 AM

Comments: Post a Comment

Saturday, August 27, 2011 – Permalink –

Filter Multiple Fields

Table sorts

In a table's Datasheet view, you can filter multiple selections in a few simple ways.

In the first method, you select one of the fields you want to filter by and click the Filter By Selection button on the toolbar. Access filters the records by that selection. Next, select the second field you want to filter by and click the button again. Access filters the records even further by this second selection. Continue to follow these steps until you have filtered by the desired number of selections.

You can also use Filter by Form. Click the icon on the toolbar. In the displayed form, enter the criteria. You can use And/Or statements, such as "Boston" Or "San Francisco".
(Access will enter the quote marks for you.)

For the third option, you use the Advanced Filter>Sort feature. To do so, select Records>Filter>Advanced Filter>Sort from the menu bar. Access displays a grid similar to the Query By Example grid. Now, drag down all the fields you want to filter by from the field list. Then, in the Criteria cells enter the values you want to filter for. When you have finished, click the Apply Filter button to see the results.

Fourth, you could use Filter by input. Right click any entry in a field you want filtered. Enter the value in the Filter For box and hit Enter. You could then choose another field and sort again by another criteria.
Creating a Query would let you save your filter, but these methods can be used to quickly display the desired information in a table.
(In 2007 these options are on the Home tab in the Sort & Filter group)

Florida Gulf Coast University:
Sorting and Filtering

eHow.com:
How to Filter Records in a Microsoft Access Table

Microsoft Kb:
How to filter records in an Access database

See all Topics

Labels: Access

<Doug Klippert@ 3:10 AM

Comments: Post a Comment

Friday, August 26, 2011 – Permalink –

Google Hear em See em

Accessible searching

Google appears to have a tool or mini app for almost anything.
Here are some of their answers to making information available to the greatest number of people.

(look at 1-800-GOOG-411)

Web Search:
Accessible Search: Promotes results that are accessible.
Book Search:
Gmail:
Gmail Mobile: A lightweight user interface that is also speech-friendly.
Google Maps: Easy-to-use textual directions.
Calendar:
Audio Captchas:
Mobile Transcoder:
Google Video:
Google Talk:
1-800-GOOG-411:

Accessibility Services

See all Topics

Labels: Internet

<Doug Klippert@ 3:15 AM

Comments: Post a Comment

Thursday, August 25, 2011 – Permalink –

Capable Egg

By Lullaby Baxter Trio

ASIN B000046S0B
Atlantic 2000

About the Artist
Lullaby Baxter (Angelina Iapaulo) is neither fish nor fowl.

"Lullaby Baxter's story couldn't be better: A onetime topless DJ at a Toronto club, Baxter (Canadian-born Angelina Teresa Iapaulo) was discovered when she impulsively sang at an open-mic night.

Her backing band couldn't be better, either: The Oranj Symphonette .Baxter brings to her music torch-song gentility.

"Rooster In Love" is a barnyard-romance yarn that may not be metaphor, while "Mama (Should I Bake A Cherry Pie And Hide You Inside?)" is told from the perspective of a fretting child trying to save mom from some dire, rapidly approaching fate.

"Morty Mort-Morton Showstopper Calhoun," "Knucklehead," and "Ding-A-Ling" are teasing schoolyard chants, while "Mr. Powder-Blue Breadbox," "Horsey Don't Snore," and "The Chatterbox Chronicles" are full of surreal twists worthy of Lewis Carroll.

Capable Egg presents a strange world populated by even stranger people, but Lullaby Baxter Trio's grip on its eccentric material is remarkably restrained and mysteriously magnetic."

Recording Description
Good sound quirky lyrics.

Contents

1. Hopscotch
2. Anyway Song
3. Knucklehead
4. Rooster in Love
5. Mr. Powder-Blue Breadbox
6. Chatterbox Chronicles
7. Mama (Should I Bake a Cherry Pie and Hide You Inside?)
8. Ding-A-Ling
9. Morty-Mort-Morton Showstopper Calhoun
10. Spacegirl
11. Horsey Don't Snore
12. Lullaby
13. Ding-A-Ling (Reprise)

Also see:
Lullabyandgoodnight

See all Topics

Labels: Addendum, Music

<Doug Klippert@ 3:06 AM

Comments: Post a Comment

Wednesday, August 24, 2011 – Permalink –

Email Access Form

Question and collection

Access 2007-10 has a wizard that will walk you through the process of sending an information gathering form through Outlook. The wizard is on the External Data tab in the Collect Data group.

"You begin with the Collect Data Through E-mail Messages Wizard, which guides you through the steps of creating a form.

The form is sent through Microsoft Office Outlook 2007-10 to your recipients, with your request for new or updated information.

When the recipients reply to your message, Access automatically enters their data into your database.

Collect data by using e-mail

See all Topics

Labels: Access, Outlook

<Doug Klippert@ 3:22 AM

Comments: Post a Comment

Tuesday, August 23, 2011 – Permalink –

Split the Costs

Split the sheets (?)

Joe Chirilov presents a spreadsheet solution to a friendship breaker.

Recently a large group of friends and I went on a multi-city tour of Europe that lasted a couple weeks. There was a lot of planning that went into this trip and responsibilities for booking different legs of the trip were spread out across the group. How do you efficiently handle paying back multiple people while getting reimbursed for your costs at the same time?

Split Costs
You can download the spreadsheet here:Split_Costs.zip

See all Topics

Labels: Excel

<Doug Klippert@ 3:29 AM

Comments: Post a Comment

Monday, August 22, 2011 – Permalink –

Hi Ho the Visio

Free Demos and templates

Have you ever played with Visio?
This site provides demos. Templates and trials.

These templates are available:

Sarbanes-Oxley Pivot Diagrams
Help Desk Flow

"Here you will see the six data collection points for this example help desk. Call volumes, wait times, and resolution rates are tracked at each point in the process. The diagram flows from left to right and top to bottom. Not every caller will experience each of the steps, if a problem is resolved by a Level One technician, then the caller does not progress to the Level Two technician.
Fault Tree Analysis
PC Assembly Process Flow
Supply Chain Analysis
Value Stream Mapping
Factory Floor Assembly Plan
Loan Consolidation Process
Investment Analysis Report
HVAC Controls
Military Organization Chart
Network Equipment Rack
Insurance Claims by State
Audit Process
Office Space Planning

Visio Toolbox

See all Topics

Labels: Addendum

<Doug Klippert@ 3:05 AM

Comments: Post a Comment

Sunday, August 21, 2011 – Permalink –

Web Accessibility

Make it easy

Accessibility features in FrontPage

"Accessibility, the design of HTML documents for accessibility by people with disabilities, is such an important aspect of the Internet today that the Worldwide Web Consortium (W3C) has adopted a set of guidelines for designing accessible Web sites. The Web Content Accessibility Guidelines (WCAG) closely follow Section 508 of the U.S. Rehabilitation Act.

For some Web sites, adherence to the WCAG is not optional; it is a necessity. Expression Web/FrontPage 2003 has tools for evaluating the accessibility of an entire Web site, identifying elements that violate the guidelines, and finding ways to correct the violations. The accessibility checker provides all of this functionality in a single dialog box.

To access the accessibility checker on the Tools menu click Accessibility (Accessibility Reports). You can use the accessibility checker to check a single page or an entire Web site. The accessibility checker checks for varying levels of accessibility and specifically for adherence to Section 508 of the U.S. Rehabilitation Act. You can check for errors or warnings, and you can add a manual checklist."

Expression Web Accessibility

MSDN:
Adding Rules to the Accessibility checker

Making Your Web Site Accessible to the Blind
Cynthia Says

See all Topics

Labels: Expression Web, FrontPage, Internet

<Doug Klippert@ 3:13 AM

Comments: Post a Comment

Saturday, August 20, 2011 – Permalink –

You are what you eat - with

Old Food Tools

Even before we had Ron Popeil to provide our cutlery, there were knives, spoons, and later forks.

California Academy of Sciences:
The History of Eating Utensils

A History of Eating Utensils in the West:
A Brief Timeline

"Henry Petroski, in The Evolution of Useful Things, makes the argument that it is not so much that necessity is the "mother of invention" as that invention takes place in response to dissatisfaction at the shortcomings of an already existing way of doing things.

The eating utensils we use and the ways we use them are the result of centuries of experimentation."

Medieval and Renaissance Eating Utensils and "Feast Gear"

Ron Popeil (aka Ron "But Wait!" Popeil)

"Born in 1935, he was for all practical purposes orphaned three years later when his parents divorced and he and his brother were shunted to a boarding school in upstate New York.

The one memory of this period is of a Christmas when parents were taking their children home for the holidays. Ron peered through a window at the long, straight road leading to the school, hoping to see his father's car approach. It never did."

See all Topics

Labels: Addendum

<Doug Klippert@ 3:18 AM

Comments: Post a Comment

Friday, August 19, 2011 – Permalink –

Task Manager

When your machine has the snivels

There's a lot of stuff going on in the background that you might want to know about.

That's where the Task Manager comes in.

"There are a couple of ways to show the Windows Task Manager: hold down the Ctrl and Alt keys and press the Delete key - Task Manager will then open some versions of Windows, in others you will be presented with a small dialog box that has a button you can click to open the Task Manager; alternatively you can right-click on empty space on the Taskbar and select Task Manager from the menu."

Here's the Vista/Windows 7 version:

From the BloodyComputer:

Task Manager 1

Task Manager 2

See all Topics

Labels: Windows

<Doug Klippert@ 3:52 AM

Comments: Post a Comment

Thursday, August 18, 2011 – Permalink –

Slideshow Accesability

Hearing and vision enhanced

Dave Paradi has an article about how to design PowerPoint shows for those with limited hearing or vision.

With PowerPoint presentations becoming more of a standard way to communicate information of all types, we need to keep in mind that our first responsibility is to our audience. We need to use the ideas above to make sure that we make our presentation accessible for everyone.

Making Accessible Slides

See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:49 AM

Comments: Post a Comment

Wednesday, August 17, 2011 – Permalink –

Mail Your Calendar

Save a calendar as an iCalendar file

In Calendar, select a calendar to make it the active calendar in the view.
On the File menu, click Save As.
Type a name for the iCalendar file in the File name text box.
A summary of the calendar name, date range, and detail level appears next to More Options.
From the Date Range list, choose the amount of calendar data to include in the iCalendar file, or click Specify dates to enter a custom date range.
From the Detail list, choose the amount of detail to show the recipients.
Optionally, click Show to see Advanced options.
Click OK, and then click Save.

E-Mail Calendar

Share a calendar

Share Outlook

See all Topics

Labels: Outlook

<Doug Klippert@ 3:15 AM

Comments: Post a Comment

Tuesday, August 16, 2011 – Permalink –

Migrate to Word 2007-10

Move the parts.

If you've been having trouble with converting to Word 2007, this might help.

This topic discusses migration considerations for Microsoft Office Word 2007, including:

Migrating files to the new file format
Migrating AutoText entries
Migrating customizations
Migrating Add-ins
Migrating AutoCorrect entries
Migrating the data key

Microsoft - Migration considerations

Changes in Word 2010

See all Topics

Labels: Word

<Doug Klippert@ 3:28 AM

Comments: Post a Comment

Monday, August 15, 2011 – Permalink –

Page-break CSS

Before or after

You can put a break on a web page like you can in a document.
A Cascading Style Sheet makes it simple

"The stub-ends left when paragraphs end on the first line of a page are called widows. They have a past but not a future, and they look foreshortened and forlorn."

Orphans are parts of a paragraph that begin on the previous page. An orphan has a future, but no past.

The only paging properties supported by Internet Explorer 7, Safari 3 and Firefox 2 are page-break-before and page-break-after.
The page-break-before and page-break-after properties enable you to say that a page break should occur before or after the specified element. The following example starts a new page every time an h1 heading is encountered and after every .section block.
h1 {
page-break-before:always }
.section {
page-break-after:always}

Etiquette of Pagination

See all Topics

Labels: Expression Web, HTML

<Doug Klippert@ 3:19 AM

Comments: Post a Comment

Sunday, August 14, 2011 – Permalink –

Replace Fonts

A type change

PowerPoint has a feature that allows you to replace any of the fonts being used in a presentation
You may want to do this to change the look of a show, or because the type face is not available on another machine and not embeddable.
Go to Format>Replace Fonts.

Choose one of the fonts you are currently using and its replacement.

Look over your presentation before saving it. Sometimes a different font will change the spacing on a slide. You may have to reformat a few slides

RDP Slides.com:
Troubleshoot font problems

Informit.com:
Working with Text in PowerPoint

See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:48 AM

Comments: Post a Comment

Saturday, August 13, 2011 – Permalink –

Convert Access macros to VBA

Macros to Modules

Before Access 2000, the speculation was that Access would lose "Macros" and enter the exclusive world of VBA. It hasn't happened yet.

If you have macros in a database that you would like to convert to code, doing so is easy.

In Access 97: Right-click on the macro in the Database window and then choose Save As/Export from the shortcut menu. Then, select the Save As Visual Basic Module option button and click OK. You are then given the option of adding error handling functions and comments to the new module. Select the options you want and click Convert.

In Access 2000/2002+: Right-click on the macro in the Database window and then choose Save As from the shortcut menu. Enter the name of the module you want to create in the text box and choose Module from the As dropdown list. Next, click OK. You will be given the option of adding error handling functions and comments to the new module. Select the options you want and click Convert.
In 2007 go to Database Tools and look in the Macros group.

Sam's Publishing:
Taking More Control of Access
By Gordon Padwick.

Access 2007 introduces a new type of macros called embedded macros. Embedded macros are macros that are stored on an event instead of as a separate object. Embedded macros support name fix-up and are used extensively through-out our templates. They are largely targeted to information workers that don’t write code but useful for developers that are trying to perform some simple actions.

See all Topics

Labels: Access

<Doug Klippert@ 3:03 AM

Comments: Post a Comment

Friday, August 12, 2011 – Permalink –

Itsy Spitfires

Bitsy bombers

Here's a collection of paper airplanes that will get you expelled/fired any day of the year.

"They're cute. They're zippy. They're the ultimate time-wasters. Created by paper airplane world record holder and engineer Jeff Lammers, authors of the World Record Paper Airplane series, this calendar features a full year of palm-sized flying machines and detailed folding instructions. Perfect for stirring up a little mischief at the office. 4 1/2" x 5 1/2".

See all Topics

Labels: Addendum

<Doug Klippert@ 3:58 AM

Comments: Post a Comment

Thursday, August 11, 2011 – Permalink –

What the ####

Truncated Numbers

Access has a new option that will show octothorps when the column is too narrow to display the entire value. When this option is not enabled, you see only part of the values in a column rather than ####.

You'll find the selection under Access Options when you click the Office button.
Go to Current Database and make your choice.

See all Topics

Labels: Access

<Doug Klippert@ 3:47 AM

Comments: Post a Comment

Wednesday, August 10, 2011 – Permalink –

Font Lister

A look see

I haven't seen, lately, how many fonts you can have on a machine, but I know it's a lot more than earlier versions.

Here is a free download that will create an HTML file that will show all the fonts installed on your computer.

"Using FontList, you can change the predefined sample text, exclude seldom used fonts from the list and change the path for the HTML file.

In your browser, you can change the style of a font and zoom in on a font. You can also view the character map of a font. And, for some, maybe the most important feature, you can create a print out of all your fonts.

FontList

See all Topics

Labels: Word

<Doug Klippert@ 3:21 AM

Comments: Post a Comment

Tuesday, August 09, 2011 – Permalink –

Is Phishing Phat

Hand over the keys

The scofflaws of the world are littering e-mail boxes with fake messages that look like the real thing. They're fishing for your bank account keys.

A company named MailFrontier.com has an anti-spam/anti-phishing product. They also have a collection of Phish mail with instructions about how to respond.

Email Threat Info Center

Take a phishing IQ test at SonicWALL Phishing IQ Test

(These are BabyPhat socks. As far as I know they're both real and pfat)

See all Topics

Labels: Outlook

<Doug Klippert@ 3:39 AM

Comments: Post a Comment

Monday, August 08, 2011 – Permalink –

Match Format Paste

Copy/Paste formatting in Word, PowerPoint or Excel

When you copy information from a Web page or another document, the formatting will also be copied.

To match the formatting of the target document, copy the text and place the cursor where you want to insert the copy.

Then, go to Edit>Paste Special, and select the Unformatted Text option.
(Click the arrow under Paste in the Clipboard group on the Home tab in 2007)

The clipboard text will be pasted to match the target.

Another way when using Word 2002 + is to click on the "Smart icon" that appears at
the lower right corner of the pasted text. You can then choose to keep the original formatting, match the destination formatting, keep text only, or apply a new style.

An additional way to transfer just the formatting between documents is to highlight the text with the formatting you wish to copy and then hold down the Ctrl key and the Shift key and press the C key (Ctrl+Shift+C). Release the keys. Select the text you want to have formatted. Hold down the Ctrl key and the Shift key and press the V key (Ctrl+Shift+V). Only the formatting is copied, not the text.
In Excel use Edit>Paste Special and select the "Formats" option.

TechTrax:
What's So Special About "Paste Special"?
by Linda Johnson, MOS

Paste Special can also be used with graphics.

You can change Word's default behavior; choose whether to paste Inline or Floating.

Microsoft Word MVPS FAQ

See all Topics

Labels: Word

<Doug Klippert@ 3:58 AM

Comments:

when we use shortcuts in micro soft office so it makes our work more easy and we easily perform a task with out selecting a tool from a deep directory like insert, edit, view etc, And when we want to perform it again and again so it become more difficult ...
Performing Arts Schools

# posted by

sologake : 8/09/2011

But one thing which is easy to use and easy available is Google docs and i think it is one of the best tool which provide us an online spreadsheet and this type of other services like ms world ...
Vertical Jump Bible

# posted by

kuntsh : 10/21/2011

Spreadsheet Diet

Formatting bloat

Avoid applying formatting to more than just the active area of your worksheet. Extraneous formatting will confuse Excel about the last cell in the spreadsheet.

Depending on your OS and specific configuration, you could see symptoms ranging from Excel not responding to various error messages concerning page faults, low virtual memory, and access violations. You may see a warning message; "Too many different formats."

To resolve this issue, make sure you select only the particular range of cells you want formatted when you apply specific formatting or select Format>AutoFormat.

You can use Ctrl+End to see where Excel thinks the last cell is.

For more information, check out:

How to reset the last cell in Excel

Microsoft Knowledge Base article 211478

Also see:

Spreadsheet Diet

Beyond Technology:
Identifying the Real Last Cell

Microsoft:
Formatting Cleaner Add-in

See all Topics

Labels: Excel

<Doug Klippert@ 3:35 AM

Comments: Post a Comment

Saturday, August 06, 2011 – Permalink –

Reading Level Check

Abrogate Obfuscation

Writing a blog or designing a web page should be done with an eye on the complexity of the language.

For broadest appeal, it should be around an 8th grade level.

This site is at about the 10th grade.

Reading Level

(Avoid one of the reading level sites that offers to put a graphic on your site. The icon links to an ad for "payday" loans.)

See all Topics

Labels: Expression Web, FrontPage, HTML, Internet

<Doug Klippert@ 3:07 AM

Comments: Post a Comment

Friday, August 05, 2011 – Permalink –

Rename Files

Add Info

When you download pictures from your digital camera, they end up with incomprehensible name such as IMG_0284.JPG, or _MG_2640.CR2.

To make them more useful:

Select all those files from Xmas. You can use Ctrl to group them, or use Ctrl+A to select all the files in that folder.
Right click the selection and choose Rename.
Pick a descriptive title, such as 2007 Xmas Party.
Hit Enter
All of the selected files will be renamed "2007 Xmas Party.JPG”, "2007 Xmas Party.CR2”, "2007 Xmas Party(2).JPG”, "2007 Xmas Party(2).CR2”, "2007 Xmas Party(3).JPG” "2007 Xmas Party(3).CR2”.

The extensions will remain the same.

See all Topics

Labels: Windows

<Doug Klippert@ 3:21 AM

Comments: Post a Comment

Thursday, August 04, 2011 – Permalink –

Picture on the Cover

Bigger than Life (or Newsweek)

You can put your own picture, or one you like, on the cover of any one of a dozen magazines.

Create Fake Magazine Covers with your own picture at MagMyPic.com

See all Topics

Labels: Addendum

<Doug Klippert@ 3:12 AM

Comments: Post a Comment

Wednesday, August 03, 2011 – Permalink –

Copy Access Data to New Records

Fewer steps

The Paste Append feature is often overlooked in Access.

This feature lets you quickly create new records that copy existing information from other records.

To see one way to use the feature, open a table in Datasheet view.

While holding down the [Shift] key, select adjacent fields with data you want to copy. You can also select fields from adjacent records.
When you've finished, press Ctrl+C to copy the data.
Then, choose Edit>Paste Append (Paste>Paste Append in 2007)
Click Yes when Access asks for confirmation.

You'll now have an appropriate number of new records in the table that contains the information you copied.

See all Topics

Labels: Access

<Doug Klippert@ 3:24 AM

Comments: Post a Comment

Tuesday, August 02, 2011 – Permalink –

Trail Trikes

Recumbent transportation

Greenspeed

SolarTrike:
Solar powered trike
30miles per hour - 10mile range

Catrike

See all Topics

Labels: Addendum

<Doug Klippert@ 3:32 AM

Comments: Post a Comment

Monday, August 01, 2011 – Permalink –

Security Questions

2009-2010

This article provides an overview of the security features offered by Access 2009-2010, and explains how to use the tools that Access provides for helping to secure a database. This article also links to more detailed content about various security features.

What's new in Access security
Use an Access database in a trusted location
Package, sign, and distribute an Access 2010 database
Enable disabled content when you open a database
Use a database password to encrypt an Access database
How security works with databases from earlier versions of Access opened in Access 2010
Run unsafe expressions (disable sandbox mode)

Introduction to Security

See all Topics

Labels: Access

<Doug Klippert@ 3:57 AM

Comments: Post a Comment