Tuesday, September 30, 2014

Links to Excel

Spokes of the web


There's a lot of information out there. The problem is how to find it.
Here is a site that contains links to Excel information arranged in topics:

  • Excel Add-ins

  • Excel Help

  • Excel Password Recovery

  • Excel Templates

  • Excel Tips & Tricks

  • Excel Tutorials

  • Excel VBA

  • Free Excel Add Ins

  • Spreadsheet Research
Excel Links



See all Topics

Monday, September 29, 2014

How Many Die

Hospital scorecard


All right, you need that old appendix ripped out; or maybe a hip replacement.

Where do you go if you have a choice?

Here is a collection of hospital performance nationwide that you may find useful.

It will tell you how many patient deaths there are in any one hospital, as well as how well patients are reimbursed.

DartmouthAtlas



See all Topics

Sunday, September 28, 2014

Access Developers Extentions

No cost tool


"The Access Developer Extensions include the following components:

  • Save As Template
    Enables you to create database templates (ACCDTs) that can be featured in the Access 2007 Getting Started screen.

  • Package Solution Wizard
    A wizard that creates a Windows Installer Package (MSI) to install your database and any supporting files and optionally includes the Access 2007 Runtime, or prompts the user to download the Access 2007 Runtime.


  • Source Code Control
    Integration with Microsoft Visual SourceSafe or other source code control systems to allow check-in/check-out of queries, forms, reports, macros, modules, and data. You can also see the differences that have been made to your checked out objects."
 Developers Extensions



See all Topics

Saturday, September 27, 2014

Find Found Things

Where'd it go?



A Research Project of the Information School
at the University of Washington


Keeping Found Things Found™

"What is KFTF?

The classic problem of information retrieval, simply put, is to help people find the relatively small number of things they are looking for (books, articles, web pages, CDs, etc.) from a very large set of possibilities. This classic problem has been studied in many variations and has been addressed through a rich diversity of information retrieval tools and techniques.

A follow-on problem also exists which has received relatively less study: Once found, how are things organized for re-access and re-use later on? What can be done to avoid the need to repeat the process by which the information was found in the first place? (If, indeed, it is possible to repeat this process.) We refer to this as the problem of Keeping Found Things Found™ or KFTF."




See all Topics

Friday, September 26, 2014

Send Access to Word

Reformat reports


Not everyone has Access installed on his or her machine.
Access is not the most versatile instrument for complex formatting.

If you wish to share your findings, Access does have the ability to re-format Reports into Word documents.

Open the Report in Access and go to Tools>Office Links.
One of the choices is to "Publish It with Microsoft Word."
Here's the command in 2007+:



When the data is sent to Word, you will be asked to confirm that you wish to convert the file to "Rich Text Format (RTF)" Click OK.

(RTF is a "universal" format. The Report can be re-saved as a Word "DOC" or "DOCX" file.)

Microsoft KB:
How to send the current record to Word with automation


Use a table or query as a mail-merge data source (2007+)



See all Topics

Thursday, September 25, 2014

Make Your Calendar Your Own

Match your own schedule


". . . did you know that the views in your calendar are fully customizable? For example, you can view your days and weeks in increments of 5 minutes, 60 minutes, and a variety of periods in between.

You can adjust the view of your calendar according to your work week and work day; for instance, you can display Sunday through Thursday and show a normal day as being 11 in the morning to 7 in the evening if you like.

Use different color schemes, and show more or less detail in your calendar. Watch the demo to see how to do all this and more."


Customize your O'07-10 calendar



See all Topics

Wednesday, September 24, 2014

Guide to CSS

Map through the forest


Dustin Diaz:
"OK. Let's set the record straight. There is no official guide for each and every CSS shorthand property value. So let's work together and put one together shall we?

OK. Straight to the business. Anytime I've ran into a specification (besides the confusing mess at the W3C), it turns into showing off a couple of examples and you're supposed to be set on your way.

Well well. Over the years, I've found quite some interesting unknown quirky facts about these shorthands. . . hence this Guide was born."



CSS Guide



See all Topics

Tuesday, September 23, 2014

Chopsticks 101

No need to starve


Little kids eat with chopsticks, surely you can learn how.

Here's a link to seven easy steps.

Chopsticks in Seven Steps

Also:
How to Eat with Chopsticks


Chopstick Kids



See all Topics

Monday, September 22, 2014

First Look at Word 2007-2013

We all have to start somewhere


Here is a 30 minute course:

After completing this course you will be able to:

  • Create and save a document.
  • Accept or reject suggested revisions for spelling and grammar as you type.
  • Change page margins.
  • Adjust spacing by deleting any extra spaces between words or extra lines between paragraphs.
Create your first document in Word

First look at Word 2010

First Look at Word 2013



See all Topics

Sunday, September 21, 2014

Nickname List

Call me Ishmael


How to Reset the Nickname and Automatic Completion Cache


Microsoft Outlook maintains a nickname list that is used by both the automatic name checking and the automatic completion features. The nickname list is automatically generated as you use Outlook.
If the nickname cache is corrupted, Outlook may not be able to identify recipients, may offer incorrect recipients when automatically completing the e-mail address, or may send the message to the wrong person. You may also, just want to reset the whole list.

  1. Quit Outlook.
  2. Start Windows Explorer.
  3. On the Tools menu, click Folder Options, and then click the View tab.
  4. Under Advanced Settings, click to select the Show hidden files and folders check box.
  5. Click OK.
  6. Click Start, point to Search, and then click For Files or Folders.
  7. In the Search for Files or Folders box, type *.NK2 in the File Name box.
  8. In the Look In box, click to select your local hard disk.
  9. Click Search Now.
  10. Right-click the .NK2 file with the name of the profile that you want to reset, and then click Rename.
  11. Rename the file to yourname.bak, and then press ENTER.
  12. Quit Windows Explorer.
  13. Restart Outlook.
Outlook will generate a new nickname cache:
Knowlegebase Article 287623

Slipstick.com:
Name Resolution



See all Topics

Saturday, September 20, 2014

Zip Code Spy

Who's living in your neighborhood?


ZIPSkinny
displays US Census data for any selected Zip code .

You can find out how old your neighbors are and how much money they make.

Find out how many graduated from high school and how many are single.

Here's part of the information available about someone's vacation home.



ZIPSkinny.com



See all Topics

Friday, September 19, 2014

Update Data to Default

Just a keystroke away


You probably know that you can set up a default value for Access to enter into a field when a new record is created. This can be done in the Design view for a table or form by setting the Default Value property.

Unfortunately, you sometimes may set a default value after you've already entered records into the database. When you do so, the existing records aren't automatically updated to equal the new default.

However, if you're editing a record and you want to update the field to the current default, you can do so with a keystroke shortcut. To do so, simply select the appropriate field and press
[Ctrl][Alt][Spacebar]




See all Topics

Thursday, September 18, 2014

Function Toolbar

F what?



In Word 2007+, you can see the shortcut keys by pressing the ALT key.

Word (2002-2003) has a rarely seen "toolbar" that lets you use your mouse to perform function key actions. In addition, when you press Shift you'll see what the Shift + function key combinations do, press Ctrl and you'll see those shortcuts, and so on.

The toolbar is automatically placed at the bottom of the screen (underneath the document area; right above the status bar); like any toolbar, you can drag it and dock to it any side of the screen, or let it float. To display the Function Key Display toolbar:

  1. Go to Tools>Customize.
  2. Select the Toolbars tab, then check Function Key Display
  3. Click the Close button.
Press the Ctrl, Alt, or Shift keys to see the toolbar buttons (shortcut hints) change. Click on the buttons and the appropriate action will be performed.

See:
Allen Wyatt's Word Tips



See all Topics

Wednesday, September 17, 2014

Blog, Wha's a Blog?

Is it Samuel Pepys or Robert Scoble?





Samuel Pepys:
You can subscribe to an RSS feed of daily entries from Pepys' 1660 diary at The Diary of Samuel Pepys.
A new entry written by Pepys will be published each day; 1 January 1660 was published on 1 January 2003.
Robert Scoble, former Microsoft Evangelizer, former blog:
Scobleizer

How your blog will get discovered

Here are some references to Web Logs

MSDN Magazine:

"Q - What is blogging all about?

A - First, "blog" is short for Web log. It's a medium in which an author writes a journal-style Web site with provisions for readers to respond. These Web logs are becoming quite valuable in the software community for sharing ideas."

All About Blogs and RSS

Wikipedia definition




More on RSS (Really Simple Syndication):
RSS News you choose

Also:
Light and Power



See all Topics

Tuesday, September 16, 2014

Data Tables

Up one side; down another



Data tables are a neat Excel feature that has not been emphasized.

If you are looking at, for instance, a home loan with a number of interest rates and different loan periods, a Data table can lay out the results with a minimum of fluff and formulas.

Dick Kusleika, Microsoft MVP, has a description on his excellent Daily Dose of Excel blog.
Data Table Basics

J K Pieterse:
Excel 2007, 2010, 2013 tables

Microsoft:
How to Use Microsoft Excel Data Tables to Analyze Information in a Database
How to Create and Use One-Input Data Tables in Microsoft Excel
How to Create and Use Two-Input Data Tables in Microsoft Excel

Overview of Data Tables - 2003 and 2007

TechRepublic.com:
Teach two-variable Excel data tables with real-life examples



See all Topics

Monday, September 15, 2014

Move the Line

Animate charts


PowerPoint has the ability to present elements of a graph one at a time for dramatic effect.

Here's one take from PPTWorkBench.com:
Complex Animations



This tutorial is an example of making PowerPoint do things that can't normally be done. In this case, we will tweak some chart animations that don't exist under normal circumstances.
  1. Create a chart with data,
  2. Ungroup the chart into individual pieces,
  3. Insert pictures that relate to the data,
  4. Do some grouping + animation.
Also:

Microsoft:
 Animate Chart Elements in Microsoft PowerPoint 

Internet4classrooms.com:
Animating a Chart - Using Ungrouping

Ungroup in 2007+  



See all Topics

Sunday, September 14, 2014

Homepage(s)

Easy links


Sure you have Favorites and you might have shortcuts on your desktop, but you really only use about a dozen sites on a regular basis.

Try out Only2Clicks. You can set up your home page to show graphic links to your major sites and be able to group them by purpose.



Only2Clicks.com



See all Topics

Saturday, September 13, 2014

Photoshop Beginings

Who started it all


"In the fall of 1987, Thomas Knoll, a doctoral candidate in computer vision, was trying to write computer code to display grayscale images on a black-white bitmap monitor.
Knoll thought it had limited value at best. The code was called Display. Knoll wrote it on his Mac Plus computer at home.
Little did he know that this initial code would be the very beginning of the phenomenon that would be known as Photoshop.

Thomas' program caught the attention of his brother, John, who worked at Industrial Light and Magic (the visual effects arm of Lucasfilm, the famous motion picture company founded by George Lucas.
With the release of Star Wars, Lucas had proved that really cool special effects, combined with heroic characters and a "shoot-em up script," could produce a blockbuster motion picture.
To that end, John was experimenting with computers to create special effects. He asked his brother Thomas to help him program a computer to process digital image files, and Display was a great starting point. So began their collaboration."

Photoshop profile

History of Photoshop



See all Topics

Friday, September 12, 2014

Print Raw Data

From reports and forms


Sometimes, you may not want to go to the effort of creating a report; you just need a quick hardcopy of data.

In such cases, you can simply print the Form view of your data. However, doing so also prints the background and shading associated with the form.

If you just need a quick data reference, you probably don't want to waste the resources and time to print such a detailed view. Fortunately, Access has a feature that lets you quickly print just the data from a form or report.

To do so, view the data you want to print in the form or report.

Then, choose:

Office button>Print>Print Preview (File >Page Setup)

select the Print Data Only check box

and click OK.

Doing so hides any graphics, lines, control borders, and label controls so that the print out simply contains data.





See all Topics

Thursday, September 11, 2014

Foxy or Ipsum

=rand(p,s)


In Word 2007+, =rand() produces a selection from the Help file.

=lorem() displays:


Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa. Fusce posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna.
Nunc viverra imperdiet enim. Fusce est. Vivamus a tellus.
Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Proin pharetra nonummy pede. Mauris et orci.


If you want some history, try Lipsum.com



Pre 2007:

To insert practice text in the document, type:
=rand()
and hit the ENTER key.

The whole equation would be:
=rand(p,s)
"p"is for p>aragraphs. "s" is for s>entences.

=rand(2,3)
would produce 2 paragraphs containing 3 sentences each.


It is said that:

The Italian edition of Microsoft Word 2000 produces:
"Cantami o Diva del pelide Achille l'ira funesta."

This is the first line of the Italian translation of Homer's Iliad.

In Spanish it's:
"El veloz murciélago hindú comía feliz cardillo y kiwi."

"The quick Hindu bat ate happy golden thistle and kiwi."

In French it's:
"Servez à ce monsieur une bière et des kiwis."

"Serve this gentleman a beer and some kiwis."

Other Panagrams

Choose Your Ipsum



See all Topics

Wednesday, September 10, 2014

Zoom Box Fonts

Customize



Change the appearance of text in Access' Zoom box

Access' Zoom box, allows you to display the contents of a text box in a dialog box for easier editing and viewing. Although viewing long expressions is more convenient in the Zoom box, it is still sometimes difficult to follow what is displayed due to the font Access uses by default.

Access 20xx allows you to change the font that the Zoom box uses. To display the Zoom box, select the text box you want to expand and press Shift+F2. Then, just click the Font button, set the options you want, and click OK. The settings you select are used whenever you display the Zoom box during your current instance of Access. However, the next time you start Access the Zoom box font settings will revert to their defaults



Zoom Box Font



See all Topics

Tuesday, September 09, 2014

IE Shortcuts

Finger flicks


A selection of keyboard shortcuts for IE 7.

Here are a few:


  • F11 Toggle between full-screen and regular views of the browser window in Internet Explorer

  • ALT + HOME Go to your home page

  • ALT + RIGHT ARROW Go to the next page

  • ALT + LEFT ARROW or BACKSPACE Go to the previous page

  • CTRL+ F Find on this page

  • CTRL + TAB or CTRL + SHFT + TAB Switch between tabs
More:

Browser shortcuts



See all Topics

Monday, September 08, 2014

Clippy's Revenge

Roll your own OA



The Office Assistant has taken a lot of hits, but it is missing in 2007, but still around in earlier versions.
If you want to play with it, see John Walkenbach's:

Create A Fake Clippy



Here is a creature you could use to replace Clippy:

Nerd Bird

There are other articles in the MS library about Agents and Assistants:

Animating Office Applications with Microsoft Agent



See all Topics

Sunday, September 07, 2014

Numbers in Perspective

Visual concepts


"This new series looks at contemporary American culture through the austere lens of statistics. Each image portrays a specific quantity of something: fifteen million sheets of office paper (five minutes of paper use); 106,000 aluminum cans (thirty seconds of can consumption) and so on.

This project visually examines these vast and bizarre measures of our society, in large intricately detailed prints assembled from thousands of smaller photographs.

As with any large artwork, their scale carries a vital part of their substance which is lost in these little web images. Hopefully the JPEGs displayed here might be enough to arouse your curiosity to attend an exhibition, or to arrange one if you are in a position to do so.

The series is a work in progress, and new images will be posted as they are completed, so please stay tuned."






Building Blocks, 2007
16 feet tall x 32 feet wide in eighteen square panels, each sized 62x62".

Depicts nine million wooden ABC blocks, equal to the number of American children with no health insurance coverage in 2007.

chris jordan, Seattle



See all Topics

Saturday, September 06, 2014

Runtime and PDF

Add-in's complete


Great news, you can now redistribute and use the PDF and XPS add-in with your Runtime solution.
The Runtime's code has not been changed. Your existing runtime solutions can now officially be distributed with the PDF and XPS add-in by chaining the .msi for PDF and XPS into your install process for your app (after the Runtime).

You may copy and distribute the object code form of the add-in listed below together and for use only with the Microsoft Office Access Runtime software, subject to the license terms accompanying the Microsoft Office Access 2007 Runtime software download:
2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (located at PDF add-in download)

Runtime for Access



See all Topics

Thursday, September 04, 2014

Task Panes

VBA at your own risk



From the MVPS.org site:

Word's Task Panes VBA Reference
The Mother of All Task Pane articles
By Steve Hudson

"Task Panes display within a Work Pane's area. A Work Pane is created by the combination of two objects. These objects are shrouded in misery and thwart most attempts to play with them. The whole area is hidden away from the Kill Cursor invoked with CTRL+ALT+-, which changes to a hand when waved over a Work Pane.
Functions are hidden away from the macro recorder. To make it easier, if it is not in this reference, it is hidden. It is like when a spy is caught and the government disavows all knowledge of their actions.
The Task Panes are spies from Microsoft that are known to only a few objects, in these versions of Office anyway.

Warning
The author gleefully notes at this point that the human race has enough intelligence to get itself into cauldrons of boiling water that it cannot climb out of and that means you and me both!
If you like to be ultra-safe, stay away from this reference and wait for MS to hand over full functionality. You will end up crashing Word many times and you can really damage your user interface."

(Ctrl+Alt+-, can be used to remove an item from a menu. Type the shortcut and then click on a menu item)



See all Topics

W3C Validation

Standards



Web pages are written in a language called Hyper Text Markup Language; HTML
The latest version of HTML is 5.

There is a move to upgrade the code to Extensible Hyper Text Markup Language.

XHTML is compatible with XML (EXtensible Markup Language) allowing applications to more easily exchange data.

In preparation for making the change, edit your web pages so that element and attribute names are in lower case. XHTML is case-sensitive.

Use <p> rather than <P>.

Also end tags are required. Make sure that <p> is followed by </p>.

<br> should be written <br /> and <hr> as <hr />.

For more information see:

The W3C validation site



See all Topics

Wednesday, September 03, 2014

Annoying Hypertext Warnings

How to disable hyperlink warning messages in 2007+ Office programs


When you include links in PowerPoint, or other '07 applications, you may get this admonition:

Opening "path/filename".
Hyperlinks can be harmful to your computer and data. To protect your computer, click only those hyperlinks from trusted sources.
Do you want to continue?


To disable the hyperlink warnings in 2007+ Office programs when an http:// address or an ftp:// address is used, you must create a new registry subkey.

To do this, follow these steps:

  1. Click Start, and then click Run.

  2. In the Open dialog box, type regedit, and then click OK.

  3. In Registry Editor, locate one of the following registry subkeys:

    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common 

    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Common

    Note You only have to modify one of these registry subkeys. You do not have to modify both of them.

  4. Click the registry subkey, point to New on the Edit menu, and then click Key.

  5. Type Security, and then press ENTER to name the key.

  6. On the Edit menu, point to New, and then click DWORD Value.

  7. Type DisableHyperlinkWarning, and then press ENTER to name the entry.

  8. In the right pane, right-click DisableHyperlinkWarning, and then click Modify.

  9. In the Edit DWORD Value dialog box, click Decimal, and then type 1 under Value data.

    Note A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message.

  10. Click OK.

  11. Exit Registry Editor.
  12. 
    
How to disable hyperlink warning messages

Security warning message  



See all Topics

Tuesday, September 02, 2014

Scrub DVD Scratches

Methods tested


Which is better toothpaste or Brasso when it comes to cleaning that DVD?

Or



Paul Michael has done the testing for you and provides videos of the results.


Removing scratches



See all Topics

Monday, September 01, 2014

Some Issues in Word

A collection of hows


Here are a few:





See all Topics