|
Host your Web site with PureHost! |
![]() Saturday, February 28, 2009 – Permalink – Parameter Queries DeuxAnother look at parametersThe ability to use dynamic criteria in a Query makes Access even more valuable.David Badurina operates NlueMooseTech.com. He has produced an Access Parameter Query Tutorial video that walks the viewer gently through the process. The site also has information on Excel and Word. (Parameter queries are also referenced here: Parameter v. Form) How to create a parameter query Using Parameter Queries [Edited entry from 2/26/2005] See all Topics Labels: Access <Doug Klippert@ 3:21 AM
Comments:
Post a Comment
Friday, February 27, 2009 – Permalink – Yeah, Sure, That's My EmailA lie will set you freeDodgeit.com allows you to create throwaway email addresses. It then delivers the email that comes into the resulting mailbox as an RSS feed that you and everyone else who can guess at your throwaway email address can read. Pick a throwaway address, say: NotMyAddress@dodgeit.com Give that address out to inconsequential sites. Check NotMyAddress from homepage of Dodgeit.com. Subscribe to an RSS feed to keep an eye on the mailbox.
[Edited entry from 12/25/2004] Labels: Outlook <Doug Klippert@ 3:23 AM
Comments:
Post a Comment
Thursday, February 26, 2009 – Permalink – Justify Clean UpMinimize white spaceWhen a document is formatted with columns, the text is often Justified. This can lead to a messy layout of words and letters. "When justifying text in Microsoft Word use the hyphenation feature to improve the look of your page. (Without hyphens). . . unnecessary 'white space' is distributed throughout. When hyphenation is turned on the overall typographic color of the page is much more even. To enable this feature in Microsoft Word do the following: After you have justified the columns in your document, choose from the "Tools menu" > Language > then from the dropdown menu, choose "Hyphenation", then choose "Automatically hyphenate document" ![]() FontBlog: Typography Tip #2 BTW, this goes along with one space after punctuation. Bill Hill - There is only one space after a period In Woody's Office Watch look for #2: "SQUISHED" JUSTIFICATION IN WORD [Edited entry from 12/23/2005] See all Topics Labels: Word <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Wednesday, February 25, 2009 – Permalink – Hide DigitsSimple obfuscationThe kid said, "Daddy, I know the secret password! It's star, star, star, star!" **** You can use functions to hide parts of sensitive data. Social Security Number 555-55-5555 =CONCATENATE("***-**-", RIGHT(B2,4)) Combines the last four digits of the SSN with the "***-**-" text string (***-**-5555) ![]() Credit Card Number 5555-5555-5555-5555 =CONCATENATE(REPT("****-",3), RIGHT(B3,4)) Repeats the "****-" text string three times and combines the result with the last four digits of the credit card number (****-****-****-5555) Microsoft Office Online: Display only the last four digits of identification numbers [Edited entry from 12/22/2005] See all Topics Labels: Excel <Doug Klippert@ 3:12 AM
Comments:
Post a Comment
Tuesday, February 24, 2009 – Permalink – Form DesignFancy functionalsHere is a discussion about how to design a form for use on the web. "Computers are supposed to make our lives easier, not more difficult. As usability-conscious designers, we can make our users' lives easier by thinking about the way people interact with our websites, providing clear direction, and then putting the burden of sorting out the details in the hands of the computers—not the users.
[Edited entry from 12/21/2005] See all Topics Labels: Expression Web, FrontPage, HTML <Doug Klippert@ 3:10 AM
Comments:
Post a Comment
Monday, February 23, 2009 – Permalink – Stars on Your DesktopSpace image wallpaperNASA is wandering around space snapping photos with an advanced form of a Brownie SureShot. Here is a collection of interstellar portraits and space art the can be used as wallpaper to be viewed as you warp thought the Internet. ![]() Veil nebula SpaceWallpapers.net [Edited entry from 12/20/2005] See all Topics <Doug Klippert@ 3:36 AM
Comments:
Post a Comment
Sunday, February 22, 2009 – Permalink – Troubleshoot PowerPointLive on tapeOn occasion, Microsoft presents Webcasts on interesting subjects.
"This Support WebCast will define troubleshooting issues in Microsoft PowerPoint and provide an overview of when and how to use available resources such as product Help and Microsoft Knowledge Base articles. We will also discuss how to determine where a problem is occurring and how to troubleshoot specific issues such as printing, opening a file, installation, movies, and starting the program."Troubleshooting fundamentals in Microsoft PowerPoint Here is a list of available downloadable webcasts On-demand Webcasts [Edited entry from 12/19/2005] See all Topics Labels: PowerPoint <Doug Klippert@ 3:56 AM
Comments:
Post a Comment
Saturday, February 21, 2009 – Permalink – Where in the World is . . .Your spy dollars at workThe World Factbook The World Factbook provides a 'snapshot' of the world. The online Factbook is updated regularly - generally weekly - throughout the year. A 46 Meg zipped version is also available. The World Factbook is in the public domain and may be used freely by anyone at anytime without seeking permission. However, US Code prohibits use of the CIA seal in a manner which implies that the CIA approved, endorsed, or authorized such use." When you find yourself worrying about the local car wash spilling drainage into the storm sewer, look at some of these environmental concerns:
www.CIA.gov [Edited entry from 12/18/2005] See all Topics Labels: Addendum <Doug Klippert@ 3:13 AM
Comments:
Post a Comment
Friday, February 20, 2009 – Permalink – Access on LineFree Basic InstructionMicrosoft has developed a very good collection of tutorials and samples for Office applications. They're located at Office.Microsoft.com Even if you haven't upgraded to 2007, these suggestions will work with most earlier versions. For Access look at: Access 2007 If you have avoided Access in the past, a least glance at "Getting started with Access and Database applications" Also: "When you click Practice in Access at the bottom of this page, a practice database will download to your computer and open in Access, and a separate window with practice instructions will appear alongside." ![]() [Edited entry from 12/17/2005] See all Topics Labels: Access <Doug Klippert@ 3:13 AM
Comments:
Post a Comment
Thursday, February 19, 2009 – Permalink – Protect Your AddressKeep the bots at bay"Spam is an incredible problem and it is getting worse - your e-mail address is a commodity and if you put it on a web page, it WILL eventually be found, spammed and sold to other spammers. The problem is that you have a web page and you need to make it possible for people to send you e-mail from your page but you don't want to get bombarded with spam - what can you do? MailMe PHP Form Mailer With Spam Blocking Also: Mailto script a simple little Mailto: script that allows you to choose who you want to email from a pull down menu (View source for code) Software Listing: Mailto Mailcrawlers and protectors [Edited entry from 12/16/2005] See all Topics Labels: Outlook <Doug Klippert@ 3:02 AM
Comments:
The following website creates a script for you to encode your email address. It is called the enoder.
Post a Comment
http://hivelogic.com/enkoder/form
Wednesday, February 18, 2009 – Permalink – SCORE TemplatesFree business adviceSCORE is a nonprofit organization providing small business advice and training. SCORE's 10,500 volunteers have more than 600 business skills. Volunteers share their wisdom and lessons learned in business. Our volunteers are working/retired business owners, executives and corporate leaders.Here are some of the available templates:
SCORE Template Gallery [Edited entry from 12/15/2005] See all Topics <Doug Klippert@ 3:01 AM
Comments:
Post a Comment
Tuesday, February 17, 2009 – Permalink – RSS with Expression Web/FrontPageRoll your ownIf you like the idea of building your own RSS feed, read on."Learn about RSS and how to programmatically create an RSS file for your FrontPage 2003 Web site. The download that accompanies this article contains a VBA project and an XSLT file that you can use to generate and display RSS feeds. Microsoft Developers Network: Creating an RSS Feed for Your FrontPage Web Site [Edited entry from 12/13/2005] See all Topics Labels: Expression Web, FrontPage <Doug Klippert@ 3:35 AM
Comments:
Post a Comment
Monday, February 16, 2009 – Permalink – GlossaryWhat does it all meanWe live in a world based on jargon and acronyms. For a little relief, try this site.Microsoft Office, Microsoft Windows, and Microsoft Windows Mobile-based devices are covered and more.
[Edited entry from 12/12/2005] See all Topics Labels: Windows <Doug Klippert@ 3:39 AM
Comments:
Post a Comment
Sunday, February 15, 2009 – Permalink – If We're in TroubleIt's Probably Because People No Longer Really ListenYes, now we can add Iraq to the evils perpetuated by PowerPoint.
Labels: PowerPoint <Doug Klippert@ 3:39 AM
Comments:
Post a Comment
Saturday, February 14, 2009 – Permalink – Dictionary means - never having to say huh?Google dictionary
Also check out http://wordweb.info/ ![]() "WordWeb Pro is a quick and powerful international English thesaurus and dictionary for Windows. It can be used to lookup words from almost any Windows program, showing definitions, synonyms and related words. There are also many proper nouns and usage examples. You can search for words matching a pattern, find and solve anagrams, and optionally search a large number of extra word lists." [Edited entry from 2/10/2005] See all Topics Labels: Addendum <Doug Klippert@ 3:57 AM
Comments:
Post a Comment
Friday, February 13, 2009 – Permalink – Data ModelingData bits and piecesWhile a few of us may be guilty of constructing databases on the run, and then trying to clean up the mess later, the wise ones plan ahead.What information will you need in the future? What reports are going to be requested? If you're the bean counter, do you need to count all the legumes? "Data modeling is probably the most labor intensive and time consuming part of the development process. Why bother especially if you are pressed for time? A common response by practitioners who write on the subject is that you should no more build a database without a model than you should build a house without blueprints. University of Texas at Austin Introduction to Data Modeling Finding the Perfect Fit By Tim McLellan AgileData.org: Data Modeling 101 DataModel.org [Edited entry from 12/9/2005] See all Topics Labels: Access <Doug Klippert@ 3:44 AM
Comments:
Post a Comment
Thursday, February 12, 2009 – Permalink – Digitally SignMessagesIf you have a need to protect the contents of your email messages, these links should point you in the right direction.Outlook supports the following features for cryptographic messaging: Overview of Cryptography in Outlook 2003 Free digital ids Slipstick.com: Encryption and Message Security Tools TheTechGap.com: Digital IDs in Outlook Verisign: Digital IDs [Edited entry from 12/8/2005] See all Topics Labels: Outlook <Doug Klippert@ 3:02 AM
Comments:
Post a Comment
Wednesday, February 11, 2009 – Permalink – Page NumbersA baker's dozen of ideasHere is a collection of tips about how to display information in Headers and Footers. Field codes are demonstrated. Remember that the brackets {} must be inserted with Ctrl+F9, not directly from the key board. Here's one suggestion Display the word "more" at the bottom of every page except the last page.WordMacros.com: Headers and footers and page numbers [Edited entry from 12/7/2005] See all Topics Labels: Word <Doug Klippert@ 3:12 AM
Comments:
Post a Comment
Tuesday, February 10, 2009 – Permalink – Dynamic AutoShape LinkShow the starHere's a hint that I had forgotten about.You can tie the result of a cell to an AutoShape. This displays the value in a more dramatic manner.
Thanks to AutomateExcel.com for the reminder. [Edited entry from 12/6/2005] See all Topics Labels: Excel <Doug Klippert@ 3:19 AM
Comments:
Post a Comment
Monday, February 09, 2009 – Permalink – Photo GalleryA CSS exerciseFrontPage had a Photo gallery template, and you can also save a PowerPoint show as a web page. For another take on the problem, here are the instructions needed to create a gallery using CSS. Click here to see what it might look like: ![]() How to Create a Photographic Gallery Using CSS By Stu Nicholls [Edited entry from 12/5/2005] See all Topics Labels: Expression Web, FrontPage, HTML <Doug Klippert@ 3:16 AM
Comments:
Post a Comment
Sunday, February 08, 2009 – Permalink – Zapf Your Own DingbatPrivate Character EditorWindows XP/Vista has its own, hidden, character creator, called the Private Character Creator .
After you have constructed and saved the design of your choosing, you can access it from the Character Map by selecting Start>Run "Charmap". Labels: Windows <Doug Klippert@ 3:23 AM
Comments:
Post a Comment
Saturday, February 07, 2009 – Permalink – Can We Serve Multiple Masters?Dual Masters and more schemesEarlier versions of PowerPoint were restricted to only one master design scheme per show. We strained to get around that by linking shows and pasting backgrounds over the designs. PowerPoint 2002+ changed that by allowing more than one design scheme. A PowerPoint master with the first name of "Echo", runs a nice tutorial site named EchosVoice.com. She has written a step-by-step tutorial to create Multiple Masters for PPT 2002 and beyond. Makes you want to dance. (Echo's own image) ![]() [Edited entry from 12/3/2005] See all Topics Labels: PowerPoint <Doug Klippert@ 3:26 AM
Comments:
Post a Comment
Friday, February 06, 2009 – Permalink – Rewind DVDsSpeed the processSometimes one finds a solution to a problem that is not seeking an answer. "Guaranteed Lowest Price on the Internet for DVD Rewinding Digital Velocity ![]() DVD Rewinder [Edited entry from 12/2/2005] See all Topics Labels: Addendum <Doug Klippert@ 3:07 AM
Comments:
Post a Comment
Thursday, February 05, 2009 – Permalink – Other Right ClicksA couple overlookedRight-clicking on objects, such as Tables, Reports or Queries, gives you the opportunity to print, copy, and work with them. There are other options revealed by right-clicking on the Database window itself. Right-click on the empty white space of the Database window can lead to Relationships. If you right-click on the edge of the window, you'll find a link to Access database properties, startup activity for the current database, or open a new database. Right-clicking on the Database window also lets you configure the items in the Groups bar. [Edited entry from 12/1/2005] See all Topics Labels: Access <Doug Klippert@ 3:58 AM
Comments:
Post a Comment
Wednesday, February 04, 2009 – Permalink – Automate Word TablesVBA examples and instructionsThe Microsoft Developer's Network has a pretty comprehensive article on programmatically working with data and Word tables. "You can look at the world as split into applications that store data (databases) and applications that present information, such as Microsoft Office Word 2003 and Microsoft Office PowerPoint 2003. Increasingly, the end user demands to display database content in documents and presentations.
Labels: Word <Doug Klippert@ 3:06 AM
Comments:
Post a Comment
Tuesday, February 03, 2009 – Permalink – Internet 099Basics and BeyondA San Francisco company called Learn the Net has produced a basic on-line tutorial about the Internet. If you need a fundamental primer, this might be a place to look. It is not a series of scaled down "baby talk" lessons. You can drill down though the meaning of 403/404 error codes and links to WW3 Generic URI Syntax (RFC 2396) standards. That is if you know how to drill down. "Throughout Learn the Net--in fact on most web pages--you will see words that are in color and often underlined. By clicking on these words, known as hypertext, you jump to other places on the page, to other pages on the site, or to other resources on the Internet." www.LearntheNet.com [Edited entry from 11/27/2005] See all Topics Labels: Expression Web, FrontPage, HTML <Doug Klippert@ 3:08 AM
Comments:
Post a Comment
Monday, February 02, 2009 – Permalink – Don't DisplayLogon, Logoff, Startup and Shutdown Status MessagesTo turn these off: Start Regedit Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system If it is not already there, create a DWORD value named DisableStatusMessages Give it a value of 1
<Doug Klippert@ 3:06 AM
Comments:
Post a Comment
Sunday, February 01, 2009 – Permalink – MailTo ShortcutJust a quick noteYou can create a shortcut on your desk top that will start or switch to your default email application. You can also fill in parts of the message if you want. Right-click an empty spot on the desktop and choose New>Shortcut. In the box that says "Type the location of the item", enter something like: mailto:All@Once.com. ![]() The University of Nebraska at Lincoln has some other entries you may want to try. They are intended as HTML hyperlink references, but some of them work as shortcuts too. MailTo Outfront.net also has some information: Getting More From 'mailto' [Edited entry from 11/30/2005] See all Topics Labels: Expression Web, FrontPage, HTML, Outlook, Vista, Windows <Doug Klippert@ 3:50 AM
Comments:
Post a Comment
|