|
Host your Web site with PureHost! |
![]() Saturday, October 31, 2009 – Permalink – Hiding Duplicates in Query ResultsOnce is enoughIt's easy to hide duplicate entries when you run a query, even though Access doesn't go out of its way to call attention to this ability.
Access displays unique records based on each field returned by the query. [Edited entry from 10/17/2006] See all Topics Labels: Access <Doug Klippert@ 3:10 AM
Comments:
Post a Comment
Friday, October 30, 2009 – Permalink – Thumbnail ViewsLittle pagesThe Thumbnail view can be used to see the layout of a page or to jump from one page to another. With Word 2003 and 2007, Thumbnail views are available in Normal, Print Layout, Outline, and Reading Layout views. Go to View>Thumbnails to display the Thumbnail pane to the left of your document. In 2007+ go to View>Navigation tab>Show. Thumbnail versions of your document will appear in a new pane to the left of your current document. Click on a thumbnail page and Word 2003/7 will automatically jump to the selected page. [Edited entry from 10/16/2006] See all Topics Labels: Word <Doug Klippert@ 3:09 AM
Comments:
Post a Comment
Thursday, October 29, 2009 – Permalink – Hep MeIt's EZThomas Brunt's Outfront.net has a number of web developer tips. Shirley Wood wrote an article about "Spell checking your web site" FrontPage uses the same dictionary as Word and Excel. A spell checker, however, only goes so far: Eye halve a spelling checker [Edited entry from 10/14/2006] See all Topics Labels: Excel <Doug Klippert@ 3:11 AM
Comments:
Post a Comment
Tuesday, October 27, 2009 – Permalink – PPT Secrets No MoreTutorials and downloadsHere's an exceptional collection of animation techniques as well as sample file you can use to emulate their brilliance.
PPT Tutorials [Edited entry from 10/12/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:57 AM
Comments:
Post a Comment
Monday, October 26, 2009 – Permalink – Office 2010 BlogsA collection of sourcesHere is a list of Blogs put out by Microsoft developers and proselytizers: Official MS 2010 Office Blogs Microsoft blogs about everything: Team Blogs See all Topics Labels: Addendum <Doug Klippert@ 3:27 AM
Comments:
Post a Comment
Sunday, October 25, 2009 – Permalink – Hep MeHelp topic locationsThis from Ron de Bruin:
Help Context IDs for Excel [Edited entry from 10/15/2006] See all Topics Labels: Excel <Doug Klippert@ 3:06 AM
Comments:
Post a Comment
Export Formatted SheetsAccess to ExcelAccess provides an easy way to export data to Excel through the Office Links feature. To use this feature, simply select a relevant database object and choose Tools>Office Links> Analyze It With Excel. The worksheet Excel creates includes some minor formatting applied to the field headings that appear in row 1. Some formatting in your original Access database affects the worksheet cell formatting as well. For example, if you're exporting from a datasheet, gridline and font attributes are carried over to Excel. If you use the Office Links feature to export data behind a form, text box shading and font properties are applied. The final result in Excel may not exactly match your Access data; however, you'll probably find that less work is required to get your Excel version of the data into an easily readable state. In Office 2007-10 it's External Data>Excel ![]() [Edited entry from 10/10/2006] See all Topics <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Saturday, October 24, 2009 – Permalink – What's in Your Head(er)?See it allThere are ways to see an email header. See: Email Headers Outlook-Tips.net shows a way to do it: . . . you can view the header and source together in the options dialog, if you edit a registry key. This works on mail downloaded from Internet mail transports only, not Exchange server mailboxes. However, if you access the mailbox using an Internet transport, you'll see the full source. Viewing Headers [Edited entry from 10/9/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:03 AM
Comments:
Post a Comment
Friday, October 23, 2009 – Permalink – Calculation Tool in WordSelect and AddIn Excel an instant answer is displayed on the Status bar, when a series of numbers is selected. If you would like to calculate lists or columns of numbers in Word, look at ToolsCalculate. It will display the answer AND let you paste the result in your document. ToolsCalculate can be added to a menu or tool bar. Pre-2007, it is available through Tools>Customize.
MVPS.org FAQ This is left over from the halcyon days of Word 2.0 when Woody Leonard and Ed Bott were but children. In 2007-10,
![]() Of course, you could use formulas: MicroSystems.com [Edited entry from 10/8/2006] See all Topics Labels: Word <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Thursday, October 22, 2009 – Permalink – Move Using AltOne sheet to anotherTo move data from one worksheet to another, highlight the data. Hold down the ALT key and move the mouse until the pointer arrow is on the border of the selection. Drag the selection down to the destination worksheet tab. When the arrow touches the tab, Excel switches to the desired worksheet. Now drag the selection to the correct position. Let go of the mouse and then the ALT key. To copy data hold down the CTRL+ALT keys and perform the steps above. BTW the screen will not scroll while you hold the ALT key down. [Edited entry from 10/6/2006] See all Topics Labels: Excel <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Wednesday, October 21, 2009 – Permalink – Halloween on One SlideScary trickKathryn Jacobs, PowerPointAnswers, has created a single slide presentation with a Halloween theme. Through the clever use of animation, AutoShapes, and witchcraft. A whole show is contained on just one slide. Pumpkin Time! Brainy Betty also has some free templates Halloween Backgrounds Also see Indezine: Halloween Templates [Edited entry from 10/4/2006] See all Topics Labels: PowerPoint <Doug Klippert@ 3:05 AM
Comments:
Post a Comment
Tuesday, October 20, 2009 – Permalink – Display Data OnceReport TrickSometimes, you may have data that needlessly clutters a report. For instance, suppose your report is listing the fields strCompany, strFirstName, and strLastName. If there are multiple names listed for each company, and the report is sorted by company name, repeating the company information is unnecessary. You may want to set a group header based on the company name, but there's an easier way to hide the redundant data.
![]() If the data in the modified control is the same as the data from the previous record, the control is hidden. [Edited entry from 10/2/2006] See all Topics Labels: Access <Doug Klippert@ 3:34 AM
Comments:
Post a Comment
Monday, October 19, 2009 – Permalink – Re-search ResearchLook againOutlook has a feature functionality for "Search Folders". Henrik Walther, at Outlook Exchange, has written a description of how to use this tool: Using Search Folders in Outlook Search Folders are a kind of new user interface for the Advanced Find functionality, which has been with us through several Outlook generations. The thing that makes Search Folders new and unique is the possibility for defined search criteria to be saved and represented through a kind of virtual folder in the Outlook client. What this means is it gives us a virtual folder view of the content in one or more "normal" folders, for which a search criteria has been defined. Also: Office.microsoft.com: Search Folders [Edited entry from 10/1/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:30 AM
Comments:
Post a Comment
Sunday, October 18, 2009 – Permalink – Theses by the NumbersColour or Color?The University of Calgary has a step by step tutorial on how to write a thesis.
Included are Word Thesis Templates Some of the hints may provide you with some help even if you use the letter "U" in a more parsimonious manner. [Edited entry from 9/30/2006] See all Topics Labels: Word <Doug Klippert@ 3:55 AM
Comments:
Post a Comment
Saturday, October 17, 2009 – Permalink – Shortcut BordersKeyboard trickUse Ctrl+1 to bring up Excels Formatting dialog box. Shift+B will take you to the Borders tab. Now you can use the following key strokes (2002+):
![]() Shortcuts for Applying Borders Ctrl+Shift+7 will outline a cell without having to display the Format dialog. [Edited entry from 9/29/2006] See all Topics Labels: Excel <Doug Klippert@ 3:26 AM
Comments:
Post a Comment
Friday, October 16, 2009 – Permalink – Plan for your SiteOutline then doAlways a good idea. Pre-plan and then do. Too often projects are started without a plan and too often plans are made and not carried through. "When creating a website there are several different tools and methods available, but it is important to plan the steps. This guide will help outline the important steps required for website creation and promotion. Information in this document should help readers avoid many pitfalls and save time throughout the process."
Website Creation Tutorial [Edited entry from 9/26/2006] See all Topics Labels: Expression Web, FrontPage, Internet <Doug Klippert@ 3:13 AM
Comments:
Post a Comment
Thursday, October 15, 2009 – Permalink – Definition of DefinitionOne Stop OneLookA plethora of punditry "If you have a word for which you'd like a definition or translation, we'll quickly shuttle you to the web-based dictionaries that define or translate that word. If you don't know how to spell the word, we'll help you do that too. No word is too obscure: More than 5 million words in more than 900 online dictionaries are indexed by the OneLook search engine. OneLook.com [Edited entry from 9/25/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:25 AM
Comments:
Post a Comment
Wednesday, October 14, 2009 – Permalink – Access to E-mailWhat's the Outlook?Garry Robinson from GR-FX Pty Limited of Australia and Scott McManus from Skandus, have a tutorial about: Processing E-Mail Orders using Outlook and Access. They have include sample database downloads and the code needed to make the engine work. "Using Microsoft Access and Outlook together can reduce manual processing of Ordering emails very substantially. I know this because sometimes it would take up to 15 minutes to undertake all the little steps of saving customer details into tables and newsletter lists. Also without software, it was very difficult to explain to other staff members what to do when an e-mail arrived. Now we can process the orders in a couple of minutes when Outlook email arrives in the correct folder." [Edited Entry from 9/24/2006] See all Topics <Doug Klippert@ 3:02 AM
Comments:
Post a Comment
Tuesday, October 13, 2009 – Permalink – Email GarageAuto ArchiveAuto archiving of old messages is a two-part process. Go to Tools>Options and choose the "Other" tab. Click the "AutoArchive" button. Select where you would like the archive.pst file to be stored and how often you want messages to be moved to the archive.pst file, for instance every 14 days. OKyour way out. AutoArchive is a process that searches for folders that have items that need to be saved. Now you need to set up the folders that you want AutoArchive to look at. Go to View>Folder list. Right click on a folder such as Inbox, Family letters, any other directory that you have created. On the Right click Shortcut menu, choose Properties. Choose the AutoArchive tab. Put a check next to "Clean out items older than" and choose the time period. You can decide to have items in that folder sent to an archive file of your choosing. For instance older than 3 months. OKyour way out. Now ever 14 days AutoArchive will look at the folders and archive files that have become older than 3months. Also see: Working with AutoArchive Default Settings - University of Wisconsin Outlook Email Archiving Tips and Tricks - The Naked PC Outlook Backup and Archive Procedures - Kellogg School of Management Setting Up Retention Settings in Outlook 2003 -Microsoft Office Online An Overview of Archive and AutoArchive - KB 290847 [Edited entry from 9/23/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:30 AM
Comments:
Post a Comment
Monday, October 12, 2009 – Permalink – Adjust a Page BorderFix the boxThere is a border around your title page, but the bottom line doesn't print. Usually the reason is that the bottom line (or on a landscape page, the right border) falls within your printer's unprintable area. Here are some suggestions for finding just where that area is and how to adjust your border so that it will print.
[Edited entry from 9/22/2006] See all Topics Labels: Word <Doug Klippert@ 3:18 AM
Comments:
Post a Comment
Sunday, October 11, 2009 – Permalink – Update Excel on the WebAuto RepublishYou can save an Excel file as a Web page and makes it easy to update data in a worksheet that has already been saved to the Web. Here is how to save an Excel file as a Web page and set it up it for automatic updates:
Save Excel as Web Page DevX.com: Four Ways to Use Excel on the Web Penn State: Interactive Excel on the Web [Edited entry from 9/21/2006] See all Topics Labels: Excel <Doug Klippert@ 3:46 AM
Comments:
Post a Comment
Saturday, October 10, 2009 – Permalink – Web FurnishingsClips, buttons, templatesZeroWeb.org accepts submissions and provides free downloads of web ingredients.
Web Graphics Clipart Zeroweb.org -- Free website layouts and templates, clipart, graphics and website tools. [Edited entry from 9/20/2006] See all Topics Labels: Expression Web, FrontPage, HTML, Internet <Doug Klippert@ 3:07 AM
Comments:
Post a Comment
Friday, October 09, 2009 – Permalink – Does Butter Fly?Not Birders - Butters?North American Butterfly Association The North American Butterfly Association (NABA) is, by far, the largest group of people in North America (Canada, United States, and Mexico) interested in butterflies. ![]() Here are some quotes from the FAQ:
Also See: An Obsession with Butterflies "Just living is not enough, said the Butterfly. One must have sunshine, freedom, and a little flower. " [Edited entry from 9/17/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:42 AM
Comments:
Post a Comment
Thursday, October 08, 2009 – Permalink – Copy PasteExcel tablesOne way to create a new table in an Access database from information included in an Excel spreadsheet is to select the pertinent data on the spreadsheet, including the field names. Copy the selection (Edit>Copy, or CTRL+C) Switch back to Access . With Tables objects being shown in the database window, choose Edit>Paste, or use the CTRL+V shortcut. Access will ask if the first row contains the field names and then will paste the information as a new database table. [Edited entry from 9/16/2006] See all Topics <Doug Klippert@ 3:44 AM
Comments:
Post a Comment
Wednesday, October 07, 2009 – Permalink – Outlook's RightThe bounty that is a right click.
Outlook-Tips.net [Edited entry from 9/15/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:02 AM
Comments:
Post a Comment
Tuesday, October 06, 2009 – Permalink – Unicode is BigMore symbols and lettersThis free download lets you see and select more characters in the Unicode set. The Unicode Character Grid shows all assigned characters and private use characters in Unicode 5.2. ![]() Here's a blog covering Scripts, Unicode, Character Encoding and BabelStone Stuff BableStone Blog [Edited entry from 9/14/2006] See all Topics Labels: Addendum, Expression Web, FrontPage, HTML, PowerPoint, Vista, Windows, Word <Doug Klippert@ 3:15 AM
Comments:
Post a Comment
Monday, October 05, 2009 – Permalink – Gambling for TuitionCasino tutoringAn education will probably increase your lifetime earnings. Why not make that probability work for you? Or not. ![]() Teaching probability can be challenging because the mathematical formulas often are too abstract and complex for the students to fully grasp the underlying meaning and effect of the concepts. Games can provide a way to address this issue. For example, the game of roulette can be an exciting application for teaching probability concepts. Illustrating Probability through Roulette More Roulette strategy and statistics: To Be Ahead And Quit The Laymans Guide to Probability "An in-depth but easily readable guide on probability theory, covering various aspects of the theory with a bias to gambling games and strategies. Includes working examples in an excel spreadsheet." [Edited entry from 9/15/2006] See all Topics Labels: Addendum <Doug Klippert@ 3:43 AM
Comments:
Post a Comment
Sunday, October 04, 2009 – Permalink – Who dat?And WhereLet's say you wanted to set up a web site for your friend Bob, who lives in Bosnia-Hercegovina. Would you know that the root zone code was .ba and that the contact person has an office at: Universtiy Telinformatic Centre (UTIC) Zmaja od Bosne 8 (objekat 33) Sarajevo 71000 Bosnia-Hercegovina See: International Assigned Numbers Association: Root-Zone Whois Information There is also a page that defines such top level domains as .COM and .NET. Generic Top-Level Domains BTW. Sorry feline fanatics, "The .cat domain is reserved for the Catalan linguistic and cultural community and is sponsored by Fundació puntCat" [Edited entry from 9/11/2006] See all Topics Labels: Expression Web, FrontPage, Internet <Doug Klippert@ 3:47 AM
Comments:
Post a Comment
Saturday, October 03, 2009 – Permalink – Clean Up Your PresentationDesign suggestions
Labels: PowerPoint <Doug Klippert@ 3:30 AM
Comments:
Post a Comment
Friday, October 02, 2009 – Permalink – Messy EmailJunky appearing addressesOffice-Watch is a great newsletter covering Email/Windows/Access and Office in general. One of their recent offerings tackled email addresses: Which of these email address (all fake) is formatted correctly? Further discussion at: Office-Watch.com [Edited entry from 9/7/2006] See all Topics Labels: Outlook <Doug Klippert@ 3:43 AM
Comments:
Post a Comment
Thursday, October 01, 2009 – Permalink – Guided HelpMicrosoft to the rescueGuided Help is a program that you can download from some Microsoft Knowledge Base articles. Depending on the task, Guided Help can automatically perform the task that is described in the article, or Guided Help can guide you through the steps to perform the task yourself.For Instance: Troubleshoot 2007-2003-2002 Word List of articles with Guided Help [Edited entry from 9/6/2006] See all Topics Labels: Word <Doug Klippert@ 3:40 AM
Comments:
Post a Comment
|