Wednesday, December 31, 2014

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

Tuesday, December 30, 2014

Tweak Windows

Tune-up suggestions


There are third party apps that you can use to improve Windows' 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

Also:  

TweakHound 



See all Topics

Monday, December 29, 2014

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 



See all Topics

Sunday, December 28, 2014

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

Saturday, December 27, 2014

Google Here 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:

    Result pages include headers to delineate logical sections.

  • Accessible Search:
    Promotes results that are accessible.

  • Book Search:

    Full-text access to public-domain works.

  • Gmail:

    A simple yet functional HTML mode that works well with screen readers
    .
  • Gmail Mobile:
    A lightweight user interface that is also speech-friendly.

  • Google Maps:
    Easy-to-use textual directions.

  • Calendar:
    A functional, yet speech-friendly user interface.

  • Audio Captchas:

    All services that use Google Accounts provide an audio alternative for the visual challenge-response tests that are used to distinguish humans from machines.

  • Mobile Transcoder:

    A mobile lens for viewing the web that produces accessible views.

  • Google Video:

    Allows uploaded videos to contain captions/subtitles in multiple languages for viewers who are hearing-impaired or unfamiliar with the original language.

  • Google Talk:

    IM clients inside a web browser can pose accessibility challenges, but the use of the open Jabber API means that Google users can choose from a variety of Jabber clients, many of which work well with adaptive technologies.

  • 1-800-GOOG-411:

    Here's an exception to the rule that we deliver most things through a web browser. Our experimental Voice Local Search service lets anyone who can speak into a phone search for a local business by name or category; get connected to the business free of charge; get the details by SMS if you’re using a mobile phone. (Just say "text message".)

Accessibility Services



See all Topics

Friday, December 26, 2014

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:
Lullaby and goodnight



See all Topics

Thursday, December 25, 2014

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

Wednesday, December 24, 2014

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 a spreadsheet or watch a video here:
Split_Costs.zip



See all Topics

Tuesday, December 23, 2014

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

Monday, December 22, 2014

Web Accessibility Checker

Make it easy



"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
Test your site:
Cynthia Says



See all Topics

Sunday, December 21, 2014

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

Saturday, December 20, 2014

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

Friday, December 19, 2014

Slideshow Accessibility

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

Thursday, December 18, 2014

Mail Your Calendar

Save a calendar as an iCalendar file


  1. In Calendar, select a calendar to make it the active calendar in the view.

  2. On the File menu, click Save As.

  3. Type a name for the iCalendar file in the File name text box.

  4. A summary of the calendar name, date range, and detail level appears next to More Options.

  5. 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.




  6. From the Detail list, choose the amount of detail to show the recipients.
    Optionally, click Show to see Advanced options.

  7. Click OK, and then click Save.
E-Mail Calendar 

Share a calendar  

Share Outlook



See all Topics

Wednesday, December 17, 2014

Migrate to Word 2007+

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 Office 2013



See all Topics

Tuesday, December 16, 2014

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

Monday, December 15, 2014

Convert 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

Sunday, December 14, 2014

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.


Pearson Informit:
Taking More Control of Access
By Gordon Padwick.


Access 2007 introduced 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

Saturday, December 13, 2014

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".



365 Tiny Paper Airplanes Calendar 2011



See all Topics

Friday, December 12, 2014

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

Thursday, December 11, 2014

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

Wednesday, December 10, 2014

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 Sophos.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

Tuesday, December 09, 2014

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.


What's So Special About "Paste Special"? Video

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

Monday, December 08, 2014

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

Microsoft:
Formatting Cleaner Add-in



See all Topics

Sunday, December 07, 2014

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

Saturday, December 06, 2014

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:


  1. 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.

  2. Right click the selection and choose Rename.

  3. Pick a descriptive title, such as 2014 Xmas Party.

  4. Hit Enter

  5. All of the selected files will be renamed "2014 Xmas Party.JPG”, "2014 Xmas Party.CR2”, "2014 Xmas Party(2).JPG”, "2014 Xmas Party(2).CR2”, "2014 Xmas Party(3).JPG” "2014 Xmas Party(3).CR2”.

    The extensions will remain the same.




See all Topics

Friday, December 05, 2014

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.
  1. While holding down the [Shift] key, select adjacent fields with data you want to copy. You can also select fields from adjacent records.
  2. When you've finished, press Ctrl+C to copy the data.
  3. Then, choose Edit>Paste Append (Paste>Paste Append in 2007+)
  4. 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

Thursday, December 04, 2014

Wednesday, December 03, 2014

Security Questions

2009-2013

This article provides an overview of the security features offered by Access 2009-2013, 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

Monday, December 01, 2014

PowerPoint Pundits

Connect with other PowerPoint users


Microsoft has put together a list of locations, forums, blogs, etc. that cover PowerPoint.

You'll probably find that your question has been answered at one of these spots.

Office.Microsoft.com



See all Topics