Light and Power

Bookmark and Share

Enter your email address:

Delivered by FeedBurner



Home Page













Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Tuesday, May 31, 2011 – Permalink –

Save the Warning

Easy record


It happens. Your machine balks and spits out an obscure warning message.

You grab a pen and scribble out the error code, which typically is 90 characters long.

Too much hassle!

When the warning box appears, just hit Ctrl+C. The contents of the box are now on the Clipboard and can be pasted into Notepad.








See all Topics

Labels:


<Doug Klippert@ 3:10 AM

Comments: Post a Comment


  Monday, May 30, 2011 – Permalink –

Handy Master View

It's mouse and keyboard quick!


With PowerPoint 2007-10, View>Presentation Views>Slide Master will take you to the Slide Master View. The same location shows Handout and Notes Masters.

A shortcut involves using the Shift key.


"At the bottom left hand corner of PowerPoint (bottom right for PowerPoint 2007), you will see 3 mini buttons. They are: Normal View, Slide Sorter View, and Slide Show. Now here's a quick trick:

When you hover over these 3 mini buttons, hold down the Shift key. The mini buttons will now become Slide Master view, Handout Master view, and Set Up Show respectively."


The Setup Show is on the Slide Show tab in the Setup group. The Shift key is a cooler way to bring it up quickly.



The Art of PowerPoint-ing


Thanks to Lucy, an MOS Master Instructor from Australia; aneasiertomorrow.com.au.




See all Topics

Labels:


<Doug Klippert@ 3:55 AM

Comments: Post a Comment


  Sunday, May 29, 2011 – Permalink –

Edit Subject Line

Organization trick



By editing the subject lines of messages you receive, you can organize your mail. If you get faxes or voicemail sent to you automatically via email, you can change the subject to something that makes sense to you.

Open the message, edit the subject line, close the message and, when prompted, save the changes. The trick with this is the subject line does not look editable because it is on a grey background, but it works nevertheless.

Turn on in-cell editing and you can change the subject line without having to open the email and re-save it at all. This works best if you have the Preview Pane turned on:

Outlook 2000/2002:

From the View Menu select
Current View > Customize Current View
View Summary > Other Settings
Rows, enable the Allow In-cell Editing option.

Outlook 2003-10:

From the View Menu select
Current View
Customize Current View > Other Settings
and enable Allow In-cell Editing.




Slipstick.com:
To change the subject of an incoming message or fax



See all Topics

Labels:


<Doug Klippert@ 3:47 AM

Comments: Post a Comment


  Saturday, May 28, 2011 – Permalink –

Learn HTML

HEADING


More tutorials



I like to read more than one author on a subject. It helps to clarify the sticky parts and each writer has a little bit different perspective on the subject.

WebReference.com has a good collection of material related to the Web and the Internet in general.


Stephanos Piperoglou has written a number of tutorials on Web design and construction.
From HTML 101 to I Shot the Serif and The Seven Habits of Effective Web Sites .


About HTML with Style



W3 Schools


Also:
HTML Tutorials





See all Topics

Labels: , ,


<Doug Klippert@ 3:45 AM

Comments: Post a Comment


  Friday, May 27, 2011 – Permalink –

2003-2007-10 Compatibility

Exchange the future and the past


"Microsoft has added new file formats to Microsoft Office Word, Excel, and PowerPoint 2007. To help ensure that you can exchange documents between Microsoft Office releases, Microsoft has developed a Compatibility Pack for the Office Word, Office Excel, and Office PowerPoint 2007 File Formats"


Use earlier versions of Excel, PowerPoint, and Word to open and save files from 2007-10 Office programs


Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007




See all Topics

Labels: , ,


<Doug Klippert@ 3:38 AM

Comments: Post a Comment


  Thursday, May 26, 2011 – Permalink –

Tab Leaders

You can lead a tab to ...........


Setting Tab Leaders in Word

Fred Smith.........................$44.59

This makes your list easier to read

  1. Select the line on which you want to create a tab

  2. Click on the Format menu and click on the Tabs menu item
    (you will see the Tabs dialog box)

  3. In the Tab Stop Position field enter the distance to the last column: 5", 6" or what ever is appropriate

  4. Then select the tab alignment; Decimal, Right, Center or Left

  5. Select the type of leader to use

  6. Click Set and then OK
Enter the name, or first entry, and then touch the Tab key. Word will automatically enter as many leading characters as required. When you can type the amount, it will be aligned on the decimal or any other alignment you might have chosen.
Here's what it looks like in Word 2007


Also: University of Florida handout: Word Tabs Doc
OfficeLetter.com: Favorite Word tips #2
 About.com: Creating Tab Leader Lines


See all Topics

Labels:


<Doug Klippert@ 3:04 AM

Comments: Post a Comment


  Wednesday, May 25, 2011 – Permalink –

Change Access Ribbon

Oh, Fooey (F U I)


"One of the most exciting new developer features that Microsoft Office Access 2007 provides is the ability to customize the Office Fluent User Interface (UI) in your application.

The Office Fluent UI provides a new user model for exposing commands, and application navigation that is more discoverable and easier for users of the application.


You create XML to change the Ribbon, a component of the new Microsoft Office Fluent user interface (UI). You can create customization files in any text editor.

All applications that include the Office Fluent Ribbon use the same extensibility model, so you can reuse the same Office Fluent UI extensibility XML with a minimum of adjustments.

For example, you can reuse the custom XML you create for Access 2007 in Microsoft Office Excel 2007, Microsoft Office Word 2007, Microsoft Office PowerPoint 2007, or Microsoft Office Outlook 2007."




Customizing Ribbon in Access 2007




See all Topics

Labels:


<Doug Klippert@ 3:24 AM

Comments: Post a Comment


  Tuesday, May 24, 2011 – Permalink –

Custom System Display

Painless branding



"When you open the System applet (in the Control Panel), you will see some specific information listed on the General tab such as who the type of computer and the registered owner. However, you can edit the information to also have your specific information displayed. For example, if you sell computers, you can have your company information displayed to remind your customers how to access your support information.

Once you perform the steps outlined below, not only will you have your own company information listed but a support information button will also be available from the System Properties window. Users can click the button to get specific support information about your company, such as the URL they should visit to find support. So here is what you have to do:

Open Notepad and create a text file called oeminfo.ini. If you are running Windows NT/2000, save the file in the c:\WINNT\System32 directory. If you are running Windows XP, save the file in the c:\Windows\System32 directory. Add the following information to the text file you just create:


[General]
Manufacturer=Your Company Name
Model=Model of Computer
SupportURL=http://supportWeb site
LocalFile=c:\localhelpfile\file.htm

[Support Information]
Line1=support information users should know
Line2=who users should contact for support
Line3=Phone number users should call
Line4=fourth line

You can create as many lines as you need by incrementing the number for each new line required.

To take this one step further, you can even have your company logo displayed by creating a 172x172 pixel bitmap image. Name the image oemlogo.bmp and save it in your system directory. Now when you open the System properties applet, your company information should appear."

Microsoft KB:
How to Alter Logo Information on the System Tool's General Tab

Amset IT Solutions Ltd.:
Branding Your Machines

BeemerWorld.com:
Branding System Properties Panel

OEM in Vista



See all Topics

Labels: ,


<Doug Klippert@ 3:45 AM

Comments: Post a Comment


  Monday, May 23, 2011 – Permalink –

Type, what it looks like

Screen fonts preview


This is a tool that lets you see how different typefaces will look on the screen. It also allows you to compare three fonts at once.


"The Typetester is an online application for comparison of the fonts for the screen. Its' primary role is to make web designer's life easier. As the new fonts are bundled into operating systems, the list of the common fonts will be updated."


TypeTester





See all Topics

Labels: , , ,


<Doug Klippert@ 3:55 AM

Comments: Post a Comment


  Sunday, May 22, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:18 AM

Comments: Post a Comment


  Saturday, May 21, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:38 AM

Comments: Post a Comment


  Friday, May 20, 2011 – Permalink –

Access 2007 Developers Extensions

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."
Access Templates Developers Extensions  


See all Topics

Labels:


<Doug Klippert@ 3:16 AM

Comments: Post a Comment


  Thursday, May 19, 2011 – Permalink –

Work with Office

It can make life easier


Here's a collection of tips and tutorials from Microsoft about how to use MSOffice at work.
If no one's looking, you could use these hints at home too.

Ways to work smarter




See all Topics

Labels: , , ,


<Doug Klippert@ 3:10 AM

Comments: Post a Comment


  Wednesday, May 18, 2011 – Permalink –

First Look at Word 2007-10

We all have to start somewhere



Here is a 30 minute course:



After completing this course you will be able to:


javascript:void(0)
  • 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



More 2010 articles

 

See all Topics

Labels:


<Doug Klippert@ 6:09 AM

Comments: Post a Comment


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

Labels:


<Doug Klippert@ 3:13 AM

Comments: Post a Comment


  Tuesday, May 17, 2011 – Permalink –

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 2000 with automation

Teachers on the web: Aussie SchoolHouse:
Merging Access Data with Word Documents

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



See all Topics

Labels:


<Doug Klippert@ 3:08 AM

Comments: Post a Comment


  Monday, May 16, 2011 – Permalink –

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'o7-10 calendar




See all Topics

Labels:


<Doug Klippert@ 3:34 AM

Comments: Post a Comment


  Sunday, May 15, 2011 – Permalink –

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

Labels: , ,


<Doug Klippert@ 3:48 AM

Comments: Post a Comment


  Saturday, May 14, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 6:42 AM

Comments: Post a Comment


First Look at Word 2007-10

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

More 2010 articles
 
See all Topics

Labels:


<Doug Klippert@ 6:40 AM

Comments: Post a Comment


  Thursday, May 12, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:43 AM

Comments: Post a Comment


  Wednesday, May 11, 2011 – Permalink –

Two Monitors

Notes and Slides


"Now, what I am going to show is how to have two different desktop screens in this configuration. Yes, you heard me right. The base display (say, laptop screen) shows different applications and the secondary display (say, projector) displays a separate desktop."

Tips and tricks: Double Monitor Display
Dr Nitin Paranjape

  1. You are in a sales presentation. During the presentation, customer is negotiating the price. You want to refer to your price list, use Excel and calculate some discounts and so on.

  2. You are in a technical presentation. Someone asks a question about a topic you are not fully clear about. You can now refer to the technical help / documentation or website, without disturbing the base presentation.

  3. Assuming you have an Internet connection, you can even chat with colleagues, take approval from your boss, download additional deliverables and clinch a deal without leaving the presentation.
Vista and MultiMonitor Support
Four Monitors and Vista
G4TechTV: Dual Monitors written by Roger Chang and Greg Melton This site has a video describing the process.
FreePCTech.com: Guide to Dual Monitors in Windows by Drew Dunn
 
See all Topics

Labels:


<Doug Klippert@ 3:14 AM

Comments: Post a Comment


  Tuesday, May 10, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:45 AM

Comments: Post a Comment


  Monday, May 09, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:04 AM

Comments: Post a Comment


  Sunday, May 08, 2011 – Permalink –

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

Ian McKenzie mentioned this buried feature in his well named blog Ian's Messy Desk.
He does, however, have neat header graphic.  




See all Topics

Labels: ,


<Doug Klippert@ 3:26 AM

Comments: Post a Comment


  Saturday, May 07, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:39 AM

Comments: Post a Comment


  Friday, May 06, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:28 AM

Comments: Post a Comment


  Thursday, May 05, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:39 AM

Comments: Post a Comment


  Wednesday, May 04, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:47 AM

Comments: Post a Comment


  Tuesday, May 03, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:52 AM

Comments: Post a Comment


  Monday, May 02, 2011 – Permalink –

Send Your Template to MS

Geek fame


According to the Inside Office Blog, over 1 million people have downloaded free templates from Microsoft.


"You probably have a document you use over and over again, something you created to solve a particular problem. You may even find yourself occasionally sending the document to others in e-mail because it's so useful. Now you can share your clever solution with everyone who uses the 2007 Microsoft Office system!

People like you all over the world are allowing others to download and use their document templates on Office Online. Some of these templates have tens of thousands of downloads. They were submitted by people who either wanted to help others or show their great solutions. You can, too.



Upload your template




See all Topics

Labels: , , , ,


<Doug Klippert@ 3:41 AM

Comments: Post a Comment


  Sunday, May 01, 2011 – Permalink –

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

Labels:


<Doug Klippert@ 3:24 AM

Comments: Post a Comment

eXTReMe Tracker