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


  Monday, February 28, 2011 – Permalink –

Horrific Stories

What did your Grandparents do?


"Unsuspecting visitors in crime-infested Port Townsend, victims of shanghaiing, are sold to the highest bidder

Bunco Kelly, Spider Johnson and fourteen dead men on the deck of the Flying Price

Urban East Hicks surrounded by Indians in 1886

Earthquakes, riots, robberies, murders and a host of other terrifying events which created panic in the streets of communities throughout the Pacific Northwest.

Selected from the Clippings File of the Tacoma Public Library's Northwest Room /Special Collections, these true-life tales chillingly capture the dark side of our state's history."


Unsettling Events!





See all Topics

Labels:


<Doug Klippert@ 3:50 AM

Comments: Post a Comment

  Sunday, February 27, 2011 – Permalink –

IE Spells

Missing feature found



For years, I've filled out forms on the net and then had to copy and paste into Word to check doubtful spelling.

Now there is a tool that should have been included in the first place.


"ieSpell is a free Internet Explorer browser extension that spell checks text input boxes on a webpage. It should come in particularly handy for users who do a lot of web-based text entry (e.g. web mails, forums, blogs, diaries).

Even if your web application already includes spell checking functionality, you might still want to install this utility because it is definitely much faster than a server-side solution. Plus you get to store and use your personal word list across all your applications, instead of maintaining separate ones on each application."


ieSpell



See all Topics

Labels:


<Doug Klippert@ 3:47 AM

Comments: Post a Comment

  Saturday, February 26, 2011 – Permalink –

Access Tutorials

Learning Sites



Microsoft has created a web site for Office. Part of the site is devoted to tutorials touching on:

Word, Access, Publisher , Outlook, PowerPoint, InfoPath , Excel, Visio, OneNote, Expression, and Project.

The Access lessons are located here:

2010 Access Tutorials

2003 Access Tutorials
2007 Access Tutorials

Here are some other sites:

FunctionX Access tutorials

TutorialUSA.com

Access Tutorials, Basic

Bay City Public Schools




See all Topics

Labels:


<Doug Klippert@ 3:54 AM

Comments: Post a Comment

  Friday, February 25, 2011 – Permalink –

Put IE Back on the Desktop

Regedit ahead


  1. Click Start, Run.

  2. Type "regedit.exe" (Without quotes).

  3. Navigate to the following registry key
    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel

  4. In the right hand pane, double-click {871C5380-42A0-1069-A2EA-08002B30309D} key.
  5. Enter dword value as 0 to enable the Internet Explorer icon on the Desktop.


Internet Explorer Desktop icon missing See all Topics

Labels:


<Doug Klippert@ 3:31 AM

Comments: Post a Comment

  Thursday, February 24, 2011 – Permalink –

Wrist Time

Ding dong bling


Face it, you're never going to wear these watches. Some of them are just concepts, others are just too.

They are fun to look at.


Wrist Fashion is a Weblog that publishes the latest news, trends and products from the Wristwatch Industry in bite size morsels.


Brand: Venexx
Movement: Swiss Ronda Calibre 1063.1.90 quartz movement
Perfume: Approximately 60 sprays
Water Resistant: 30 metres


Perfume Watch

WristFashion.com





See all Topics

Labels:


<Doug Klippert@ 3:41 AM

Comments: Post a Comment

  Wednesday, February 23, 2011 – Permalink –

Flag Access Controls

Tag Property


The TAG property allows you to associate up to 2,084 characters of text with any form, report, section, or control. This is especially helpful when you want to single out a specific subset of controls.

For instance, say that you want to hide certain controls on a form when a user clicks a button.
You can flag which controls will be hidden by entering the word "Hide" (or any other consistent word) in each control's Tag property. Then, attach the following code to the command button's Click event procedure:
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "Hide" Then
ctl.Visible = False
End If
Next







See all Topics

Labels:


<Doug Klippert@ 3:56 AM

Comments: Post a Comment

  Tuesday, February 22, 2011 – Permalink –

Why PP 2007-10

There must be reasons


Here are a few:


  • Create powerful, dynamic SmartArt diagrams.

  • Easily reuse content with Office PowerPoint 2007 Slide Libraries.

  • Dramatically modify shapes, text, and graphics with new SmartArt graphics tools and effects.

  • Add more security to your PowerPoint presentations.

  • Reduce your document sizes and improve file recovery at the same time.
Microsoft Office PowerPoint 2007 top 10 benefits

Also Office 2010

See all Topics

Labels:


<Doug Klippert@ 3:22 AM

Comments: Post a Comment

  Monday, February 21, 2011 – Permalink –

More Icons Deal

Forgotten tricks


Here's a simple way to display different icons on your desktop.
Right-click on a desktop folder and choose Properties.
Click the change Icon button. You'll see a few icons. For more icons look at:
C:\WINNT\system32\moricons.dll


PC magazine has this article:
Assign Custom Icons to Windows Explorer Folders.


PC World:
Change Icon v1.2.1


Creating Icons

Also see:
The Iconolog, the art of virtual (desktop) litter.




See all Topics

Labels:


<Doug Klippert@ 3:47 AM

Comments: Post a Comment

  Sunday, February 20, 2011 – Permalink –

Convert Anything

Four pecks to a bushel



Convert
"Convert is an easy to use unit conversion program that will convert the most popular units of distance, temperature, volume, time, speed, mass, power, density, pressure, energy and many others, including the ability to create custom conversions!"


Convert


OnlineConversion.com does more conversions online.
(A Hogshead is 63 Gallons)


Export911 has conversions and calculators.


Also:
Convert between bits/bytes/kilobits/kilobytes/megabits/megabytes/gigabits/gigabytes





See all Topics

Labels:


<Doug Klippert@ 3:34 AM

Comments: Post a Comment

  Saturday, February 19, 2011 – Permalink –

Vidler Video Streamer

Player and free video storage





"You can upload many videos at once, and in various formats, too.(mov .avi .wmv .mpeg).

You also won't have to worry about file size - just keep any video you upload under 500 Mb.

Timed Tags
Moments on the timeline of your video are taggable, so you can classify and share instances in time. Timed tags are searchable, too - a great way to explore the content on viddler.com

Timed Comments
Your position in the timeline of a video determines where your comment will be posted to, which brings the discussion to a whole new level!

Use Your Webcam
Got a web camera? You can use Viddler to record footage directly from the camera to the website. There's no third-party software


"Viddler is very different from other video-delivery based websites, because we stream our videos instead of having the user download it.

That means you get to watch videos without having to wait for the entire video to load.

This is especially useful when you want to view the last few minutes of a very long video.

It's a secure system and prevents other people from watching the video (in ways they're not supposed to) or ripping the video off the site.

Video that you host with Viddler cannot be stolen, or used in any fashion, unless you set your sharing options to allow it."


Vidler.com





See all Topics

Labels:


<Doug Klippert@ 3:39 AM

Comments: Post a Comment

  Friday, February 18, 2011 – Permalink –

Great Collection

Examples and ideas


The experts show you how they have developed some pretty spectacular animations and designs using PowerPoint out of the box.


"PowerPoint Heaven is a website providing PowerPoint showcase, artworks, PowerPoint games, animation templates, PowerPoint animations and tutorials on animating Microsoft PowerPoint."


PPTHeaven.mvps.org





See all Topics

Labels:


<Doug Klippert@ 3:15 AM

Comments: Post a Comment

  Thursday, February 17, 2011 – Permalink –

Google Search Tips

Drill down to the answer


Jay White of DumbLittleMan.com has a nice site. One of the features is a list of 20 search tips to be used with Google.

Here are a few:

  • Either/or. Google normally searches for pages that contain all the words you type in the search box, but if you want pages that have one term or another (or both), use the OR operator -- or use the "" symbol (pipe symbol) to save you a keystroke.


  • Quotes. If you want to search for an exact phrase, use quotes.


  • Not. If you don't want a term or phrase, use the "-" symbol.


  • Similar terms. Use the "~" symbol to return similar terms.
  • Definitions. Use the "define:" operator to get a quick definition.
  • Vertical search. Instead of searching for a term across all pages on the web, search within a specialized field. Google has a number of specific searches, allowing you to search within blogs, news, books, and much more
20 Google Tips
 


See all Topics

Labels:


<Doug Klippert@ 3:14 AM

Comments: Post a Comment

  Wednesday, February 16, 2011 – Permalink –

Auto Number

Don't be smart



There should not be any "intelligence" in an AutoNumber field. It is meant as an index field and not anything else.

If the need should arise to reset the field, if your table does NOT contain any records, simply compacting the database again will set the Autonumber field back to 1.

Another way would be to delete the AutoNumber field and re-insert it in the table.

Here's a long way to start at a specific number.
  1. Create your table with an AutoNumber type field, but don't enter any records.
  2. Create another table with only a single Long Integer Number type field.
  3. This field must have same name as the AutoNumber field in the first table.
  4. Enter one record in the second table that is a number one less than the required start of the AutoNumber for the first table.
  5. Now create an append query to append the record in the second table to the first table and run the query.
You can now delete the second table and begin entering your data into the first table.
Also: Access AutoNumber Reset
"This is some sample code that shows how to programmatically reset all AutoNumber fields in an Access Database to a correct value (whether it be 0 or the max value + 1). In addition, it contains code for Compacting and Repairing an MS Access Database. This is perfect for people who are working with a complicated Access Database and have experienced AutoNumber bugs!
And: Creating an AutoNumber field from code  



See all Topics

Labels:


<Doug Klippert@ 3:03 AM

Comments: Post a Comment

  Tuesday, February 15, 2011 – Permalink –

Countdown Slide

3-2-1




It can be useful to let your audience know when the show is going to begin. Here's a description about how to do it:

Create Countdown Slide Without VBA
(There is also a sample PowerPoint file with all the hard work done for you!)


The MVPS.org site also has a way to do it with VBA:
Simulate a countdown timer using Sleep API

Indezine.com has a tutorial:
Countdown Timer

Tushar-Mehta.com offers a free download:
PowerPoint Timer add-in
The add-in provides a variety of capabilities missing from PowerPoint itself. During a slideshow, it can:

  • Show the current time
  • Show the elapsed time of the presentation
  • Count down the time remaining for the presentation.
  • Optionally, it includes the ability to terminate the presentation at the end of a separately configurable grace period!
Also a tutorial on auto scheduling a PowerPoint show

Countdown with sound  




See all Topics

Labels:


<Doug Klippert@ 3:32 AM

Comments: Post a Comment

  Monday, February 14, 2011 – Permalink –

Creating Hyperlinks in Access Tables

Simply


When you populate a hyperlink field in a table, you probably cut and paste the URL from your browser into the Insert Hyperlink dialog box.
There's an even easier way to do this using Internet Explorer.

  1. First, open the Access table you're updating and Internet Explorer.

  2. Select the hyperlink field you want to create the link in and choose Insert >Hyperlink from the menu bar.

  3. Press Alt+Tab or use your mouse to select the browser window.

  4. Browse to the page you want to link to and then switch back to Access.
You'll find that the URL is automatically inserted in the dialog box.  



See all Topics

Labels:


<Doug Klippert@ 3:02 AM

Comments: Post a Comment

  Saturday, February 12, 2011 – Permalink –

Where'da Go?

Sent mail vanishes


Trying to find out why an email message does not arrive at its intended location can be difficult.

This tip is from Office-Watch.com. Look into their weekly newsletter.

Here are some suggestions:

Where could that message be?





See all Topics

Labels:


<Doug Klippert@ 6:54 AM

Comments: Post a Comment

Five Tips

A few useful ideas


"If you use Word in your daily work, a few simple tips will help you save an hour of your time per week, maybe more. Best of all, these tips are so easy to use that you can put them to work immediately upon finishing this article. Yes, they are that easy to use!"

  • Let Word type names and other words and phrases for you

  • Let Word insert your favorite text or graphics

  • Let Word type information about your documents

  • Let Word alphabetize lists for you

  • Change the way Word works
5 time-saving tips



See all Topics

Labels:


<Doug Klippert@ 3:21 AM

Comments: Post a Comment

  Friday, February 11, 2011 – Permalink –

Data Validation

Control input



Mark Rowlinson provides a discussion by Kid Van Ouytsel that does an excellent job explaining data validation. He has also constructs a sample workbook that you can download and play with.

Data Validation
"Data validation is a tool that can help you control the input/changes someone can make in a spreadsheet. It can help you or your users to make choices, guide them to make relevant input/changes, or restrict input to a specific type of data or structure. It can help you or your users to save time and to keep formulae working properly."

Also:

Contextures:
Excel -- Data Validation

Ozgrid:
Data Validation and Conditional Formatting

MrExcel:
Data Validation

Microsoft Office Online:
Overview and samples of data validation

Microsoft Downloads:
Sample: Data Validation



See all Topics

Labels:


<Doug Klippert@ 3:10 AM

Comments: Post a Comment

  Thursday, February 10, 2011 – Permalink –

Keyboard Shortcuts

Extra pilcrows?



Here is a list of keyboard shortcuts I once or never knew.

The one that struck me was:

Ctrl Alt K — Remove extraneous paragraph marks.

This removes doubled pilcrows (¶¶).

Word-Tips


  • Alt F6 — Swap open documents
  • Alt Shift D — Insert date
  • Alt Shift Up/Down — Move table rows or paragraphs up or down
  • Shift F5 — Go back to last position
  • Shift F3 — Change case
  • Ctrl Space — Remove direct formatting
  • Ctrl Q — Remove paragraph formatting
  • Ctrl Shift N — Apply Normal style
  • Ctrl Y — Repeat action
  • Ctrl ] — increase font size by 1pt
  • Ctrl [ — decrease font size by 1pt
  • Ctrl Shift > — Increase font to next size up
  • Ctrl Shift < — Decrease font to next size down
CDEV Computing is managed by Chris Devrell located in Southampton UK.  



See all Topics

Labels:


<Doug Klippert@ 3:08 AM

Comments: Post a Comment

  Wednesday, February 09, 2011 – Permalink –

Split Access Database

Separate tables



You don't need to keep all of your data in one file. You can split your MDB file into data and application files.

"Even if all your data is in Access itself, consider using linked tables. Store all the data tables in one MDB file - the data file - and the remaining objects (queries, forms, reports, macros, and modules) in a second MDB - the application file.
In multi-user situations, each user receives a local copy of the application file, linked to the tables in the single remote data file."

  • Maintenance: To update the program, just replace the application file.
    Since the data is in a separate file, no data is overwritten.

  • Network Traffic: Loading the entire application (forms, controls, code, etc)across the network increases traffic making your interface slower.
In some cases you will link additional files:
  • Static look-up data such as postal codes might be kept in its own file.
  • Linked temporary tables might avoid the need to compact the application file.
From Allen Brown's tips for Access users
Access has a tool to do the splitting for you, go to: Tools>Database Utilities Database Splitter
In Access 2007:
  1. On the Database Tools tab, in the Move Data group, click Access Database.
  2. In the Database Splitter dialog box, click Split Database.
  3. Type a name for the back-end database, and then click Split.
Also:
Knowledgebase: How to manually split a Microsoft Access database
MSDN: About sharing an Access database on a network  



See all Topics

Labels:


<Doug Klippert@ 3:16 AM

Comments: Post a Comment

  Tuesday, February 08, 2011 – Permalink –

Backgrounds for You

A large number of designer slides


PP'ers are always on the lookout for colorful, useful backgrounds.

Camtasia Studio, a maker of video capture software has a lot of PowerPoint backgrounds that are yours for the downloading.


"Based on the popularity of our MenuMaker background templates, we've created background templates for use with Microsoft PowerPoint. These free templates are designed for use with PowerPoint presentations recorded with TechSmith's Camtasia Studio. However, they are standard templates and can be used for any PowerPoint presentation."

Camtasia Backqrounds





See all Topics

Labels:


<Doug Klippert@ 3:56 AM

Comments: Post a Comment

  Monday, February 07, 2011 – Permalink –

Open to Contacts

Your choice


To create a shortcut for your Outlook Contacts folder on the desktop


  1. Right click on an open area of the desktop

  2. Select New / Shortcut

  3. Enter in the path to your outlook program followed by outlook:contacts. Note the quotes are necessary:
C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE outlook:contacts




See all Topics

Labels:


<Doug Klippert@ 3:40 AM

Comments: Post a Comment

  Sunday, February 06, 2011 – Permalink –

Runtime for Access

Free Download !


Access is not included in the basic Office 2007+ suites. If you want to distribute your database projects to others in the office, you'll need this download.

The Access 2003 Developer Extensions cost about $500. The 2007-10 downloads are free!


"Microsoft Office Access 2007 provides a rich platform for developing database management solutions with easy-to-use customization tools.

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

To do so, you must package and distribute your application with the Access Runtime.

The Access Runtime is similar to previous runtimes in that all design-related UI is either removed or disabled.

You do not need to buy any special SKU in order to redistribute the Access Runtime. You can freely redistribute it or point users to this download."


Access 2007 Runtime

Access 2010 Runtime





See all Topics

Labels:


<Doug Klippert@ 3:15 AM

Comments: Post a Comment

  Saturday, February 05, 2011 – Permalink –

Move a Column

No cut, No Paste


With a little practice you can quickly move columns or rows.

  1. Select the entire column or row you want to move
    The move will effect whatever is selected; cells, or columns, or rows

  2. Move your mouse pointer to the edge of the selection until it changes from a normal pointer cross to an arrow (four headed arrow in 2007+).
    (Put the pointer on the selected cells, not the Row or Column indicators.)

  3. Hold down the shift key and click the left mouse button and drag the column/row to the new position.

  4. Release the mouse button before releasing the shift key

See all Topics

Labels:


<Doug Klippert@ 3:49 AM

Comments: Post a Comment

  Friday, February 04, 2011 – Permalink –

DOCTYPE

Customize



At the top of an HTML file source, you may see some code that indicates the version of HTML that is going to be used.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">

The O'Reilly Net.com has a discussion:
DOCTYPE Explained.

"There are three variants on HTML 4.01, for example:
  • HTML 4.01 Strict, which describes the structural portions of HTML 4.01 and does not provide any frame-related markup.
  • HTML 4.01 Transitional, which includes the presentational markup such as >B< and >FONT<, but does not include frame-related markup.
  • HTML 4.01 Frameset, which is the same as HTML 4.01 Transitional except that it adds a description of frame-related markup."
From Thomas Brunt's Outfront.net Editing the FP 2003 Default Template
"I've heard some folks complaining that FrontPage doesn't include a doctype declaration when you create a new page. If that's a problem for you then why not just edit the default template? That's the file that FP copies every time you create a new blank page. Here's the location of the file. Change it you like. C:\Program Files\Microsoft Office\Templates\1033\Pages11\normal.tem\normal.htm FP 2003 gives you a choice of doctypes to enter somewhat automatically, however. You can edit what's available and add your own stuff too."
Also:
Fix Your Site With the Right DOCTYPE!
Choosing a DOCTYPE  
The global structure of an HTML document  


See all Topics

<Doug Klippert@ 3:45 AM

Comments: Post a Comment

  Thursday, February 03, 2011 – Permalink –

Fuzzy Preview

Fix the resolution


If the preview image is not clear, this Knowledgebase article may help:

Because of changes in how the preview image is saved in Microsoft Office PowerPoint 2007, in Microsoft Office PowerPoint 2003, and in Microsoft PowerPoint 2002, the preview image File Open dialog box is more difficult to read than in PowerPoint 2000 and earlier versions.


In PowerPoint 2007
  1. Click Start, click Run, type regedit, and then click OK.

  2. Locate and then click the following key in the registry:

    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\PowerPoint\Options

  3. On the Edit menu, point to New, and then click DWORD value.

  4. Type Preview Picture Precision, and then press ENTER.

  5. On the Edit menu, click Modify.

  6. Click Decimal in the Base area.

  7. Type 320, and then click OK.

  8. Exit Registry Editor.
Support.Microsoft.com:
Preview image is fuzzy


See all Topics

Labels:


<Doug Klippert@ 3:30 AM

Comments: Post a Comment

  Wednesday, February 02, 2011 – Permalink –

Attention Grabber

For Print Screen or lost spectacles


Those Apple type people have a gadget called "Mouseposé". You might have seen it in videos demonstrating applications. It darkens the screen and puts a spotlight on the point of interest.

Those of us who use real machines have a similar add-in.


It's not from Boinx, It's the magnifier or "Dragnifier" from Ed Halley.





See all Topics

Labels:


<Doug Klippert@ 3:08 AM

Comments: Post a Comment

  Tuesday, February 01, 2011 – Permalink –

Indent Code

Realign a bunch


Indenting blocks of VBA code, such as statements within loops or If...Then statements, makes reading a procedure much easier.

You probably indent a code statement using the [Tab] key, and outdent by using [Shift][Tab].

However, you may not be aware that the [Tab] and [Shift][Tab] techniques also work when multiple code lines are selected.

The Visual Basic Editor also provides Indent and Outdent buttons on the Edit toolbar that allow you to easily reposition blocks of code.





See all Topics

Labels: , , ,


<Doug Klippert@ 3:18 AM

Comments: Post a Comment

eXTReMe Tracker