|
Host your Web site with PureHost! |
![]() 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
Tuesday, June 30, 2009 – Permalink – Thirtieth Condition FormattingThree is not always enoughPre-2007 Excel gives the user the ability to specify up to three conditions under Format>Conditional Formatting. If that is not enough, Frank Kabel and Bob Phillips of xlDynamic.com offer a free download that extends the conditions to 30! ![]() Extended Conditional Formatter Also see: Conditional Formatting (including 2007) [Edited entry from 5/15/2006] See all Topics Labels: Excel <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Monday, June 29, 2009 – Permalink – Access Tools for Free or FeeShareware/FreewarePeter De Baets has some for pay and some for free downloads at Peter's Software. In the past I have used his Shrinker-Stretcher ShrinkerStretcher will automatically rescale/resize your MS Access forms, controls, and fonts to fit any screen resolution, desktop scheme, or font setting. For free includes:
[Edited entry from 5/14/2006] See all Topics Labels: Access <Doug Klippert@ 3:35 AM
Comments:
Post a Comment
Sunday, June 28, 2009 – Permalink – 30 Days HathOne Day at a Time
Labels: Expression Web, FrontPage, HTML, Internet, Outlook <Doug Klippert@ 3:00 AM
Comments:
Post a Comment
Saturday, June 27, 2009 – Permalink – Exploding SlidesBreak up or Blow upKathy Jacobs, Microsoft MVP PowerPoint and OneNote, give the steps needed to make your shows a little more dramatic. "Have you ever wanted to have a picture appear on your screen as one thing and then blow apart to separate elements? It is a great technique for explaining parts of a process, photo, or structure in detail. Blowing Things Up! [Edited entry from 5/12/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:23 AM
Comments:
Post a Comment
Friday, June 26, 2009 – Permalink – Paper SkyscrapersFold your own steamshipThis beats paper airplanes. If you order you get hard paper cards with all the pieces. ![]() What exactly is a Micromodel? Micromodels are card or paper models that were originally sold from the 1940's through the 1960's. Most were designed by Geoffrey Heighway. MicroModelsUSA [Edited entry from 5/11/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:56 AM
Comments:
Post a Comment
Thursday, June 25, 2009 – Permalink – Compact Before SynchronizingA DB two stepIf you're working with a replicated database, always compact it twice before you synchronize. The first time you compact, Access marks objects that need to be deleted, but it doesn't actually remove them. The flagged objects are removed the second time you compact the database. Although there's no harm in additional compacting, there's no added benefit. This is particularly important to do when working with the Design Master. Each time you make design changes to the Design Master, a copy of the original object is kept in the database. If you edit and save a Report or Form 10 times, your database actually has 9 older versions of the form in it. The same is true if you change the schema of a Table or Query If you synchronize before compacting, all of the versions are sequentially sent to the other replicas until everything is in synch, and you can't reclaim the space taken up by the older versions. However, if you compact the database first, only the most recent form version is sent to the replica. [Edited entry from 5/10/2006] See all Topics Labels: Access <Doug Klippert@ 3:26 AM
Comments:
Post a Comment
Wednesday, June 24, 2009 – Permalink – Zoom, Zoom, ZoomUp close and free!Brian Friesen has created a web site called Freezerware. One of the clever pieces of free programming on the site is named ZoomIn ZoomIn is a screen magnification program allowing you to view any area of your screen under magnification. ZoomIn allows you to control the amount of zoom, view a pixels location and color, and save it as a bitmap. Some of the other free programs on the site are:
Plus a number of others Labels: Windows <Doug Klippert@ 3:37 AM
Comments:
Post a Comment
Tuesday, June 23, 2009 – Permalink – Mail Your MDB-ACDBDon't let Outlook stop youThere was a lot of frustration with Outlook 200x. If an Access MDB file is received, Outlook expects the worst and blocks the attachment. The trick has been to ZIP the file or change the extension to something like .DAT. Here's a registry trick that restores Outlook to the good old days. Outlook 2007, 2003, 2002 and Outlook 2000 SP3 allow the user to use a registry key to open up access to blocked attachments. (Always make a backup before editing the registry.) To use this key: If you are using this registry entry, a glance at Help>About Microsoft Outlook will show Security Mode: User Controlled above the license information.Slipstick.com: Opening .exe Attachments Also see: Shortcuts for Sending Access Objects via Email [Edited entry from 5/8/2006] See all Topics <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Monday, June 22, 2009 – Permalink – Presentation PrepReview before you're reviewedThings to keep in mind as you prepare your presentation. From Scott Hanselman's blog:
Labels: PowerPoint <Doug Klippert@ 3:21 AM
Comments:
Post a Comment
Sunday, June 21, 2009 – Permalink – Clip Art at HomeInstall moreDo you remember all of the clip art that was available locally with Office XP? When you have an Internet connection, you have access to the Office Online collection, but if you would like more clip art installed on your machine: A small amount of sample clip art images was included The 2007 Office systems and Office 2003 and is part of the "local collection" that is searched when you do not have Internet access to the Microsoft Office Online Clip Art and Media Web site. Office 2003 no longer included a media content CD with additional clip art. However, the Microsoft Office XP Media Content CD can still be installed locally or on a network share.Support.Microsoft.com How to add clip art to Clip Organizer in a 2007 Office system and in Office 2003 [Edited entry from 5/5/5006] See all Topics Labels: Access, Excel, Expression Web, FrontPage, PowerPoint, Vista, Windows, Word <Doug Klippert@ 3:53 AM
Comments:
Post a Comment
Saturday, June 20, 2009 – Permalink – Scripts You Can UseDHTML, Javascripts, PHPDynamic Drive provides original DHTML & Javascripts to enhance your web site. There is an extensive collection as evidenced by this TOC.
DynamicDrive.com [Edited entry from 5/4/2006] See all Topics Labels: Expression Web, FrontPage <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Friday, June 19, 2009 – Permalink – Dead Yet?Approximate your last breathLet me guess. The odds are that you are less than 77.6 years old. The longevity figures have increased as medical science finds ways to hold off sending a final bill. The Centers for Disease Control and Prevention, and the National Center for Health Statistics have almost all the data you'll need between now and then: Life Expectancy ![]() My high school held a 100 year reunion September 15. 2006. Of the 38,797 graduates, 24,176 or 62% could still be alive. Living Graduates CelebrateStadium.com Stadium History Maybe you saw the movie: 10 Things I Hate About You [Edited entry from 5/3/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:33 AM
Comments:
Post a Comment
Thursday, June 18, 2009 – Permalink – Über UpdaterUniversalTo check on the latest version of a piece of software, you can poke around Tools, Tasks, About or some other menu.To check out your whole machine including programs that weren't written by Microsoft, or Adobe, look at CleanSofts Update Notifier What is Update Notifier?It will show you updates for programs you forgot you ever installed. It's a simple download app that is not "installed". CleanSofts.org See all Topics <Doug Klippert@ 3:25 AM
Comments:
Post a Comment
Wednesday, June 17, 2009 – Permalink – VBA Variable ProblemsExplicit protectionIt's good practice to always use the Option Explicit statement in the beginning of your code modules to ensure that all variables are unambiguously declared in your procedures. With this process in place, you'll receive a "Variable not defined" error if you try to execute code containing undeclared variables. Without this statement, it's possible to mistype variable names, which would be interpreted as new Variant type variables. This could severely impact the results of your code, and you might not ever know it. If you do find a problem, tracking down where the error is can be a chore. Although you can manually type the statement into your modules, changing a setting in Access can ensure that the statement is always added to new modules.
[Edited entry from 5/2/2006] See all Topics Labels: Access, Excel, PowerPoint, Word <Doug Klippert@ 3:33 AM
Comments:
Post a Comment
Tuesday, June 16, 2009 – Permalink – Resend on BehalfAlternate to ForwardLet's say you get a message that you would like to forward, but you don't necessarily want to take "ownership."
IMPORTANT: If the recipient clicks the Reply button, his message will go to the original sender, not to you. ![]() Thanks to Ed Bott for pointing this out, EdBott.com [Edited entry from 5/1/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:53 AM
Comments:
Post a Comment
|