|
Host your Web site with PureHost! |
![]() Friday, July 31, 2009 – Permalink – Delete DaysErase the futureIf the need should arise to clean out your calendar and start fresh, here's how. You don't have to erase all appointments. You can choose which groups deserve oblivion. For Microsoft Office Outlook 2003
How to delete all Outlook Calendar items Outlook 2007 appears to work the same way: ![]() [Edited entry from 6/26/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:15 AM
Comments:
Post a Comment
Thursday, July 30, 2009 – Permalink – Protected Spell CheckerCorrect the protectedUnfortunately, Word's protection feature disables a huge number of important functions, even if you only protect a single section of a document. Besides the spellchecker, many other items on the View, Insert, Format, Tools and Table menus are disabled, as well as most items on the Drawing, Database, Visual Basic and Picture toolbars. This MS Word MVP FAQ Site article lays out the steps needed to Enable the spellchecker in a protected document. One of the important elements is "NoReset=True". The act of removing and then re-protecting a document will reset the data without this line.In Office 2007 Protection is found on the Review tab:
[Edited entry from 6/25/2006] See all Topics Labels: Word <Doug Klippert@ 3:01 AM
Comments:
Post a Comment
Wednesday, July 29, 2009 – Permalink – Test Your Web SiteHow does your site score?Here are a collection of tools that can be used to analyze your web site for validity. Sorry, it doesn't check for source information reliability.
Juicystudio.com: Quality Assurance [Edited entry from 6/23/2006] See all Topics Labels: Expression Web, FrontPage, HTML, Internet <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Tuesday, July 28, 2009 – Permalink – Stop Spock SaluteNo more three fingersIf you are tired of crunching down three keys to logon your machine, here is the way to get rid of Ctrl+Alt+Delete. It does involve a registry hack so be careful and back up the entries before doing this.
Winguides.com: Press Ctrl+Alt+Delete Before Logon [Edited entry from 6/22/2006] See all Topics <Doug Klippert@ 3:50 AM
Comments:
Post a Comment
Monday, July 27, 2009 – Permalink – And the Audience Slept onAre you the only one awake?When you prepared your talk you were sure that everyone would be excited to hear it. "I sat in the back of the classroom, observing and taking careful notes as usual. The class had started at one o'clock. The student sitting in front of me took copious notes until 1:20. Then he just nodded off. The student sat motionless, with eyes shut for about a minute and a half, pen still poised. Then he awoke, and continued his rapid note-taking as if he hadn't missed a beat." Perhaps you need more than PPT slides and a hoary joke. "Adult learners can keep tuned in to a lecture for no more than 15 to 20 minutes at a time, and this at the beginning of the class. . . Joan Middendorf and Alan Kalish Teaching Resources Center Indiana University The National Teaching & Learning Forum: The "Change-Up" in Lectures [Edited entry from 6/21/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:21 AM
Comments:
Post a Comment
Sunday, July 26, 2009 – Permalink – Fiscal Year in AccessMake up your own yearYou can show a custom Fiscal Year starting June, 1 and ending May 31. BeginFiscalYr = DateSerial(Year(Date), 6, 1) EndFiscalYr = DateSerial(Year(Date) + 1, 6, 1) - 1 Also: Calculating a future or past date in Access [Edited entry from 6/19/2006] See all Topics Labels: Access <Doug Klippert@ 3:26 AM
Comments:
Post a Comment
Saturday, July 25, 2009 – Permalink – Multiple Mail DragQuick trickTo send an e-mail message to a number of people in your Contacts file, hold down the CTRL key and select the individual recipients. Drag the selection to the Inbox icon on the Outlook bar. A new blank pre-addressed e-mail form will open for you. If you wish to schedule an appointment, drag the selection to the Calendar icon. The definitive site for more information about Outlook is: Slipstick.com [Edited entry from 6/18/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
Friday, July 24, 2009 – Permalink – May I Comment on Your Balloon?Markup stuffHow to turn off balloons for comments and track changes in Word. This article describes how to turn off the balloons that appear for comments and track changes in the right side margin of your Microsoft Word 2002 or Microsoft Office Word 2003 document.Note This process only hides the balloons for comments and track changes. These steps do not remove any changes. Frequently Asked Questions About Comments Using Tracking and Reviewing Features in Microsoft Word 2002/XP Tutorial In 2007: ![]() [Edited entry from 6/17/2006] See all Topics Labels: Word <Doug Klippert@ 3:15 AM
Comments:
Post a Comment
Thursday, July 23, 2009 – Permalink – Excel VBA Help FileDownload from MicrosoftHere is a downloadable compiled Help file covering the vagaries of Excel VBA. You can use this file without having to, necessarily opening the application. Excel 2003 VBA Language Reference [Edited entry from 6/16/2006] See all Topics Labels: Excel <Doug Klippert@ 3:56 AM
Comments:
Post a Comment
Wednesday, July 22, 2009 – Permalink – Automated NewsletterASP and HTMLPre-RSS, the predominate method of communication for members of a like minded group was through an emailed newsletter. Word actually works fine with mail merge to email, but if you want to combine the data gathering and the distribution in a neat package, take a look at this tutorial. Step 1 : Create a simple HTML Form where users can insert their email addresses and an ASP page which will receive the Form email address from the HTML page and insert it into the database. Stardeveloper.com: An ASP Tutorial to create your own News Letter [Edited entry from 6/15/2006] See all Topics <Doug Klippert@ 3:52 AM
Comments:
Post a Comment
Tuesday, July 21, 2009 – Permalink – Free Fonts, Free DrinksTypographic connectionsFonts can be addictive. There can always be an imagined need for one more curly Q. Here is a collection of possible links. Luc Devroye joined the School of Computer Science at McGill University in 1977 as a young "snotnose." " Please do not visit this disappointing web site. Most of the links are dead: they die faster than I can renew them, and there is nothing I can do about it short of giving up my daytime job and divorcing my family, and I love both of them too much for that. Type Design, Typography, Typefaces and Fonts [Edited entry from 6/14/2006] See all Topics Labels: Windows <Doug Klippert@ 3:38 AM
Comments:
Post a Comment
Monday, July 20, 2009 – Permalink – I Need More GuidesLine it up straightA slide looks best when the objects line up correctly. While it can be done by trial and error, it is easier to use the Grid and Guides feature. Go to View>Grid and Guides. Choose to put a check to select Display grid on screen and/or Display drawing guides on screen. If you like using guides, you can produce additional guides by holding the CTRL key while dragging on an existing guide. Extraneous guides can be dragged of the screen. In 2007 in the Drawing group on the Home tab: [Edited entry from 6/13/2007] See all Topics Labels: PowerPoint <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Sunday, July 19, 2009 – Permalink – Your Grand-cestors SworeYour Grandmothers told them to stopWhat is there about a well placed curse that spices a novel or a conversation? Perhaps it's genetic or evolutionary. "The Jacobean dramatist Ben Jonson peppered his plays with fackings and "peremptorie Asses," and Shakespeare could hardly quill a stanza without inserting profanities of the day like "zounds" or "sblood" - offensive contractions of "God's wounds" and "God's blood" - or some wondrous sexual pun. Almost before we spoke Refered to by: LanguageHat.com The Antiquity Of Cursing [Edited entry from 6/12/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:16 AM
Comments:
Post a Comment
Saturday, July 18, 2009 – Permalink – Auto FormJust add DataHighlight a Table in the Objects Table view. Go to the main menu bar and click on Insert. Towards the bottom of the menu, you'll find an entry for "AutoForm" Click on it and Access will create a data entry form based on the selected table. When you close the AutoForm, you will be asked if you want to save changes. Click Yes. (In 2007 go to Create>Form) The default name will be the name of the table. If you are using Hungarian notation, change the name from "tblCustomers" to "frmCustomers" and click OK. Also see: Hungarian Notation [Edited entry from 6/9/2006] See all Topics Labels: Access <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Friday, July 17, 2009 – Permalink – Save Clean DocumentProtect your layoutSometimes a Word document does not open as well laid out as you intended. The page numbers may be off (the numbers may be repeated). Formatting marks may be displayed (not a big thing, but not neat). This can happen if:
The page numbers in the TOC are incorrectly displayed [Edited entry from 6/9/2006] See all Topics Labels: Word <Doug Klippert@ 3:45 AM
Comments:
Post a Comment
Thursday, July 16, 2009 – Permalink – Access-Excel-XML-HTMLTransfer dataXML makes data transferable between applications. Here is a tutorial with downloadable files. Some simple guidance of how to transfer data from Excel or Access into HTML web pages using XML data files. VBA programs can be used to export data tables from Excel or Access into simple XML files. There are several examples of using different methods to display the XML and XSL files on web pages in order to quickly share your data with others. An introduction to Excel and XML data files Also: Some nice photos and calendar layout: Monthly calendar with photos [Edited entry from 6/8/2006] See all Topics <Doug Klippert@ 5:43 AM
Comments:
Post a Comment
Wednesday, July 15, 2009 – Permalink – Restore DefaultsOffice 2003 redoTo reset the original settings in Office 2003, follow these steps. Make sure that you back up your files before you follow these steps.
Microsoft Office Diagnostics in 2007 replaces Diagnose and Repair: Howtogeek.com [Edited entry from 6/7/2006] See all Topics <Doug Klippert@ 3:22 AM
Comments:
Post a Comment
Tuesday, July 14, 2009 – Permalink – Print ProblemsSome clues"You've finished your report, presentation, or cost analysis using a Microsoft Office program. The information is rich with data and detail. Now comes the final step: printing it and showing the world your hard work on paper. This is the point at which printing can give you a headache. Right when you want to wrap up your work, project, or school assignment, questions start popping into your mind" Troubleshoot your printing problems in Office [Edited entry from 6/6/2006] See all Topics <Doug Klippert@ 3:35 AM
Comments:
Post a Comment
Monday, July 13, 2009 – Permalink – Simple ShowsIn brevity is successBlogger/entrepreneur Guy Kawasaki is in league with the minimalist branch of the PowerPoint society. Tired of sitting through mind and body numbing presentations by people more interested in technique than content, he is evangelizing the 10/20/30 Rule of PowerPoint. "A PowerPoint presentation should have ten slides, last no more than twenty minutes, and contain no font smaller than thirty points." If "thirty points," is too dogmatic, the I offer you an algorithm: find out the age of the oldest person in your audience and divide it by two. That's your optimal font size. 10/20/30 Rule [Edited entry from 6/5/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:30 AM
Comments:
Post a Comment
Sunday, July 12, 2009 – Permalink – Plain NumbersI'd Like to Make It ClearPlain Figures is a method of transforming statistical and financial data into figures, tables and graphs that people readily understand. Have you ever:
Labels: Access, Excel, PowerPoint, Word <Doug Klippert@ 3:59 AM
Comments:
Post a Comment
Saturday, July 11, 2009 – Permalink – A Hoard of TipsGood for all levels of userAllen Browne's tips for Access users Here is a list of the sections on this site; something for everyone.
Labels: Access <Doug Klippert@ 3:17 AM
Comments:
Post a Comment
Friday, July 10, 2009 – Permalink – Delegate Delete DeliveriesChoose the folderWhen you delete items from a Mailbox folder of another user where you have deletion privileges, the deleted items go into your Deleted Items folder rather than that of the mailbox owner. Here are the steps to change that procedure: Exit and Logoff Outlook
Items deleted from a shared mailbox go to the wrong folder in Outlook [Edited entry from 6/2/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:33 AM
Comments:
Post a Comment
Thursday, July 09, 2009 – Permalink – Echo Document DataEnter once — use againEnter data in one place in a document and have it repeated elsewhere. There comes the time when you need to enter a clients name at the beginning of a document and you know that it will be repeated again many other places. Greg Maxey has collected a number of ways to make the task easier. Repeating Data [Edited entry from 6/1/2006] See all Topics Labels: Word <Doug Klippert@ 3:54 AM
Comments:
Post a Comment
Wednesday, July 08, 2009 – Permalink – Polyglot PolynomialsToolPak TranslatorI was disappointed recently when I tried to look up Eric Desart's ToolPak translator. I found his site "niet beschikbaar." I won't use the boy and wet thumb story, but Ron de Bruin did spring up to save the day and make the download available. "Ever wanted an oversight of the Analysis-ToolPak Add-In functions, their descriptions, their arguments, their VBA and Procedure names, and all of this in your LOCAL language including translations versus the corresponding English names? Analysis ToolPak Translator [Edited entry from 5/31/2006] See all Topics <Doug Klippert@ 3:59 AM
Comments:
Post a Comment
Tuesday, July 07, 2009 – Permalink – Photo BlogDaily shotsI don't see it mentioned very often, but Webshots.com has been expanding its offerings. They have a free screensaver/desktop background application. They also have a spot to upload your own pictures. Recently they started a Blog with a new shot each day. Blog.Webshots.com "With 7.2 Million monthly visitors and more than 520 million photos to explore, Webshots is one of the largest photo- and video-sharing sites. Webshots! Over 20 MILLION FREE screen saver and wallpaper photos! [Edited entry from 5/30/2006] See all Topics <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Monday, July 06, 2009 – Permalink – Re-color TransparentChange clip artRe-color Select a piece of clip art in WMF (Windows Meta File) format . The Picture toolbar should appear. (If the bar does not pop up, go to View>Toolbars and click on "Picture".) Move the mouse pointer over the toolbar icons until you find "Recolor Picture". Click on the icon. (In 2007, it is located under Format in the Adjust group on the left."Recolor>Set Transparent Color") You can now change any of the fill or line colors in the image. Transparent If the graphic is in BMP (Bitmap) format, there is an icon on the Picture toolbar to "Set Transparent Color". Click the icon then click on the color in the image that you would like to make transparent. Also: Indezine: Recolor Clip Art in PowerPoint by Geetesh Bajaj Semi-Transparent Images By Glen Millar PPTWorkbech.com You can produce various levels of semi-transparent images for applications right within PowerPoint, save them, and keep them for reuse. AwesomeBackgrounds.com: Tutorial about the transparency options in PowerPoint [Edited entry from 5/26/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Sunday, July 05, 2009 – Permalink – What if the Truth Teller Fibs?Who ya gonna believe?Snopes.com is a great source for answers about urban myths, legends and computer hoaxes. These articles appear on the Snopes site: TRUE: The Mississippi state legislature removed fractions and decimal points from the mathematics curriculum of public secondary schools. After you stop shaking your head, look at the bottom left corner of the page and click on "More information about this page." False Authority Syndrome [Edited entry from 5/27/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:39 AM
Comments:
Post a Comment
Saturday, July 04, 2009 – Permalink – Get Hooked UpLink to apps in OutlookThe Outlook bar is handy to jump from Mail to Contacts to Calendars, but you can do more with it. If you can locate the EXE of a program, it can be dragged to the Outlook bar to create a shortcut. Here is a collection of more things that can be done with hyperlinks. Slipstick.com: Using Microsoft Outlook Links [Edited entry from 5/26/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Friday, July 03, 2009 – Permalink – CSS, PHP, and all that stuffCollections of suggestionsUnder the belief that more information leads to more understanding, here is a site that may help you round the corners of web design and function. Besides CSS templates there are PHP code nibblets. In 2003 artypapers was created by R. Marie Cox as a springboard for ideas and a working space of technical implementation -- a place to test and build an extendable collection of core classes (alliteration!) that acts as an application framework for a diverse set of projects and applications. artypapers.com Also: Links and Discussion About the Best CSS Resources Available on the Web. CSS Help Pile [Edited entry from 5/22/2006] See all Topics Labels: Expression Web, FrontPage, HTML <Doug Klippert@ 3:56 AM
Comments:
Post a Comment
Thursday, July 02, 2009 – Permalink – Watermelon PicklesActually quite good
Getting in a pickle [Edited entry from 5/18/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:51 AM
Comments:
Post a Comment
Wednesday, July 01, 2009 – Permalink – Word ConvertersPick a flavorThere are fewer word processing formats to worry about than there used to be. For those that remain, MS Word provides "translators" or converters. The following file formats are built into Word.Support.Microsoft.com Description of the text converters that are available with Word 2003 Additional text converters and image filters are available in the Microsoft Office File Converter Pack [Edited entry from 5/16/2006] See all Topics Labels: Word <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
|