|
Host your Web site with PureHost! |
 Tuesday, March 31, 2009 – Permalink – Add Captions ProgramaticallyWhen the project seems overwhelmingFaced with a repetitive task, I often have to make the decision, do I do it by hand again and again? Or do I write or find a macro to do the heavy lifting? "Have you ever had a document with ten, twenty, or even 100 images, and then as an afterthought decided you wanted to add a caption to each of those images? This is an easy task through the user interface (UI). All you have to do is select each image, one at a time, and choose Insert, then Reference, then Caption. Unfortunately doing this through an image-heavy document is a boring chore and takes up a lot of time. Working with Word 2003 Images Programmatically [Edited entry from 2/2/2006] See all Topics Labels: Word <Doug Klippert@ 3:16 AM
Comments:
Post a Comment
Monday, March 30, 2009 – Permalink – Linked Table ProblemsLost functionalityHave you found that you cannot update linked Excel tables in Access 2003? If you have installed Microsoft Office 2003 Service Pack 2 (SP2): MORE INFORMATION Support.Microsft.com: You cannot change data in linked tables that are to an Excel workbook You might try reinstalling and then only installing SP1. Also: VB123.com: Guacamole dipped - Access to Excel linked table gotcha PCWorld.com: Patent ruling costs Microsoft $8.9 million "A jury in U.S. federal court found that Microsoft infringed on a Guatemalan inventor's 1994 patent on technology linking the company's Access and Excel programs, and ordered the world's largest software maker to pay $8.9 million in damages. [Edited entry from 2/1/2006] See all Topics <Doug Klippert@ 3:14 AM
Comments:
Post a Comment
Sunday, March 29, 2009 – Permalink – Web MagazineThe difference between a blog and a magazine is thinHere's on online mag that collects information, direction, and designs for web sites "A List Apart Magazine (ISSN: 1534-0295) explores the design, development, and meaning of web content, with a special focus on techniques and benefits of designing with web standards. A list Apart [Edited entry from 1/31/2006] See all Topics Labels: Expression Web, FrontPage, HTML, Internet <Doug Klippert@ 3:20 AM
Comments:
Post a Comment
Saturday, March 28, 2009 – Permalink – Forgotten PasswordStill sign on, or notForgetting your password can be an annoyance or a catastrophe. Here are ways to get back to work. Note If you have not created a password reset disk, and you have also forgotten the password for all user accounts, you cannot log on to your existing Windows installation for security reasons. This information applies to starting Windows XP typically, to safe mode, and to Recovery Console. In this case, you must perform a "clean" installation of Windows XP, re-create all user accounts, and then reinstall all your programs. Creating a Password Reset Disk in Microsoft Windows Vista How to create and use a password reset disk in Windows Vista Support.Microsoft.com: How to log on to Windows XP if you forget your password or your password expires Petri.co.il: Forgot the administrator's password? TechTrax: I Forgot My Administrator Password! ComputerHope.com: Lost or forgotten Windows NT / 2000 / XP password [Edited entry from 1/30/2006] See all Topics <Doug Klippert@ 3:11 AM
Comments:
Post a Comment
Friday, March 27, 2009 – Permalink – Action When You Want ItMove it!Here is a tutorial about animation. "Need to make content appear, change or disappear out of order? Need to control the order that things appear while in front of your audience? Playing games? You need to play with PowerPoint's Triggers option for custom animations."
"Let's get past the term, first: A trigger is nothing more than an item on your PowerPoint slide-- it could be a picture, a shape, a button, or even a paragraph or text box-- that sets off an action when you click it. The action might be a sound, a movie, or an animation, such as text becoming visible on the slide."
"Indeed, with the addition of motion paths, new trigger effects and the ability to add two animation behaviors to one object, PowerPoint has become capable of creating sophisticated animations that rival complex animation software." [Edited entry from 1/29/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Thursday, March 26, 2009 – Permalink – Just Say No to BeTo be, or no to beE-Prime aims to eliminate all forms of the verb "to be". (Try that with your next report.) "E-Prime comprises standard English with all forms of the verb 'TO BE' deleted; its use prevents forms of the verb 'TO BE' creating erroneous and irrational generalizations in language and thought."
Labels: Addendum <Doug Klippert@ 3:25 AM
Comments:
Post a Comment
Wednesday, March 25, 2009 – Permalink – Toggle Object ViewsUse the keyboardWhen you are putting a database together you often want to switch between views of Access objects to see the changes. For instance, you'll switch the view to examine a Table in Design view and then back to data view. It is can be faster to switch between views using keyboard shortcuts, rather than the View menu. You can cycle through the views of an open object using the Ctrl + . or Ctrl + , shortcut keys. These shortcuts can be used with tables, queries, forms, reports, and data access pages. [Edited entry from 1/27/2006] See all Topics Labels: Access <Doug Klippert@ 3:26 AM
Comments:
Post a Comment
Tuesday, March 24, 2009 – Permalink – BCC, not your old CCAvoid header spaghettiThere are three parts to the Address section of an email message:
About.com: Sending an Email to Multiple Recipients - Cc: and Bcc: Hamra.net: Use BCC field when addressing mass mail Actrix.co.nz: Using the CC and BCC Fields in E-mail While the recipients can't see the Bcc list, you can see the list in messages you SENT: "To see the Bcc addresses for messages that you sent, open the message from the Sent Items folder, then choose Actions>Resend This Message. If you don't see the Bcc box, choose Find>Bcc Field to display it. Another method you can use in the Sent Items folder, is to choose View>Show Fields and add the Bcc field to the current view. You may not be able to see all Bcc recipients that way if the list was a long one.Slipstick.com: To view Bcc addresses for sent messages [Edited entry from 1/26/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:23 AM
Comments:
Post a Comment
Monday, March 23, 2009 – Permalink – More CSSCan't get enoughDemonstrations, Layouts, Menus This site provides a wealth of examples about how to use Cascading Style Sheets. Poke around and then come back when your project calls for something different. "Because my site deals with experimental CSS that is exactly what you get JUST CSS, no javascript or any other programming language has been used in any of the demonstrations." CSS Play by Stu Nicholls [Edited entry from 1/25/2006] See all Topics Labels: Expression Web, FrontPage, HTML <Doug Klippert@ 3:38 AM
Comments:
Post a Comment
Sunday, March 22, 2009 – Permalink – Intro to ExcelEnglish ExcelThe UCL (University College London) site for the High Energy Physics Group of the Department of Physics & Astronomy, has an introduction to Excel e-book on this page. It's the material used in a 10 week course. "This web page contains material for the computing and data analysis elements of the first-year PHYS1B40 Practical Skills course. Here are some links to the topics covered topics: Excel Data Analysis Visual Basic [Edited entry from 1/27/2006] See all Topics Labels: Excel <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
Saturday, March 21, 2009 – Permalink – Readability EvaluationWhat grade are you?Word has a built in tool to determine the level of reading difficulty of a document. To see the statistics:
 Each readability score bases its rating on the average number of syllables per word and words per sentence.Readability Measuring the reading age of books and other reading matter. Everything you ever wanted know about readability tests but were afraid to ask. Wikipedia.com: Flesch-Kincaid Readability Test Support.Microsoft.com: Frequently Asked Questions About Proofing Grammar I am working on a law review article dealing with readability. We have found a problem with Microsoft Word's Flesch-Kincaid formula - it does not appear to be accurate. We took a sample text of slightly over 100 words, and ran the check. We then changed the word "report" to statement" (with everything else unchanged) and Word indicated a higher grade level. However, the grade level should not have been affected, since "report" and "statement" are both two-syllable words. It looks like Word is somehow incorporating number of characters in each word into it's Flesch-Kincaid score, which it should not. Any idea what the problem might be? posted by  You're right, Word handles the formula a little differently. BTW, they say the sample s/b 200+ words for reliability. See these links: University of Memphis and: Wikipedia [Edited entry from 1/23/2006] See all Topics Labels: Word <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Friday, March 20, 2009 – Permalink – It's Your Icon TooBrand your own ExplorerDevelopers may consider it heretical, but the icon that appears in the upper right corner of Internet Explorer and Outlook Express can be changed. You can use your own static logo and/or an animated one. All it takes is MSPaint and Regedit. For directions see: Winguides.com [Edited entry from 1/22/2004] See all Topics Labels: Windows <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Thursday, March 19, 2009 – Permalink – Nite Tide(Uxoricide)Big Sandy and His Fly-Rite Boys ASIN B00004UDE3 Hightone Records August 15, 2000 About the Artist "Hailing from Anaheim, California, Big Sandy (neé Robert Williams) draws from a number of influences--country, western swing, rockabilly, doo wop, R & B, and jump blues. The best Big Sandy songs are the sexy ones about seduction, innocent on the surface and a little dirty underneath. The retro appeal of the band is equivalent to a Model T or Vargas bombshell" Recording Description Groovin', jumpin', hot rods, Rock-a-billy. One of the cuts -- When Sleep Won't Come (Blues for Spade) -- refers to the uxoricidal "Spade" Cooley. Also see: The Old Corral, b-westerns, Inc A Nickel and a Fiddle Contents [Edited entry from 1/20/2006] See all Topics Labels: Music <Doug Klippert@ 3:07 AM
Comments:
Post a Comment
Wednesday, March 18, 2009 – Permalink – Free AssistanceWorth a lot more than you pay for itHere is a site that gives presentation hints. Also, free clip art, free templates, a forum, and quotations. "There are always three speeches, for every one you actually gave. The one you practiced, the one you gave, and the one you wish you gave."  PresentationHelper.co.uk: Presentation Helper [Edited entry from 1/20/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:51 AM
Comments:
Post a Comment
Tuesday, March 17, 2009 – Permalink – Hip ReplacementDo it yourselfWell, not exactly. The Northwest has a great PBS radio station in KUOW. Here is a story about how surgeons work, including a blow by blow description of a hip replacement operation. . . . "this hour: the surgeon's hands. How do surgeons keep their hands healthy? What kind of training do they go through to keep their fingers tactile and sensitive? How important is touch to successful surgery? Are the hands of surgeons gifted? Over the past month, we've been talking with people who use their head and their hands in their work. Our 'How To' series continues today with surgeons. How to Operate (scroll in to about 14 minutes) For more information, here is a link to the University of Washington: What is Hip Replacement? A Review of Total Hip Arthroplasty, Hip Resurfacing, and Minimally-Invasive Hip Surgery.  Also see: The Flying Patient [Edited entry from 1/19/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Monday, March 16, 2009 – Permalink – New Default Access Form TemplateSet new standardsYou can change Access's default form. To set up a custom template,
In Access 2007, click the Office button in the upper left corner and the click Access Options. The design options are located under Object Designers: Forms/Reports. The same thing can be done with Reports.  (The settings are saved in the Access workgroup information file, not in a particular data base) Also: MeadinKent.co.uk: Making a report template Here's a calendar from MeadinKent: Calendar page [Edited entry from 1/19/2006] See all Topics Labels: Access <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Sunday, March 15, 2009 – Permalink – History of the InternetTime passes quicklyYou can defend the Internet beginning in the early or late 60's. This link follows the history back to the invention of the "computer" in the 1700's to today. Netcraft survey reports there are more than 74 million web sites online, while in 1993 only 130 web sites existed online. A Computer History of the Internet Timeline Also: Here's a nice site: The Living Internet The Internet SOCiety: History of the Internet Also: Internet History [Edited entry from 1/17/2006] See all Topics Labels: Internet <Doug Klippert@ 3:32 AM
Comments:
Post a Comment
Saturday, March 14, 2009 – Permalink – Email HeadersHow to read the codeSpam is as ubiquitous in email as it is in an Hawaiian restaurant. These links may help you distinguish pork shoulder from the other stuff. "This document is intended to provide a comprehensive introduction to the behavior of email headers. StopSpam.org: E-mail Headers "The ability to read and decipher email headers is a useful skill to learn for tracing messages to their original source and diagnosing many other problems. Headers may contain a lot of information but the most important information will always be contained in every email header."
Labels: Outlook <Doug Klippert@ 3:51 AM
Comments:
Post a Comment
Friday, March 13, 2009 – Permalink – Web QueriesDo You Question the Web?This feature can make data acquisition a lot easier than Copy-Paste-Reformat-Try again. "Generally, though, people tend to overlook the option of using the Web as a data source for Excel, be that source the Internet, an intranet, an extranet, or a Web Service. But they shouldn't. Web queries are an easy, yet remarkably flexible and predictable way of bringing data into Microsoft Excel from anywhere on the Web. You can point a Web query at any HTML document that resides on any Web server - or even on a file server, for that matter - and pull part or all of the contents back into your spreadsheet...When you start using Excel's Web queries, you will realize they are almost as limitless as the Web is. Well Kept Secret On the menu bar, go to Data>Import External Data. (In 2007, Data>Get Extrnal Data>From Web). Then, select Import Data to use an existing Web query or select New Web Query to build a new one.  Also see: Vertex42.com: Excel Web Query Secrets Revealed MSDN.Microsoft.com/library Integrate Far-Flung Data into Your Spreadsheets with the Help of Web Services Updating Excel From the Web And: Web Queries and Dynamic Chart Data in Excel 2002 [Edited entry from 1/15/2004] See all Topics <Doug Klippert@ 3:43 AM
Comments:
Post a Comment
Thursday, March 12, 2009 – Permalink – Insert>FieldsTiny code snippets
"Some 80-plus fields are built into Word that provide information about the file and the user; store, display, and manipulate reference information; and link the document to other applications - all without a bit of code."
In 2007 you can use the =(Formula) field. On the Insert tab look for Quick Parts:  [Edited entry from 1/14/2006] Labels: Word <Doug Klippert@ 3:48 AM
Comments:
Post a Comment
Wednesday, March 11, 2009 – Permalink – Frame that SlideMore PP blingFace it; we've seen every graphic in ClipArt and every background color combination. Putting a frame around an ordinary object can make it pop. Here is a link to instructions about how to frame your pictures. There is also a download for extra frames.  ComputerCompanion.com: Create Picture Frames in PowerPoint by Geetesh Bajaj [edited entry from 1/12/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
Tuesday, March 10, 2009 – Permalink – GIF EditorFree toolHere is an online GIF image editor. You can create animated GIF files and save them to your site or your machine. There is nothing to download. All the work is done on line.  "Create your own special effects with any GIF -- even animated ones! Resize it, colorize it, optimize it, and jazzercise it -- then save it and take it with you. You name it and you can do it! GIFWorks [Edited entry from 1/11/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:58 AM
Comments:
Post a Comment
Monday, March 09, 2009 – Permalink – Change Properties in Form ViewAlterations on the runAs you work with a form, you will, sometimes, find controls would benefit from minor tweaking. You may want to change the color of a text box, change the font that's used, or remove scroll bars. You may have been told switch to Design view to make changes. However, you can display the property sheets for a control while you're in Form view. To do so, click the Properties on the View menu, Right-click, or press [Alt][Enter]. As in Design view, the displayed properties relate to the control that is selected on the form. The property changes you make are reflected on the fly. You will be prompted to resave your form when you close it. [Edited entry from 1/10/2006] See all Topics Labels: Access <Doug Klippert@ 3:47 AM
Comments:
Post a Comment
Sunday, March 08, 2009 – Permalink – Seniors Surf TooNo Internet age limitYou don't have to show a drivers license (expired or not) to wander through cyber space,but. . . " . . I'm pissed as hell at how difficult software developers (hello Microsoft!) make their software. I'm pissed as hell at the amount of marketing junk which is loaded onto computers at the store. At every turn, my grandfather gets pop-up messages from AOL, Netscape, Real Media, Internet Explorer and more. I'm pissed that the desktop comes littered with promotionals for CompuServe and AT&T and Compaq which can be difficult to delete. It makes everything that much harder for a senior whose fingers are shaky, whose eyesight is poor and who has never operated anything more complex than a typewriter. Helping Seniors Get Online (by Amanda Erickson)  EMarketer.com As the oldest Baby Boomers prepare to turn 60 in 2006, marketers and the media are waking up to the power of older consumers. Unlike today's seniors, Boomers are dedicated Internet users and broadband fans. As they approach the next phase of their lives, they will challenge companies to keep up with their ever-demanding ways, both online and off. Also see: King County Seniors on line [Edited entry from 1/6/2006] See all Topics Labels: Internet <Doug Klippert@ 3:09 AM
Comments:
Post a Comment
Saturday, March 07, 2009 – Permalink – Control PanelBe empowered"Control Panel provides a set of special-purpose administrative tools so that users can configure the Windows, applications, and services environment. It includes default items in Control Panel for common tasks, for example, Display and Add Hardware. User-installed applications and services can also insert their own icons into Control Panel.
Control Panel [Edited entry from 1/5/2006] See all Topics Labels: Windows <Doug Klippert@ 3:35 AM
Comments:
Post a Comment
Friday, March 06, 2009 – Permalink – Make a ListHow to check itJanuary is the month that bird watchers try to find as many birds as they can. This is only one kind of list. This link helps you create a list of 453 Washington state birds and more. There's also a list for a motorcycle first aid kit. Checklists for Motorcyclists Also see: Pack Light And read this book to get yourself ready. (Maybe next year.) The Big Year : A Tale of Man, Nature, and Fowl Obsession [Edited entry from 1/4/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:52 AM
Comments:
Post a Comment
Thursday, March 05, 2009 – Permalink – The Big YearA Tale of Man, Nature, and Fowl ObsessionBy Mark Obmascik ISBN 0743245458 Free Press; (February 4, 2004) About the Author Mark Obmascik was the winner of the 2003 National Press Club Award for environmental journalism. He has a story tellers ability to, not only describe the setting, but to draw the reader into the adventure. Book Description 2.4 million people keep what is called a "life list" of birds they have seen. In the USA, some 50 million people lay claim to being bird-watchers or 'birders,' spending billions of dollars on birding-related travel and membership fees every year. A few compete in one of the world's quirkiest contests — the race to spot the most species in North America in a single year. And 1998 wasn't just a big year. It was to become the greatest birding year of all time. Quote "Every year on January 1, a quirky crowd of adventurers storms out across North America for a spectacularly competitive event called a Big Year — a grand, grueling, expensive, and occasionally vicious, "extreme" 365-day marathon of birdwatching.
Labels: Books <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Wednesday, March 04, 2009 – Permalink – Animate Window SizeSo cool!The following macro has little or no practical computing value, but it can add a "way cool" element when a worksheet is unhidden. There are three states that a worksheet can be in; Minimized, Maximized, and Normal. From AutomateExcel.com: ActiveWindow.WindowState (By Mark William Wielgus) Also fun: Sub SheetGrow() Dim x As Integer, xmax As Integer With ActiveWindow .WindowState = xlNormal .Top = 1 .Left = 1 .Height = 50 .Width = 50 If Application.UsableHeight > Application.UsableWidth Then xmax = Application.UsableHeight Else xmax = Application.UsableWidth End If For x = 50 To xmax If x <= Application.UsableHeight Then .Height = x If x <= Application.UsableWidth Then .Width = x Next x .WindowState = xlMaximized End With End Sub # posted by Joerd : 12/30/2005 [Edited entry from 12/30/2005] See all Topics Labels: Excel <Doug Klippert@ 3:24 AM
Comments:
Post a Comment
Tuesday, March 03, 2009 – Permalink – A Hot Spot in Your PocketOr at least nearbyIt'll cost about $1,000, but think about the bragging rights! "I love the fact that more and more devices are sporting built-in Wi-Fi. The lone hitch: Wi-Fi is useless without a hotspot.  Popular Science: Be Your Own Hotspot By Mike Outmesguine [Edited entry from 12/30/2005] See all Topics <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
Monday, March 02, 2009 – Permalink – Animate ChartsMake data more movingWipe away the drool that develops when looking at Office 2007 formatting and deal with what we've got. When you try to animate the chart be aware that not all of the animations work. "Fly in" does not work. "Box" does. "You can add some animation to your chart for dramatic effect. You can animate the chart as a whole or animate elements of the chart."Office.Microsoft.com: Present sales reports in PowerPoint Also see: Ungroup and Animate Ellen Finkelstein: Animate Tables Animate 2007 Tables [Edited entry from 12/29/2005] See all Topics Labels: PowerPoint <Doug Klippert@ 3:15 AM
Comments:
Post a Comment
Sunday, March 01, 2009 – Permalink – Where in the World is it Raining?Weather maps from around the worldWant to see what the weather is like on the other side of the earth, or next door? From Aruba to Zambia. Rather than wait on an all weather channel or sticking your head outside, try this site: FallingRain.com  Old Tacoma See all Topics Labels: Addendum <Doug Klippert@ 3:51 AM
Comments:
Post a Comment
|
