General discussion
-
CreatorTopic
-
August 30, 2005 at 5:01 pm #2190725
Topic is locked -
CreatorTopic
All Comments
-
AuthorReplies
-
-
August 30, 2005 at 6:19 pm #3047361
EXCEL Lotus 1-2-3? Excel! You could tell when L…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Lotus 1-2-3?
Excel!
You could tell when Lotus was being taught by the instructor’s chants of the multiple keystrokes. “Slash, F, Down arrow, Return, Slash, . . .”
“Another feature that illustrates 1-2-3’s human-engineering design is its jargon-free prompts, explanatory messages, and fail-safe mechanisms. Suppose I want to delete a spreadsheet file. When I type “/F”, I get a menu of -
August 30, 2005 at 6:19 pm #3047362
WINDOWS Service Definitions A primer “What are se…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Service Definitions
A primer
“What are services? By definition, it’s a program that runs invisibly in the background. But can’t the same thing be said for a number of programs that run in the background such as anti-virus programs? Yes, but the real difference is that services load and start running whether or not anyone logs into the computer, unlike a program that is launched from the -
August 30, 2005 at 6:19 pm #3047356
POWERPOINT Slide for the day Don’t forget Friday’…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Slide for the day
Don’t forget Friday’s Special
Let’s say you have a presentation that you are going to deliver to different people all week long.
You have Specials to demonstrate on Wednesday and Friday.Rather than having to re-shuffle your deck and try to remember which slide should be up on which day, look at this free add-on from PresentationPoint.com.
“PlanPoint is a free
-
August 30, 2005 at 6:19 pm #3047357
ACCESS Keyboard Navigation Change directions Yo…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Keyboard Navigation
Change directions
You can change how your direction arrow and Enter keys behave in Access.By default, when you press Enter the focus moves to the next field and the contents of the field are selected. When you press the direction arrow keys, the focus moves to the next field in the appropriate direction.
If you would like, you can set up the arrow keys to move from
-
August 30, 2005 at 6:19 pm #3047358
WINDOWS Path to Control Panel Browser direction …
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Path to Control Panel
Browser directionInstead of leaving the IE browser, to open Control Panel, just type in the address bar
(without quotes).“control panel\”
followed by whatever feature in the Control Panel you want.
For example,“control panel\display”
takes you to the display settings.
Also:
How to Open Control Panel Folders from the Command Prompt
[Updated entry from -
August 30, 2005 at 6:19 pm #3047359
FRONTPAGE Keyword Sniffer Analyze your site Here…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Keyword Sniffer
Analyze your site
Here is a tool to quickly explore a website for keywords, links, and meta tags.A Complete Meta Data Analysis System
The Terms They’re Searching On
No coding required.
It’s free. “The PowerSnoop.com Power Meta Analyzer system is designed this Meta Tag analysis tool to help webmasters analyze their web pages. This script analyzes not only the Meta Tags -
August 30, 2005 at 6:19 pm #3047360
EXCEL Sort Worksheets Order tabs Worksheets can…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL Sort Worksheets Order tabs Worksheets can be dragged and dropped into any order required. They can be set up in numeric or alpha order, but doing it by hand is a bother. Chip Pearson has written some macros that will do the job for you: Sorting Worksheets In Alphabetical Order Sorting In Custom Order Grouping Sheets By Color Here’s the code to sort by tab color: Sub -
August 31, 2005 at 10:24 am #3047088
WORD Certificate of Anything Make your own Give…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Certificate of Anything
Make your own
Give your kid an award for not setting the house on fire in the last 24 hours.
Make a formal presentation to your dog for scaring away imaginary burglars.
The desktop publishing power of your computer can create official (looking) honors.
Here’s how to create your own template:
OfficeArticles.com:
Create a Certificate Template in Microsoft WordHere’s a collection of free templates:
Southworth.com
Free Award And Certificate TemplatesEducationWorld.com:
Award Certificates
BrainyBetty.com
Certificate Templates
(These are PowerPoint templates)Office.microsoft.com:
Certificates
(86 Certificates, labels, etc. Word, PowerPoint, and Publisher)See all Topics
-
September 1, 2005 at 10:21 am #3055780
OUTLOOK Calendar on the Web Exchange not require…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK Calendar on the Web Exchange not required Outlook has made it possible to share your calendar on the Internet as a web page. Click Calendar. On the File menu, click Save as Web Page. Under Duration, set the Start date and End date. Under Options, set the options you want. (Show appointment details, use a background graphic) Under Save as, type the calendar name, and then specify the Web -
September 2, 2005 at 10:19 am #3055051
ACCESS An Access Primer No cost lessons This si…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS An Access Primer No cost lessons This site provides quite complete on line manual about the care and feeding of MS Access. What makes this tutorial special are the sample database files that can be used to demonstrate the various features. “Microsoft Access is a development environment used to create computer databases for the Microsoft Windows family of operating systems. This site -
September 3, 2005 at 10:19 am #3054220
POWERPOINT Copy/Move From one presentation to an…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT Copy/Move From one presentation to another Most of you would know that you can insert slides from another presentation by using the Slides from files menu option in the Insert menu. This is another (harder) way to do the same. Open the presentations you want to copy/move slides to and from. Click Slide Sorter on the View menu. On the Window menu, click Arrange All to display both -
September 4, 2005 at 10:19 am #3054104
EXCEL Array FormulasGood orderly direction An a…
by dklippert · about 18 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Array Formulas
Good orderly direction
An array is defined as “An orderly arrangement”. It can be thought of as a collection of data packaged in a container. The individual items in the container can be selected by referring to their location; first, second, and so on.
- Each argument within an array must have the same amount of rows and columns.
- You must enter an array by pushing Ctrl+Shift+Enter.
- You cannot add the {} (braces) that surround an array yourself, pushing Ctrl+Shift+Enter will do this for you.
- You cannot use an array formula on an entire column.
“Have you ever sat in front of your monitor pulling your hair out trying to identify duplicate entries in a list? If so, you should learn about Microsoft Excel’s array formulas. In fact, you can use array formulas to perform calculations that are otherwise impossible in Excel, and you can enhance the power of some of the program’s existing functions.”
Excel’s Array Formulas
By Helen BradleyChip Pearson:
Introduction To Array Formulas“Array Formulas are formulas that work with arrays, instead of individual numbers, as arguments to the functions that make up the formula”
PacBell.net/beban/:
The file “Array Functions” contains 27 Function Procedures and 2 Sub Procedures for manipulating arrays (and worksheet ranges).
Excel ToolsMumnet.tripod.com:
( Mathematical Ulterior Motives)
Ignorance – an excellent starting point for learningBob Ulmas:
Using Array Formulas in ExcelDaily Dose of Excel:
Anatomy of an Array FormulaSupport.Microsoft.com:
Sample Visual Basic macros for working with arraysLimitations for working with arrays in Excel
When to use a SUM(IF()) array formula
[Updated entry from 1/11/2004]See all Topics
-
September 5, 2005 at 10:18 am #3053963
ADDENDUM All Wood, All the Time More than everyt…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
All Wood, All the Time
More than everything you wanted to know about wood and wood things
“Efficient use of our nation’s timber resource is a vital concern. Because a major use of wood in the United States is in construction, particularly housing construction, good practice in this endeavor can have a profound impact on the resource.
This handbook is intended as an aid to more efficient use of wood as a construction material. It provides engineers, architects, and others with a source of information on the physical and mechanical properties of wood and how these properties are affected by variations in the wood itself.
Continuing research and evaluation techniques hold promise for wider and more efficient utilization of wood and for more advanced industrial, structural, and decorative uses.”
Chapter 1 — Characteristics and Availability of Commercially Important Wood
Chapter 2 — Structure of Wood
Chapter 3 — Physical Properties and Moisture Relations of Wood
Chapter 4 — Mechanical Properties of Wood
Chapter 5 — Commercial Lumber
Chapter 6 — Lumber Stress Grades and Design Properties
Chapter 7 — Fastenings“Nails in use resist withdrawal loads, lateral loads, or a combination of the two. Both withdrawal and lateral resistance are affected by the wood, the nail, and the condition of use. In general, however, any variation in these factors has a more pronounced effect on withdrawal resistance than on lateral resistance. The serviceability of joints with nails laterally loaded does not depend greatly on withdrawal resistance unless large joint distortion is tolerable.”
Chapter 8 — Structural Analysis Equations
Chapter 9 — Adhesive Bonding of Wood Materials
Chapter 10 — Wood-Based Composites and Panel Products
Chapter 11 — Glued Structural Members
Chapter 12 — Drying and Control of Moisture Content and Dimensional Changes
Chapter 13 — Biodeterioration of Wood
Chapter 14 — Wood Preservation
Chapter 15 — Finishing of Wood
Chapter 16 — Use of Wood In Building and Bridges
Chapter 17 — Fire Safety
Chapter 18 — Round Timbers and Ties
Chapter 19 — Specialty TreatmentsU.S. Department of Agriculture, Forest Service, Forest Products Laboratory
See all Topics
-
September 6, 2005 at 10:25 am #3064924
WINDOWS Files and Settings Transfer Wizard Let M…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS Files and Settings Transfer Wizard Let MS do the heavy lifting Computers will only put up with physical and programmatic abuse for so long. Also manufactures keep coming up with another latest and best. What ever the rational, when the time come to move from one machine to another, take a look at these tutorials on the use of the Transfer wizard that comes with Windows XP. -
September 7, 2005 at 10:21 am #3064518
FRONTPAGE Googol
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE Googol’s of Deskbars The competition grows Remember back less than two years ago when deskbars for search engines appeared? These add-ins could search the Internet or your local machine faster than before. Google was one of the first. Now there are competitors. Here are some reviews and comparisons: GoebelGroup.com: Desktop Search Tools Matrix Pandia.com: Desktop search tools -
September 8, 2005 at 10:18 am #3064162
EXCEL Information Functions Who, What, Where If…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL Information Functions Who, What, Where If you need to know if automatic calculation is on or off or the number of worksheets that are active, Excel can display the INFO. System Information: Current directory =INFO(“directory”) Available bytes of memory =INFO(“memavail”) Memory in use =INFO(“memused”) Total bytes of memory =INFO(“totmem”) Number of active -
September 9, 2005 at 10:20 am #3063770
POWERPOINT Copy/Move From one presentation to an…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Copy/Move
From one presentation to another
Most of you would know that you can insert slides from another presentation by using the Slides from files menu option in the Insert menu.
This is another (harder) way to do the same.Open the presentations you want to copy/move slides to and from.
Click Slide Sorter on the View menu. On the Window menu, click Arrange All to display both presentations.Click the slide you want to move, and drag it to the other presentation. When you drag and drop slides between presentations or from PowerPoint to other apps, Windows moves the slides instead of copying them. To keep the slides in the original presentation as well, press Ctrl while dragging and dropping.
To select multiple consecutive slides, click on the first one, then click on the last one while pressing the Shift key on the keyboard, and all slides between the first and the last will appear highlighted.
Note: To select more than one noncontiguous slide, press Ctrl while you click.
Also:
BellaOnLine.com:
Borrowing an Existing Slide from Another PresentationColgate University:
Inserting Slides from Another PowerPoint Presentation[Updated entry from 1/8/2004]
See all Topics
-
September 9, 2005 at 10:20 am #3063771
EXCEL Array Formulas Good orderly direction An a…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Array Formulas
Good orderly direction
An array is defined as “An orderly arrangement”. It can be thought of as a collection of data packaged in a container. The individual items in the container can be selected by referring to their location; first, second, and so on.
- Each argument within an array must have the same amount of rows and columns.
- You must enter an array by pushing Ctrl+Shift+Enter.
- You cannot add the {} (braces) that surround an array yourself, pushing Ctrl+Shift+Enter will do this for you.
- You cannot use an array formula on an entire column.
“Have you ever sat in front of your monitor pulling your hair out trying to identify duplicate entries in a list? If so, you should learn about Microsoft Excel’s array formulas. In fact, you can use array formulas to perform calculations that are otherwise impossible in Excel, and you can enhance the power of some of the program’s existing functions.”
Excel’s Array Formulas
By Helen BradleyChip Pearson:
Introduction To Array Formulas“Array Formulas are formulas that work with arrays, instead of individual numbers, as arguments to the functions that make up the formula”
PacBell.net/beban/:
The file “Array Functions” contains 27 Function Procedures and 2 Sub Procedures for manipulating arrays (and worksheet ranges).
Excel ToolsMumnet.tripod.com:
( Mathematical Ulterior Motives)
Ignorance – an excellent starting point for learningBob Ulmas:
Using Array Formulas in ExcelDaily Dose of Excel:
Anatomy of an Array FormulaSupport.Microsoft.com:
Sample Visual Basic macros for working with arraysLimitations for working with arrays in Excel
When to use a SUM(IF()) array formula
[Updated entry from 1/11/2004]See all Topics
-
September 9, 2005 at 10:20 am #3063772
ADDENDUM All Wood, All the Time More than everyt…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
All Wood, All the Time
More than everything you wanted to know about wood and wood things
“Efficient use of our nation’s timber resource is a vital concern. Because a major use of wood in the United States is in construction, particularly housing construction, good practice in this endeavor can have a profound impact on the resource.
This handbook is intended as an aid to more efficient use of wood as a construction material. It provides engineers, architects, and others with a source of information on the physical and mechanical properties of wood and how these properties are affected by variations in the wood itself.
Continuing research and evaluation techniques hold promise for wider and more efficient utilization of wood and for more advanced industrial, structural, and decorative uses.”
Chapter 1 — Characteristics and Availability of Commercially Important Wood
Chapter 2 — Structure of Wood
Chapter 3 — Physical Properties and Moisture Relations of Wood
Chapter 4 — Mechanical Properties of Wood
Chapter 5 — Commercial Lumber
Chapter 6 — Lumber Stress Grades and Design Properties
Chapter 7 — Fastenings“Nails in use resist withdrawal loads, lateral loads, or a combination of the two. Both withdrawal and lateral resistance are affected by the wood, the nail, and the condition of use. In general, however, any variation in these factors has a more pronounced effect on withdrawal resistance than on lateral resistance. The serviceability of joints with nails laterally loaded does not depend greatly on withdrawal resistance unless large joint distortion is tolerable.”
Chapter 8 — Structural Analysis Equations
Chapter 9 — Adhesive Bonding of Wood Materials
Chapter 10 — Wood-Based Composites and Panel Products
Chapter 11 — Glued Structural Members
Chapter 12 — Drying and Control of Moisture Content and Dimensional Changes
Chapter 13 — Biodeterioration of Wood
Chapter 14 — Wood Preservation
Chapter 15 — Finishing of Wood
Chapter 16 — Use of Wood In Building and Bridges
Chapter 17 — Fire Safety
Chapter 18 — Round Timbers and Ties
Chapter 19 — Specialty TreatmentsU.S. Department of Agriculture, Forest Service, Forest Products Laboratory
See all
Topics
-
September 9, 2005 at 10:20 am #3063773
WINDOWS Files and Settings Transfer Wizard Let M…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Files and Settings Transfer Wizard
Let MS do the heavy lifting
Computers will only put up with physical and programmatic abuse for so long.
Also manufactures keep coming up with another latest and best.What ever the rational, when the time come to move from one machine to another, take a look at these tutorials on the use of the Transfer wizard that comes with Windows XP.
Microsoft.com:
Using the Files and Settings Transfer Wizard
By Sharon CrawfordStep-by-Step Guide to Migrating Files and Settings
AumHa.org:
(Windows Support Center)
Files and Settings Transfer Wizard
(F.A.S.T. for Short)
by Gary WoodruffMC MCSE.com:
Using the Files and Settings Transfer Wizard
by Jason ZandriSee all Topics
-
September 9, 2005 at 10:20 am #3063774
FRONTPAGE Googol’s of Deskbars The competition gr…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Googol’s of Deskbars
The competition grows
Remember back less than two years ago when deskbars for search engines appeared? These add-ins could search the Internet or your local machine faster than before. Google was one of the first. Now there are competitors.
Here are some reviews and comparisons:
GoebelGroup.com:
Desktop Search Tools MatrixPandia.com:
Desktop search toolsUniversity of Wisconsin E-Business Consortium:
Benchmark Study of Desktop Search Tools (PDF)
(“There?s More to Search than Google & Yahoo!
An Evaluation of 12 Leading Desktop Search Tools”)
(UWEBC Decision Tools)Google.com
Google Desktop BetaSearchEngineWatch.com:
Google Enhances Desktop SearchOReillyNet.com:
Google Your DesktopCopernic.com:
Copernic Desktop SearchMSN.com
MSN Search ToolbarYahoo.com:
Yahoo! Desktop SearchAsk.com:
Ask Jeeves Desktop SearchBlinkx.com
blinkx v3.0 BETAGoogol:
“A googol is the large number 10100, that is, the digit 1 followed by one hundred zeroes. The term was coined in 1938 by nine-year-old Milton Sirotta, nephew of American mathematician Edward Kasner.”
See all Topics
-
September 9, 2005 at 10:20 am #3063768
EXCEL Information Functions Who, What, Where If…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Information Functions
Who, What, Where
If you need to know if automatic calculation is on or off or the number of worksheets that are active, Excel can display the INFO.
System Information:
- Current directory
- =INFO(“directory”)
- Available bytes of memory
- =INFO(“memavail”)
- Memory in use
- =INFO(“memused”)
- Total bytes of memory
- =INFO(“totmem”)
- Number of active worksheets
- =INFO(“numfile”)
- Cell currently in the top left of the window
- =INFO(“origin”)
- Operating system
- =INFO(“osversion”)
- Recalculation mode
- =INFO(“recalc”)
- Excel version
- =INFO(“release”)
- Name of system. (PC or Mac)
- =INFO(“system”)
More:
Excel-VBA.com:
Excel Spreadsheet Information Functions
See all Topics -
September 9, 2005 at 10:20 am #3063769
ACCESS Access Forum Ask your peers Here is a fo…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Access Forum
Ask your peers
Here is a forum populated by Access users and developers around the world.
Just a few of the recent inquiries:
- The Use of LIKE
- Calculated Field
- Conditional formatting
- Hide/Show Toolbars
- Change Default Printer without using print dialog
- Problems with duplicate matches in my queries
- Import Excel into Access Table
- Sending Email Via Lotus Notes
- Automated E-mail For Lotus Notes and Microsoft Outlook
- Print Report of the Form onscreen
- Table/Field Structure
- Hiding Access Background and taskbar
See all Topics
-
September 9, 2005 at 4:41 pm #3063681
ACCESS Access Forum Ask your peers Here is a fo…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Access Forum
Ask your peers
Here is a forum populated by Access users and developers around the world.
Just a few of the recent inquiries:
- The Use of LIKE
- Calculated Field
- Conditional formatting
- Hide/Show Toolbars
- Change Default Printer without using print dialog
- Problems with duplicate matches in my queries
- Import Excel into Access Table
- Sending Email Via Lotus Notes
- Automated E-mail For Lotus Notes and Microsoft Outlook
- Print Report of the Form onscreen
- Table/Field Structure
- Hiding Access Background and taskbar
See all Topics
-
September 10, 2005 at 12:41 pm #3063567
FRONTPAGE Photoshop Blog Templates Design suggest…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Photoshop Blog Templates
Design suggestions
I haven’t done any remodeling of this blog in awhile, but when I do I’ll be looking at Jennifer Apple’s site:
http://www.PhotoshopSupport.com
“Once you choose a blogging service and set up an account, you will be provided with a standard blog template. But this template will suffer from a cookie-cutter design, and if you don’t personalize it your blog may become lost. To be noticed your blog needs to make a splash – as there are more than ten million blogs out there. So what we’ll concentrate on here is working with some design elements that can help you add more zing to your blog.”
Tips For Blog Templates & Blog Design In Photoshop
Here are a few of the link categories:- Inspiring blog designs
- Free fonts for blogs
- Free photos for blogs
- Free blog templates
- Free blog backgrounds, tiles & patterns
- Free color schemes for blogs
See all Topics
-
September 10, 2005 at 12:41 pm #3063568
WORD Document Security What information are you g…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Document Security
What information are you giving away?
Word documents contain a lot of Metadata. Information about the Author, and, sometimes, a history of edits.
Here is a freeware program that dynamically analyses your work.
“TRACE! analyzes Microsoft Office documents and provides an “Always-On” document security risk rating to alert you to the presence of potentially costly violations of regulations as well as inside-out breaches of information security.
- Dynamic tracking of nearly 100 content security, privacy and compliance violations
- Always-on alerts with risk level warnings on problems in new and existing documents
- On demand or batch assessment of documents in folders, email and on websites
- Automatically updates as legislation and regulations change.
- Generating a report with TRACE! can be done in any of the following situations:
- On an active document that you may be working on
- By scanning a single document, multiple documents or a folder
- By scanning email
- By scanning a Website”
Also see:
Personal InformationSee all Topics
-
September 10, 2005 at 12:41 pm #3063569
MUSIC The Golden Striker By Ron Carter ASIN 7243…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
MUSIC
The Golden Striker
By Ron Carter
ASIN 7243 5 90832 2 3
Blue Note 2003About the Artist
Ron Carter on bass, Russell Malone on guitar, Mulgrew Miller on piano“Ron Carter is among the most original, prolific, and influential bassists in jazz. With more than 2,500 albums to his credit, he has recorded with many of music’s greats: Tommy Flanagan, Gil Evans, Lena Horne, Bill Evans, B.B. King, the Kronos Quartet, Dexter Gordon, Wes Montgomery, and Bobby Timmons. He later toured Europe with Cannonball Adderley.
From 1963 to 1968, he was a member of the classic and acclaimed Miles Davis Quintet. He was named Outstanding Bassist of the Decade by the Detroit News, Jazz Bassist of the Year by Downbeat magazine, and Most Valuable Player by the National Academy of Recording Arts and Sciences.
In 1993 Ron Carter earned a Grammy award for Best Jazz Instrumental Group, the Miles Davis Tribute Band and another Grammy in 1998 for Call ‘Sheet Blues’, an instrumental composition from the film ‘Round Midnight.”
Recording Description
“Tasteful” jazzContents
1. The Golden Striker
2. On And On
3. N.Y. Slick
4. Concierto De Aranjuez (Adagio Theme)
5. Cedar Tree
6. A Quick Sketch
7. Parade
8. A Theme In 3/4
9. Autumn LeavesSee (and hear):
RonCarter.net
(If you want some jazz to fill in the spaces while you work, you can have continuous sounds from this site)[updated entry from 1/1/2004]
See all Topics
-
September 10, 2005 at 12:41 pm #3063570
FRONTPAGE E-mail Delivery Design Don’t look like…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
E-mail Delivery Design
Don’t look like spam
A discussion:
“Transactional email can be a website’s customer service ambassador, but messages must first survive a ruthless selection process in the user’s in-box. Differentiating your message from spam is thus the first duty of email design.
Email is one of a website’s most powerful tools for strengthening customer service and increasing users’ confidence and trust in the site. Confirmation messages and other automated transactional email can complete the user experience: they reach out to customers in ways that are otherwise impossible for websites, which must sit still and wait for users to approach.”
From
Dr. Jakob Nielsen’s Alertbox
Automated Email From Websites to Customers
[
updated entry from 1/2/2004
]See all
Topics
-
September 10, 2005 at 12:41 pm #3063571
OUTLOOK Zip Problem Hidden files If you don’t u…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Zip Problem
Hidden files
If you don’t use a third party “zipper”, like WinZip, when you attempt to locate a zipped file to attach to an email message, the file appears to have vanished. You are forced to open Windows Explorer, find the file and then drag it into the Outlook message box
Cause: Windows has a system component that treats zip files like ordinary file folders and Outlook sees these files as folders. In most cases, it only happens when you don’t have third party compression programs installed, so you may see the behavior on one system but not another.
Solution: Disable Compressed folders. If you use a third party program you can leave compressed folders disabled.
To disable the feature at the Start menu, Run command, type:
regsvr32 /u zipfldr.dll
To restore the functionality, return to Start Menu, Run command and type:
regsvr32 zipfldr.dll
Slipstick.com:
Outlook doesn’t display zip files in the Insert file dialogWindowsNetworking.com:
Disable Windows XP’s built-in zip supportTweakXP.com:
Disable Search from looking in zip (compressed) filesPCAuthority.com:
Tech Support – Windows SearchSee all Topics
-
September 10, 2005 at 12:41 pm #3063565
WINDOWS WinPatrol Protection Installation warnin…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
WinPatrol Protection
Installation warnings
A favorite trick of spyware programs is to make changes to the Registry. They attempt to do this in the background without your knowledge. WinPatrol is like having a guard dog on duty to warn when intruders are skulking about.
Scotia, New York, August 9th, 2005
“BillP Studios announced today that results of recent tests show WinPatrol PLUS with R.I.D. will detect 100% of the top spyware threats on a Microsoft Windows-based PC. Recent results by independent testers confirmed WinPatrol’s “Real-time Infiltration Detection” methodology is effective in alerting users to newly installed software.”
“WinPatrol takes snapshot of your critical system resources and alerts you to any changes that may occur without your knowledge. You’ll be removing dangerous new programs while others download new reference files.
WinPatrol isn’t the only software we recommend for complete safety but with Scotty on Patrol you’ll find yourself informed on what’s going on inside your computer. WinPatrol puts you back in control of your computer so you’ll know what programs are and should be running at all times.”
See all
Topics
-
September 10, 2005 at 12:41 pm #3063566
EXCEL Locate Duplicates with Conditional Formatti…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Locate Duplicates with Conditional Formatting
Highlight entries
Conditional formatting can be set up by selecting the whole range, or for the first cell in the range and then copy down that conditional format. I find it is usually just as easy to select the whole range to start with. The formula will adjust itself.In this example, cell B2 has a heading of Product Numbers.
Select cell B3 (or the entire targeted range) and from the menu.
Select Format > Conditional Formatting.
The Conditional Formatting dialog opens with the initial dropdown saying
“
Cell Value Is
“.Click the arrow next to this, and choose
“
Formula Is
“.After selecting “
Formula Is
“, the dialog box changes appearance.
Instead of boxes for “
Between x and y
“, there is now a single formula box.You can type in any formula as long as that formula will evaluate to TRUE or FALSE.
The formula to type in the box is
=COUNTIF(B:B,B3)>1This says, “look through the entire range of column B.
Count how many cells in that range are the same value as what is in B3.”
(In the graphic, B7 is the Active cell.)That same comparison will be made in every cell that contains the conditional formatting.
(If your data is in column E and you are setting the first conditional formatting up in E5, the formula would be =COUNTIF(E:E,E5)>1.)
Anytime a duplicate appears in the range, it will receive the special formatting.
In this example, any time a duplicate number appears anywhere in column B, even if it is not itself formatted, the selected range will reflect the duplicate.
=COUNT(B:B,B3)>2 would count entries that appear more than two times.
=COUNT(B:B,B3)=2 would count entries that appear twice.If you want only a part of the column in the formula, it is easier to use absolute addresses, such as =COUNT($B$3:$B$200,B3)>1
Adapted from
MrExcel.com
Also see:
Chip Pearson’s
discussion of duplicates:
Duplicate And Unique Items In Lists
and:
Contextures.com:
Conditional Formatting
(See Hide Duplicate Values)[
Updated entry from 1/3/2004
]See all
Topics
-
September 10, 2005 at 12:41 pm #3065727
ACCESS Null, Nothing, Nada Empty entries “An exa…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Null, Nothing, Nada
Empty entries
“An example might be fax numbers in a customer database. If you store a Null, it means you don’t know whether the customer has a fax number.
If you store a zero-length string, you know the customer has no fax number.
Access gives you the flexibility to deal with both types of ’empty’ values.”From John L. Viescas at Viescas.com
Also:
AccessSolutions.co.uk:
Defining Null Valuesand:
Make Null ZeroSee all Topics
-
September 10, 2005 at 12:41 pm #3065728
ADDENDUM Bad Persons Is this your neighbor? “Th…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Bad Persons
Is this your neighbor?
“Three things you can count on in life: death, taxes, and screwing up. Don’t feel badly, though. Everyone does it, including your favorites from the worlds of business, television, music, and film. And most likely, no one is looking up your photograph on the web to see how badly you messed up this time! You won’t believe whom you’ll find with one of those attractive letter boards with the name of the local lockup underneath his or her illustrious chin.”
JAMES J. BULGER
Date of Birth: September 3, 1929
Hair: White/Silver
Place of Birth: Boston, Massachusetts
Eyes: Blue
Height: 5’7″ to 5’9″
Complexion: Light
Weight: 150 to 160 poundsBulger is an avid reader with an interest in history. He is known to frequent libraries and historic sites. Bulger is currently on the heart medication Atenolol (50 mg) and maintains his physical fitness by walking on beaches and in parks with his female companion, Catherine Elizabeth Greig.
Bulger and Greig love animals and may frequent animal shelters. Bulger has been known to alter his appearance through the use of disguises. He has traveled extensively throughout the United States, Europe, Canada, and Mexico.
Caution James J. Bulger is being sought for his role in numerous murders committed from the early 1970s through the mid-1980s in connection with his leadership of an organized crime group that allegedly controlled extortion, drug deals, and other illegal activities in the Boston, Massachusetts, area.
He has a violent temper and is known to carry a knife at all times. Considered armed and extremely dangerous if you have any information concerning this person, please contact your local FBI office or the nearest U.S. Embassy or consulate.
Reward The FBI is offering a $1,000,000 reward for information leading directly to the arrest of James J. Bulger.
Also ( in a different category):Your worst day:
And then there’s:
Charles Paul
” 14 days in an adult gaol and five years in a reformatory for allegedly stealing six pairs of his father’s drawers.”Here’s more information than you ever wanted to know:
State of Texas:
Death Row
See all
Topics
-
September 10, 2005 at 12:41 pm #3065729
POWERPOINT Show Tricks Help from an expert You’l…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Show Tricks
Help from an expert
You’ll use at least one of these tips in your next delivery.
Here are two of the suggestions:
12. Create an automatic agenda slide:
Use the Summary Slide feature to create a list of your slideshow’s slides. Select the slides to include in the Slide Sorter view, then click Summary Slide on the Outlining toolbar. Change the title of the new slide to Agenda and move it to the beginning of the presentation. From this slide, you can hyperlink each of the other slides’ names to their corresponding slides, then use this Agenda slide to navigate to topics the audience wants to discuss.
34. Create a slide list:
Display the Outline pane. (In PowerPoint 2002, display the Outline tab of the Outline pane.) Press ALT+SHIFT+1 to collapse the entire outline to show only slide titles. (This shortcut toggles between collapsing and expanding the outline.) Choose FILE > PRINT. From the
Print What
drop-down list, choose Outline View. Click OK.Presentations.com:
44 tips and tricks to help turbocharge your PowerPoint presentations
By Ellen FinkelsteinSee all
Topics
-
September 10, 2005 at 12:41 pm #3065722
OUTLOOK Security Prompt Avoid the warning “A pro…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Security Prompt
Avoid the warning
“A program is trying to automatically send e-mail on your behalf. Do you want to allow this?”
or:
This is the result of a security update in Outlook 2000 +.
Here’s how to get out of the problem:
. . .”a tiny program that sits in the taskbar and clicks the Yes button on behalf of you, when Outlook’s Security Guard opens prompt dialog saying that a program is trying to send an email with Outlook or access its address book. You can suspend/resume it by double-clicking its taskbar icon. Developers can automate its behavior by sending special messages.”
Information About the Outlook E-mail Security Update
Also see:
Automation Security from Slipstick.com
Administrative Options for the Outlook E-mail Security Update
[Updated entry from 1/5/2004]
See all Topics
-
September 10, 2005 at 12:41 pm #3065723
WORD WordPerfect? Word! I used to ask “How many…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
WordPerfect?
Word!I used to ask “How many have ever used WordPerfect?” Over the years it has gone from about 50% to blank stares.
WordPerfect (WP) couldn’t bring itself to accept the existence of Windows, and Microsoft ran past, taking over the market.
Word is Object-Oriented, WordPerfect is Stream-Formatted.
“What does this mean? Well, this basically means that when you make a change to a WordPerfect document, the changes take effect ‘From THAT Point Forward’. You generally don’t need to select an Object (e.g., a word, sentence, or a paragraph) in order to effect a change. You can simply select a color, a font, a paragraph style, etc, and the whole document will be affected (as stated, from that point forward). Stream Formatted is, as you can imagine, like a stream of formatting that flows throughout the document.
Word, on the other hand, is object-oriented. Every letter, word, sentence, and paragraph is an object. To help people grasp the concept of object-oriented programming, Microsoft uses a simple analogy: oranges. You can imagine that an orange has several attributes that can be changed: it has a color, a texture, etc. It can be changed by being painted or peeled. Therefore, once you understand that you need to select an object when you want to manipulate your Word document, you begin to understand how to work in Word.”
WP vs. Word
WP is still around. Mostly used in the legal profession by those who still bemoan the loss of powdered wigs.Here are some references:
The history of WordPerfect:
Almost Perfect
(a book by W. E. Peterson)Wikipedia:
WordPerfect
See all
Topics
-
September 10, 2005 at 12:41 pm #3065724
FRONTPAGE Understanding FrontPage MSDN Portal W…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Understanding FrontPage
MSDN Portal
While you can code HTML for a web page using Notepad, FrontPage can help to quickly develop a more sophisticated site.“Web sites are more sophisticated than ever before, and they require a sophisticated application that can keep pace with your Web development. FrontPage is a Web site development and management application that can help you produce professional Web sites that are dynamic and interactive.”
Getting Started with FrontPage
“Whether you’re interested in Web development or in extending FrontPage, you’ll find information here that helps you capitalize on the power of technologies like XML, XSLT, ASP, ASP.NET, and Microsoft SharePoint Products and Technologies.”
Here are some suggested blogs:
Kathleen Anderson’s Blog (MVP)
See all
Topics
-
September 10, 2005 at 12:41 pm #3065725
EXCEL Sort Worksheets Order tabs Worksheets can…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Sort Worksheets
Order tabs
Worksheets can be dragged and dropped into any order required. They can be set up in numeric or alpha order, but doing it by hand is a bother.
Chip Pearson has written some macros that will do the job for you:
- Sorting Worksheets In Alphabetical Order
- Sorting In Custom Order
- Grouping Sheets By Color
Here’s the code to sort by tab color:
Sub GroupSheetsByColor()
Dim Ndx As Long
Dim Ndx2 As Long
For Ndx = 1 To Worksheets.Count - 1
For Ndx2 = Ndx To Worksheets.Count
If Worksheets(Ndx2).Tab.ColorIndex = _
Worksheets(Ndx).Tab.ColorIndex Then
Worksheets(Ndx2).Move after:=Worksheets(Ndx)
End If
Next Ndx2
Next Ndx
End SubSorting Worksheets In A Workbook
(The colorindex variable chooses one of the 56 colors in Excel’s basic palette.
Here are all the colors and numbers as compiled by F. David McRitchie:
Excel Colors )Here is another take on sorting from Carla Jolley:
Using VBA to Sort WorkbooksSee all Topics
-
September 10, 2005 at 12:41 pm #3065726
WORD Certificate of Anything Make your own Give…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Certificate of Anything
Make your own
Give your kid an award for not setting the house on fire in the last 24 hours.Make a formal presentation to your dog for scaring away imaginary burglars.
The desktop publishing power of your computer can create official (looking) honors.
Here’s how to create your own template:OfficeArticles.com:
Create a Certificate Template in Microsoft Word
Here’s a collection of free templates:
Southworth.com
Free Award And Certificate Templates
EducationWorld.com:
Award Certificates
BrainyBetty.com
Certificate Templates
(These are PowerPoint templates)Office.microsoft.com:
Certificates
(86 Certificates, labels, etc. Word, PowerPoint, and Publisher)See all
Topics
-
September 10, 2005 at 12:41 pm #3065719
OUTLOOK Calendar on the Web Exchange not require…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Calendar on the Web
Exchange not required
Outlook has made it possible to share your calendar on the Internet as a web page.- Click Calendar.
- On the File menu, click Save as Web Page.
- Under Duration, set the Start date and End date.
- Under Options, set the options you want.
(Show appointment details, use a background graphic) - Under Save as, type the calendar name, and then specify the Web page file name and the path where you want to place the calendar.
- Click Save.
Add an Outlook calendar to a Web page
Here’s a step by step pictorial:
Stanford Linear Accelerator Center:
Publishing an Outlook Calendar to the WebAlso:
Sliptick.com:
Publishing Outlook Calendars on the Internet or an IntranetSee all Topics
-
September 10, 2005 at 12:41 pm #3065720
ACCESS An Access Primer No cost lessons This si…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
An Access Primer
No cost lessons
This site provides quite complete on line manual about the care and feeding of MS Access.What makes this tutorial special are the sample database files that can be used to demonstrate the various features.
“Microsoft Access is a development environment used to create computer databases for the Microsoft Windows family of operating systems. This site provides lessons, examples, and links on how to use and explore MS Access. We also separately provide some guidance on VBA, the programming language that ships with Microsoft Access.”
See all
Topics
-
September 10, 2005 at 12:41 pm #3065721
WORD Start Menu List List programs Here is an …
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Start Menu List
List programsHere is an interesting macro, with instructions on how to install it and a template that can be downloaded.
I recommend using the template to avoid the problems that can occur when pasting code.
A Macro to List All Programs in the Windows Start Menu
by Greg Chapman, MVP“TechTrax is a free, monthly Ezine (online magazine) published the beginning of each
-
September 11, 2005 at 8:40 am #3065649
OUTLOOK Dynamic Distribution Lists Group the con…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Dynamic Distribution Lists
Group the contactsIf you want to send an email to a list, but omit a few of its members, Click on the plus sign next to the distribution name. Click OK to expand the list and remove members who you do not want to receive the email.
Rather than creating and updating a distribution list as a list of names, you could use Categories.
To add or remove names from
-
September 12, 2005 at 8:42 am #3065803
FRONTPAGE Googols of Deskbars The competition gro…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Googols of Deskbars
The competition growsRemember back less than two years ago when deskbars for search engines appeared? These add-ins could search the Internet or your local machine faster than before. Google was one of the first. Now there are competitors.
Here are some reviews and comparisons:
GoebelGroup.com:
Desktop Search Tools Matrix
Pandia.com:
Desktop search tools -
September 12, 2005 at 12:43 pm #3065569
ADDENDUM Bathroom Appliances One man’s toilet is…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Bathroom Appliances
One man’s toilet is . . .Bill Gates mansion bathroom tour
(a story to be read and enjoyed but not believed)
Terry Love:
Consumer toilet reportsGizmodo.com:
Toilets“We’ve all been there. Nature calls and the only answer is a toilet with more levers, switches, and buttons than Wily E. Coyote’s latest invention. What to do? If you’re Bob Cromwell, the answer is
-
September 13, 2005 at 8:42 am #3065290
POWERPOINT Web Page on a Slide All in one place …
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT Web Page on a Slide All in one place You can put a hyperlink on a slide. During the presentation, you can click on the link, invoke the browser and show the web site. Rather than that, how about placing the web page itself on the slide? Not a screen shot, but the actual, fully functional page. When you’re through with the demonstration, one click takes you to the next slide. “No -
September 13, 2005 at 4:43 pm #3058452
POWERPOINT Web Page on a Slide All in one place …
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Web Page on a Slide All in one place
You can put a hyperlink on a slide. During the presentation, you can click on the link, invoke the browser and show the web site.Rather than that, how about placing the web page itself on the slide?
Not a screen shot, but the actual, fully functional page. When you’re through with the demonstration, one click takes you to the next slide.
“No -
September 14, 2005 at 8:42 am #3058205
WINDOWS Start Menu Ready, Set Here’s more infor…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Start Menu
Ready, Set
Here’s more information on the Windows Start menu:
“The list of programs on the Start menu is divided into two parts: the programs displayed above the separator line (also known as the pinned items list) and the programs displayed below the separator line (also known as the most frequently used programs list).
The programs on the pinned items list remain there and are always available for you to click to start them. You can add programs to the pinned items list.”
Most Frequently Used programs (MFU) list is empty
Glencoe Norton online:
Customizing the Start Menu in Windows XPAlso:
Start Menu ListSee all Topics
-
September 15, 2005 at 8:46 am #3059821
MUSIC Fitness to Practice Paracetamoxyfrusebendr…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
MUSIC
Fitness to Practice
Paracetamoxyfrusebendroneomycin
Adam Kay 10.30 outside the UK). Raising money for Macmillan Cancer Relief
See all Topics -
September 16, 2005 at 9:11 am #3056615
EXCEL Startup Woes When kickstart is inappropria…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Startup Woes
When kickstart is inappropriate
It happens to me less often than in the past, but when Excel does not want to open correctly, here are some resources to solve the problem.“There are several reasons why you may experience problems when you start Microsoft Excel. This article discusses how to troubleshoot the cause of the startup problem, and possible remedies to correct the
-
September 17, 2005 at 9:11 am #3059095
WORD Merge Formatting $ lost The data in Access…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Merge Formatting
$ lost
The data in Access or Excel has been formatted. You have leading zeros, percents, currency is formatted and so on.Word 2002+, however loses the formatting when a mail merge is attempted.
Here’s a fix.
Word 2002 has three potential data access methods, the “old fashioned” ODBC or DDE and the newer OLE DB.
ODBC and OLE DB can, quickly, extract data from a source
-
September 18, 2005 at 9:12 am #3058906
ACCESS Text Box Highlights Change background It…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Text Box Highlights
Change background
It can be difficult to tell which text box on a form you’re currently working with.One solution is to highlight the current position, with a different background.
Access 2000+ allows you to do this with conditional formatting, but you can also get a similar result using code. To do so, create a new Module and add the following code:
Function
-
September 19, 2005 at 9:17 am #3059317
OUTLOOK Mail your Word Send your thoughts You c…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK Mail your Word Send your thoughts You can write an email message in Word, but there is no need to copy and paste it into Outlook. Select Mail Recipient. Word will open your default email program and place the message, or document in the composition window or include it as an attachment. Ed Bott writes about this and a way to overcome some attachment limitations: Allow Outlook to send -
September 20, 2005 at 9:12 am #3054290
ADDENDUM Pack Light Traveler’s friend The Unive…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Pack Light
Traveler’s friend
The Universal Packing List
By Mats Henricson
“In January 1988 I left Sweden for warmer climates – Africa. I was there for 5 months. A trip like that is impossible without proper planning. For months I compiled a list of things I might need, as well as things I had to do before I hit the road. When I came back from Africa I realized I could use the list for -
September 21, 2005 at 7:27 am #3058566
POWERPOINT Slide on a Web Page Make it an Intern…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT Slide on a Web Page Make it an Internet show A little bit ago we talked about putting a live web page directly on a slide: Web Page on a Slide. This hint is about converting your PowerPoint show into a web presentation. Here’s a slide show on the web showing how it’s done: EllenFinkelstein.com: Publishing a Presentation to the Web Also: Indezine.com: PowerPoint 2002-2003 Web -
September 22, 2005 at 7:23 am #3057085
WINDOWS Burn CD
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS Burn CD’s The how and howevers It has become less complicated to create your own CDs for data backup or music. “When I first started authoring CDs, the CD recorder itself cost $35,000 (for the cheap model), and blank CDs were a mere $50 apiece. I never would have guessed that someday they’d both cost a fraction of what they did then. In part, this is what has fueled the explosive growth -
September 23, 2005 at 10:44 am #3061342
FRONTPAGE Look at Yourself Information on line …
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE Look at Yourself Information on line Here is a site that will test your connection speed, tell you your latitude and longitude, IP address and more. They provide a one stop location to validate email addresses, locate the host server for a domain, plus trace, ping etc. You can also find out what information your browser is broadcasting to the world. Internetfrog.com See all -
September 23, 2005 at 6:45 pm #3062221
OUTLOOK Mail your Word Send your thoughts You c…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Mail your Word
Send your thoughts
You can write an email message in Word, but there is no need to copy and paste it into Outlook.Select File>Send To>Mail Recipient. Word will open your default email program and place the message, or document in the composition window or include it as an attachment.
Ed Bott writes about this and a way to overcome some attachment limitations:
Allow Outlook to send and receive URLs
In the future there will be no need to select Word as your email editor. It will be the only editor Outlook 12 uses.
Here’s the report from:
Channel 9
Office 12 will, probably, use the more direct appellation “Email”:
For other Office 12 screenshots, see:
Bink.Nu
See all
Topics
-
September 23, 2005 at 6:45 pm #3062222
POWERPOINT Slide on a Web Page Make it an Intern…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Slide on a Web Page
Make it an Internet show
A little bit ago we talked about putting a live web page directly on a slide:
Web Page on a Slide
.
This hint is about converting your PowerPoint show into a web presentation.Here’s a slide show on the web showing how it’s done:
EllenFinkelstein.com:
Publishing a Presentation to the Web
Also:Indezine.com:
PowerPoint 2002-2003 Web Options
RDPSlides.com has this article:
PowerPoint on the Web
Here’s how to use the Publishing Wizard:
Using the Web Publishing Wizard to upload your files to the web
Office.Microsoft.com:
Show slide animations during a Web presentation
See all
Topics
-
September 23, 2005 at 6:45 pm #3062223
WINDOWS Burn CD’s The how and howevers It has b…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Burn CD’s
The how and howevers
It has become less complicated to create your own CDs for data backup or music.
“When I first started authoring CDs, the CD recorder itself cost $35,000 (for the cheap model), and blank CDs were a mere $50 apiece. I never would have guessed that someday they’d both cost a fraction of what they did then. In part, this is what has fueled the explosive growth of the CD burning industry.
But now, Windows XP makes this technology a mainstream activity. Built-in support for CD burning makes the task easier than ever before-as easy as copying to a floppy disk.”
CD Burning Becomes Routine in Windows XP
Also:
Windows XP CD Burning Secrets
By Ed BottBurning CDs in Windows XP
By Alex Nichol AumHa.orgCD-Recordable FAQ
Simple answers to simple questions- CD Encoding
- How Do I…
- Problems
- Hardware
- Software
- Media
- Net Resources and Vendor Lists
Also:
CDBurnerXP Pro
CDBurnerXP Pro is a free CD/DVD burning solution.
With this software you can burn CD-R, CD-RW DVD+R/RW DVD-R/RW discs.See all Topics
-
September 23, 2005 at 6:45 pm #3062224
FRONTPAGE Look at Yourself Information on line …
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Look at Yourself
Information on line
Here is a site that will test your connection speed, tell you your latitude and longitude, IP address and more.They provide a one stop location to validate email addresses, locate the host server for a domain, plus trace, ping etc.
You can also find out what information your browser is broadcasting to the world.
See all
Topics
-
September 24, 2005 at 10:45 am #3062140
EXCEL Time without Limits No Delimiters Excel i…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Time without Limits
No Delimiters
Excel is most happy when you enter dates and times with the correct separators.1/1/2004 is a good date. So is 1-1-2004.
If you just entered 112004 in a cell formatted as a date you’ll get:
Wednesday, August 27, 2206
the 112,004th day since January 1, 1900.
Chip Pearson has come up with VBA code, using the Worksheet_Change event procedure, that will
-
September 25, 2005 at 10:45 am #3062033
WORD Bend Word to Your Will Show who’s in charge…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Bend Word to Your Will
Show who’s in charge
“Bend Word is written around Macintosh Word 2001: but it’s highly recommended for anyone who wants to really unleash the power of Word: this is (huge) article is “Word 101” for people who really want Word to work for them instead of the other way around.
For the most part it’s structured like a dictionary with self-contained articles, so even though it’s almost 200 pages long, it isn’t difficult to find information – just as with a dictionary! It’s intended to be used on-screen rather than to be printed out, because the articles have clickable hyperlinks for instant access to related topics.”
Article contributed by
Clive Huggan
Bend Word to Your Will
(April 2005 edition)
[
updated entry from 1/28/2004
]See all
Topics
-
September 26, 2005 at 10:48 am #3063424
OUTLOOK Match Template to Account Set your ident…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Match Template to Account
Set your identityIf you have multiple email accounts you can use a different template for each account.
After creating the template, assigning it to an account and saving it, you can assign the template to a button.
Click the button and the selected template will appear using the assigned account to send the message.
Slipstick provides screenshots and
-
September 27, 2005 at 6:47 am #3063144
ACCESS Defeat Personalized Menus A fast way in …
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Defeat Personalized Menus
A fast way inPersonalized menus display just your recently used menu items for a few seconds before the entire menu is displayed.
If you like this feature and have left it enabled, you can display a full menu by double-clicking the menu name when you open it.
To turn this off, go to Customize Options and put a check by Always show full menus.
See all
-
September 28, 2005 at 2:48 pm #3061201
ADDENDUM Where on the World Stats on a map Var…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Where on the World
Stats on a mapVarious statistical findings superimposed on a world globe.”This project started some eight years ago.
An attempt to do justice to the term ‘political’ and ‘geo-political’ globe.
Trying to tell the lie (of abstraction and visualization) that tells the truth.By now there are more than 200 different globes.”
3 Hour US Air Force
-
September 29, 2005 at 6:44 am #3060984
POWERPOINT Gettysburg Address Did Lincoln read E…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Gettysburg Address
Did Lincoln read Edward Tufte?
At one time or another many of you have see the PowerPoint version of Lincoln’s 1863 presentation. (They called them speeches back then.)Here’s Peter Norvig’s background rational for its creation and what followed after its release:
“Why I did it“Doesn’t he realize this presentation is a waste of time? Why doesn’t he just tell
-
September 30, 2005 at 10:44 am #3071970
WINDOWS Accessibility for All Overcome the barri…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Accessibility for All
Overcome the barriersMicrosoft has made a point of supporting the use of computers by as many people as possible.
You may not feel that you need this information now, but the time will come when you yourself are struck with even a temporary Carpel Tunnel problem. Or you pod mate in the cubical is having problems seeing the screen.
Here are some links that may
-
October 1, 2005 at 6:46 am #3073830
FRONTPAGE Pictures Toolbar Control your graphics…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Pictures Toolbar
Control your graphicsYou may have used this toolbar in other applications; you may want to get to know it even better.
These tutorials looks at the toolbar which includes several easy-to-use features to tweak, enhance and position graphic images after they are inserted into a FrontPage web page.
OutFront.net:The FrontPage Pictures Toolbar part I
The FrontPage
-
October 2, 2005 at 6:45 am #3073670
EXCEL Pivot Tables and Pivot Chart Links PivotT…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL Pivot Tables and Pivot Chart Links PivotTables allow you to create multidimensional data views by dragging and dropping column headings to move data around. J. Carlton Collins, CPA, president of ASA Research, LLC, is an accounting systems and spreadsheet expert. He will walk you through both the basic and complex issues involved. Microsoft Excel Pivot Tables Jon Peltier, has over 23 -
October 2, 2005 at 2:45 pm #3073597
EXCEL Pivot Tables and Pivot Chart Links PivotT…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Pivot Tables
and Pivot Chart Links
PivotTables allow you to create multidimensional data views by dragging and dropping column headings to move data around.J. Carlton Collins, CPA, president of ASA Research, LLC, is an accounting systems and spreadsheet expert.
He will walk you through both the basic and complex issues involved.
Microsoft Excel Pivot Tables
Jon Peltier, has over 23 -
October 3, 2005 at 6:48 am #3073406
WORD Background Printing Yes, you can! Remember…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WORD Background Printing Yes, you can! Remember back in the old days of Word before 2003? We would demonstrate how a background color or theme could be applied to a document. Then say something like, “But you can only see it on the screen.” That changed with 2003. Go to Options. Go to the Print tab and on the Include with document section, put a check next to “Background colors and images” -
October 3, 2005 at 10:45 pm #3072636
WORD Background Printing Yes, you can! Remember…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
WORD Background Printing Yes, you can! Remember back in the old days of Word before 2003? We would demonstrate how a background color or theme could be applied to a document. Then say something like, “But you can only see it on the screen.” That changed with 2003. Go to Options. Go to the Print tab and on the Include with document section, put a check next to “Background colors and images” -
October 4, 2005 at 6:47 am #3073210
OUTLOOK Fraudulent Email But it said my bank sen…
by dklippert · about 18 years, 6 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK Fraudulent Email But it said my bank sent it! Phishing or counterfeit email is rife. Here is some information from PayPal, a company that is the subject of many scams: “A fraudulent (spoof) email pretends to be from a well-known company, such as PayPal or eBay, in an attempt to get personal information from you. People who send spoof emails hope to use your information – such as credit -
October 5, 2005 at 9:16 am #3057830
ACCESS Alphabetize by One Field or the Other If …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS Alphabetize by One Field or the Other If one is missing, use the other Let’s say you have a database that has the company name and a contacts name. In some cases the CompanyName field is empty. If that happens, you want to continue the alpha sort using the contact’s LastName. To do this, you need to create an extra query field to provide the sort, using the NZ() function to replace the -
October 5, 2005 at 5:14 pm #3057624
WORD Background Printing Yes, you can! Remember…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Background Printing
Yes, you can!
Remember back in the old days of Word before 2003?We would demonstrate how a background color or theme could be applied to a document. Then say something like, “But you can only see it on the screen.”
That changed with 2003.
Go to Options.
Go to the Print tab and on the Include with document section,
put a check next to “Background colors and images” -
October 5, 2005 at 5:14 pm #3057625
OUTLOOK Fraudulent Email But it said my bank sen…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Fraudulent Email
But it said my bank sent it!
Phishing or counterfeit email is rife. Here is some information from PayPal, a company that is the subject of many scams:
“A fraudulent (spoof) email pretends to be from a well-known company, such as PayPal or eBay, in an attempt to get personal information from you. People who send spoof emails hope to use your information – such as credit -
October 5, 2005 at 5:14 pm #3057626
ACCESS Alphabetize by One Field or the Other If …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Alphabetize by One Field or the Other
If one is missing, use the other
Let’s say you have a database that has the company name and a contacts name.In some cases the CompanyName field is empty. If that happens, you want to continue the alpha sort using the contact’s LastName.
To do this, you need to create an extra query field to provide the sort, using the NZ() function to replace the
-
October 6, 2005 at 9:16 am #3066215
ADDENDUM Crossword Puzzles May I have a word wit…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Crossword Puzzles
May I have a word with you?
Even if you’re used to doing crosswords with a pen or a typewriter, you’re sure to find something new at this site.It has, of course, a selection of word sources.
Language dictionaries from Abenaki to Zulu with Mapudungun in between.
“So you like word games, do you? Well, you have come to the right place. We have the richest assortment
-
October 7, 2005 at 9:15 am #3069954
POWERPOINT Safety Shows Don’t be sorry The Univ…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Safety Shows
Don’t be sorry
The University of Vermont at Burlington has an area entitled “Safety Information Resources on the Internet collection.”As part of that collection, they offer 256 PowerPoint presentations on safety.
Topics range from “Basic Electrical Safety” and “Healthy Living: Exercise, Diet, and Stress” to “You Know You’re A Safety Nut When….”
Keep this site in
-
October 8, 2005 at 9:11 am #3070338
WINDOWS Who Needs a Mouse? Finger tricks Rathe…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Who Needs a Mouse?
Finger tricksRather not use a mouse?
MouseKeys is designed for people who have difficulty using a mouse. MouseKeys allows you to use the numeric keypad to control the mouse pointer.
Click Start, click Control Panel, and then click Accessibility Options.
On the Mouse tab, under MouseKeys, select the Use MouseKeys check box.
To turn off MouseKeys, clear the Use
-
October 9, 2005 at 9:18 am #3070202
FRONTPAGE Disable the Image Toolbar Drop the bar …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Disable the Image Toolbar
Drop the bar“When the user visits a web site and mouses over an image that meets particular requirements, the My Pictures hovering toolbar will appear after one half second, and will disappear immediately after the user moves the cursor off the image. The hovering toolbar has three to four buttons depending upon the browser client and user operating
-
October 10, 2005 at 9:19 am #3060353
EXCEL Format Numbers It’s your choice Here is a…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Format Numbers
It’s your choiceHere is an almost forgotten sample spreadsheet. It was constructed, for Microsoft, back in 1997 by Lori B. Turner, and is still relevant.
The sheets are protected. In order to see the cell formatting, you need to go to Protection to Unprotect Sheet . . . There is no password required
Formatting sample Workbook
Also: OzGrid:
Custom FormatsIf you need to
-
October 11, 2005 at 7:43 am #3069614
WINDOWS Log on Screen Capture Snapped in the act…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS Log on Screen Capture Snapped in the act When describing how to Sign on to Windows, it’s nice to be able to show what the screen looks like. Print Screen won’t work, because the cache has not been set up until after the process. Here’s how it’s done: Press Ctrl+Alt+Del to open the Windows Task Manager Click on the Processes tab and highlight Explorer.exe Click “End Task” in the -
October 12, 2005 at 12:02 pm #3060133
WORD Clip Art Gallery Sprinkle carefully Judic…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Clip Art Gallery
Sprinkle carefully
Judicious use of Clip art can spice up a document. Here’s an article about how to customize existing pictures including:
Display clip-related toolbars
Customizing your clip art
Cropping
Sizing
Adding text wrapping
Blurring
Rotating and flipping
Adding a drop shadow
Edit clip art in Word Also:Clip art gallery750+ Halloween clips
Clip Art demo
5 new -
October 13, 2005 at 8:01 am #3070697
OUTLOOK Shipping Status Track UPS and FedEx Wit…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK Shipping Status Track UPS and FedEx With eBay and Amazon, packages are flying across the country 24 hours a day. This free Outlook add-in combines with Outlook’s calendar to follow the path of an order. “Parcel Tracker is an add-in for Microsoft Outlook that automatically synchronizes an appointment item with a shipping service enabling you to track your package delivery / status -
October 13, 2005 at 11:57 am #3068852
WINDOWS Log on Screen Capture Snapped in the act…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Log on Screen Capture
Snapped in the act
When describing how to Sign on to Windows, it’s nice to be able to show what the screen looks like.
Print Screen won’t work, because the cache has not been set up until after the process.
Here’s how it’s done:
- Press Ctrl+Alt+Del to open the Windows Task Manager
- Click on the Processes tab and highlight Explorer.exe
- Click “End Task” in the lower right corner
- A warning will pop up, click Yes
If everything worked, your taskbar and desktop should have disappeared.
Don’t worry, it’s temporary.
- In the Task Manager, go to the File menu and select New Task.
- In the input box, type “logonui” and click OK.
The logon screen should now appear behind the Task Manager. - At this point, go ahead and take your screenshots. You can open Paint by typing “mspaint” into the New Task box.
- Once you have finished taking and saving the screenshots, select “logonui.exe” in the process list in the Task Manager and click End Task.
- This will close the logon screen.
- Finally, go to File and New Task. Type “Explorer” into the text box and click OK.
Your taskbar and desktop should now re-appear.
Computing.net:
Screenshot of Windows XP login
(By Ender )This works with Windows XP and Windows server 2003. Earlier versions did not have Logonui.exe.
I’m still looking for a way to get the classic Log on screen.
See all Topics
-
October 13, 2005 at 11:57 am #3068850
WORD Clip Art Gallery Sprinkle carefully Judic…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Clip Art Gallery
Sprinkle carefully
Judicious use of Clip art can spice up a document. Here’s an article about how to customize existing pictures including:
- Display clip-related toolbars
- Customizing your clip art
- Cropping
- Sizing
- Adding text wrapping
- Blurring
- Rotating and flipping
- Adding a drop shadow
Also:
5 new things about the Clip Art and Media site
Mary Sauer’s Design Gallery Help
Microsoft Clip Art & Media HelpSee all Topics
-
October 13, 2005 at 11:57 am #3068851
OUTLOOK Shipping Status Track UPS and FedEx Wit…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Shipping Status
Track UPS and FedEx
With eBay and Amazon, packages are flying across the country 24 hours a day, locating a shipment can be important. This free Outlook add-in combines with Outlook’s calendar to follow the path of an order.“Parcel Tracker is an add-in for Microsoft Outlook that automatically synchronizes an appointment item with a shipping service enabling you to
-
October 14, 2005 at 7:56 am #3071834
ADDENDUM Il Circo Dei Rocchetti Rotolanti The Ro…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Il Circo Dei Rocchetti Rotolanti
The Rolling Reels CircusGiuseppe (Pino) Civitarese is an oceanographer from Trieste.
He has a small but fascinating collection of paper automata.
“Automata, from the Greek automatos, “acting of one?s own will, self-moving” is more often used to describe non-electronic moving machines, however, especially those that have been made to resemble human
-
October 15, 2005 at 9:53 am #3053618
POWERPOINT It
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
It’s The Story, Stupid
Start at the end
Here’s a lively paper on the ins and outs of giving a presentation and communicating ideas.“In the newspaper business they teach you to put the least important stuff at the end, so if your story was cut for length the reader wouldn’t miss much. But in a presentation, it helps to start with the end, because that’s when the results should start coming in.
There are two ways to start from the end.
The first is asking yourself what results you want from the presentation. Is it sales? Understanding? Recruits? Strokes? Whatever you’re looking for, that’s where you need to start, because without a clear outcome in mind, there’s no way your presentation will come out clear.
The second is to state your conclusion. Larry Gottlieb calls this the ‘conclusion first’ approach. First impressions last longest. If you don’t say the one thing you need to say right up front, it may never get heard.
Starting with your conclusion also tells the audience you won’t waste their time with preliminaries.”
It’s The Story, Stupid
By Doc SearlsAlso see:
Beyond Bullet Points
By Cliff Atkinson[ updated entry from 1/16/2004 ]
See all Topics
-
October 15, 2005 at 5:53 pm #3053565
POWERPOINT It’s The Story, Stupid Start at the e…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
It’s The Story, Stupid
Start at the end
Here’s a lively paper on the ins and outs of giving a presentation and communicating ideas.“In the newspaper business they teach you to put the least important stuff at the end, so if your story was cut for length the reader wouldn’t miss much. But in a presentation, it helps to start with the end, because that’s when the results should start coming in.
There are two ways to start from the end.
The first is asking yourself what results you want from the presentation. Is it sales? Understanding? Recruits? Strokes? Whatever you’re looking for, that’s where you need to start, because without a clear outcome in mind, there’s no way your presentation will come out clear.
The second is to state your conclusion. Larry Gottlieb calls this the ‘conclusion first’ approach. First impressions last longest. If you don’t say the one thing you need to say right up front, it may never get heard.
Starting with your conclusion also tells the audience you won’t waste their time with preliminaries.”
It’s The Story, Stupid
By Doc SearlsAlso see:
Beyond Bullet Points
By Cliff Atkinson[
updated entry from 1/16/2004
]See all
Topics
-
October 18, 2005 at 1:23 pm #3071155
POWERPOINT It’s The Story, Stupid Start at the e…
by dc guy · about 18 years, 5 months ago
In reply to POWERPOINT It’s The Story, Stupid Start at the e…
The old general rule for nonfiction writing is still a good one:
1. Tell them what you’re going to tell them.
2. Tell them.
3. Tell them what you’ve told them.
-
-
October 16, 2005 at 9:54 am #3053473
ACCESS Source of Tables Identify a linked Access…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS Source of Tables Identify a linked Access table’s source When a database contains linked tables, you may need to find the location of the source file. One way is to: Open the table in Design view Clicking Yes when Access informs you that some properties can not be modified. Right-click on the window’s title bar Select Properties from the shortcut menu. The location will appear in -
October 16, 2005 at 1:50 pm #3053456
ACCESS Source of Tables Identify a linked Access…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Source of Tables
Identify a linked Access table’s sourceWhen a database contains linked tables, you may need to find the location of the source file.
One way is to:
Open the table in Design viewClicking Yes when Access informs you that some properties can not be modified.
Right-click on the window’s title bar
Select Properties from the shortcut menu.
The location will appear in
-
October 17, 2005 at 9:56 am #3058065
FRONTPAGE Privacy and the Internet What happens …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Privacy and the Internet
What happens on your computer, stays . . .
Here are some protection suggestions:
“Links to numerous pages on the Web where home users can find software and information relevant to Windows PC privacy and security.It also contains a rudimentary “checklist” of basic steps that home PC users can take to enhance their privacy and security while using the
-
October 18, 2005 at 9:56 am #3072286
EXCEL Mac vs. PC Spreadsheet vagaries “Microsoft…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Mac vs. PC
Spreadsheet vagaries“Microsoft Excel 2004 for Mac and Microsoft Office Excel 2003 are similar in many ways. For example, the programs share a common file format and share most of the same features. However, there are some important differences that you should consider when you work with both Excel 2004 for Mac and Excel 2003.”
Description of some of the differences between-
October 18, 2005 at 1:21 pm #3071157
EXCEL Mac vs. PC Spreadsheet vagaries
by dc guy · about 18 years, 5 months ago
In reply to EXCEL Mac vs. PC Spreadsheet vagaries “Microsoft…
I haven’t figured out how to display a formula bar on the Mac version. The only way I can see the entire contents of an overfilled cell or the original formula is to double click on it and let it overlay its neighbors.
-
-
October 19, 2005 at 6:00 am #3070988
WORD Forms in Word With and without code Data e…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Forms in Word
With and without code
Data entry forms can be designed and presented using VBA code. Another simpler way to do it is to construct a form directly in the Word document.
“Have you ever been asked to fill out a form in a word processor, only to discover that when you attempted to enter information, the lines on the form moved all over the page? Not to mention that the form was -
October 20, 2005 at 6:57 am #3044689
OUTLOOK Icons Itsy Bitsy Indicators What those …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Icons ? Itsy Bitsy Indicators
What those little graphics mean
There’s not much room in an Outlook icon to communicate information.
Robert Sparnaaij, MVP-Outlook, has put together a legend of these tiny pictures with their meanings.
Such as:
What Do The Icons Mean?For more information see his web site:
How to OutlookSee all Topics
-
October 20, 2005 at 11:16 am #3044493
OUTLOOK Icons Itsy Bitsy Indicators What those …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Icons — Itsy Bitsy Indicators
What those little graphics mean
There’s not much room in an Outlook icon to communicate information.
Robert Sparnaaij, MVP-Outlook, has put together a legend of these tiny pictures with their meanings.
Such as:
What Do The Icons Mean?For more information see his web site:
How to OutlookSee all Topics
-
October 21, 2005 at 6:44 am #3046504
ACCESS Drag Data Simple exchange To transfer da…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Drag Data
Simple exchange
To transfer data from an Access query or table in another Office program, such as Word, there’s no need to manually export the data.
- Open the target Office document
- Arrange both applications on the screen
(Right-click an empty part of the Task bar and choose Tile Windows Vertically) - Switch to Access and select the fields or records that you want copied
- When you’ve finished selecting the data, move the mouse pointer near the border of the selection until it turns into an arrow
- Finally, drag and drop the data to your target document
You can also select a whole table, go to Edit>Copy. Switch to Word or Excel and Paste.
It works in the other direction too. Select some Excel data. Switch to Access.
While viewing the Tables Objects, Paste the Excel data. It will form a new table.
See all Topics
-
October 22, 2005 at 10:39 am #3045208
ADDENDUM Best of Clementine Not lost and gone W…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Best of Clementine
Not lost and gone
Why write new words and lyrics? They’re interchangeable.” You’ve heard it sung around the campfires! You’ve lifted your voice to its haunting melody countless times! Now K-Smel records introduces an all-new collection… The Best Of Clementine! ”
The words to Clementine can be sung easily to the tune of certain songs
By extension, the words to -
October 23, 2005 at 6:42 am #3045111
POWERPOINT Photos and PowerPoint Album creations…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Photos and PowerPoint
Album creations
PowerPoint can be used to produce a photo array. Put the show on DVD’s or on the web.
Here is a list of 100 tutorials:
PowerPoint 2003 and Photo Album links
Also:
“Create slideshows using your digital photos. With a single click, you can touch-up, crop, or rotate pictures. Add stunning special effects, soundtracks, and your own voice narration to your photo stories. Then, personalize them with titles and captions. Small file sizes make it easy to send your photo stories in an e-mail. Watch them on your TV, a computer, or a Windows Mobile-based portable device.”
For earlier versions:
This add-in program makes it easy and fast to get pictures from your hard disk drive, scanner, or digital camera into a Microsoft PowerPoint presentation.
Creating Photo Albums in PowerPoint 2000
Also:
[Edited entry from 1/24/2005]See all Topics
-
October 23, 2005 at 2:40 pm #3046035
POWERPOINT Photos and PowerPoint Album creations…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Photos and PowerPoint
Album creations
PowerPoint can be used to produce a photo array. Put the show on DVD’s or on the web.
Here is a list of 100 tutorials:
PowerPoint 2003 and Photo Album links
Also:
“Create slideshows using your digital photos. With a single click, you can touch-up, crop, or rotate pictures. Add stunning special effects, soundtracks, and your own voice narration to your photo stories. Then, personalize them with titles and captions. Small file sizes make it easy to send your photo stories in an e-mail. Watch them on your TV, a computer, or a Windows Mobile-based portable device.”
For earlier versions:
This add-in program makes it easy and fast to get pictures from your hard disk drive, scanner, or digital camera into a Microsoft PowerPoint presentation.
Creating Photo Albums in PowerPoint 2000
Also:
[Edited entry from 1/24/2005]See all Topics
-
October 24, 2005 at 10:43 am #3043721
WINDOWS Welcome or Not Choose not to If you’re …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Welcome or Not
Choose not toIf you’re a sole user in a home environment, why slow yourself down with a logon screen?
To turn the Welcome screen on or off
You must have a computer administrator account on a computer that is a member of a workgroup or is a stand-alone computer to turn on or turn off the Use the Welcome screen feature. Logging on at the Welcome screen is not available
-
October 25, 2005 at 6:42 am #3046376
FRONTPAGE Photos on a Web Page For all the world…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Photos on a Web Page
For all the world to see
A photo gallery is a Web page that contains a collection of photos arranged in a specific layout. Microsoft FrontPage provides four different layouts that you can use to arrange your graphics.
PowerPoint:
- Open your Microsoft Office FrontPage 2003 Web site.
- On the File menu, click Import.
- In the Import dialog box, click Add File.
- In the Add File to Import List dialog box, browse to the Microsoft Office PowerPoint 2003 presentation that you want to import, select it, and then click Open.
- Click OK.
“You can use the Web to give others access to your presentation by publishing it to a Web server or another computer that is accessible to those you want to view the presentation with a Web browser. When you publish a presentation, a copy of it is created in a file location you choose. You can publish from a presentation that is in .ppt format or that is saved as a Web page or Single File Web page.”
See all Topics
-
October 26, 2005 at 6:40 am #3045664
EXCEL Excel 12 New Limits Here are a few of the…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Excel 12
New LimitsHere are a few of the major changes in Excel 12 (Vista?).
The total number of available columns in ExcelOld Limit: 256 (2^8)
New Limit: 16k (2^14)The total number of available rows in Excel
Old Limit: 64k (2^16)
New Limit: 1M (2^20)Number of unique colors allowed a single workbook
Old Limit: 56 (indexed color)
New Limit: 4.3 billion (32-bit color)Number of
-
October 27, 2005 at 10:06 am #3045064
WORD Split View Top and bottom If you need to l…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Split View
Top and bottom
If you need to look at more than one part of a document at once, consider splitting the window.To split the current window, just go to Window>Split from the main menu.
Another way is to use the splitter control between the file tab channel and the scroll bar for the doc.
To create new windows for the same document, just go to Window>New Window and create as many views on the same document as you would like.
WebJunction.org:
Word Split Window
(Publisher: The Bill and Melinda Gates Foundation)Also:
Dawn Ontario, Disabled Women’s Network:
Split Screen Feature – Microsoft Word
See all
Topics
-
October 28, 2005 at 8:28 am #3115715
OUTLOOK Spam A How to Guide Why let the sleaze …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Spam — A How to Guide
Why let the sleaze balls have all the fun?
We’ve traded garbage cans full of unsolicited mail for full blocked or deleted bins.
Here is a site that has information on stopping the bad guys, including information from their perspective.
- Spam Archives
“A number of far-sighted people have been saving all their spam and have put it online. This is a valuable resource for anyone writing Bayesian filters.”
- How to Spam
“The links on this page are to companies that provide the infrastructure of spam. It’s fairly disgusting reading, but a quick scan will give you some ideas about filtering.”
- Spammers’ Stories
“These articles about spammers are very helpful in understanding how to stop spam. For example, complaining to the ISPs that spammers use does seem to inconvenience them.
And best of all, so does filtering. In one article below, a spammer complains that filters have increased his costs 1,000-fold. That’s exactly what we want to hear. New laws and policies may stop spam. Making it unprofitable certainly will.”
- Better Bayesian Filtering
- Filters that Fight Back
- Will Filters Kill Spam?
- Filters vs. Blacklists
- Filtering Research
- Spam Resources
- Spam Links
PaulGraham.com:
Anti Spam
(Paul Graham is an essayist, programmer, and programming language designer)See all Topics
- Spam Archives
-
October 29, 2005 at 8:38 am #3115311
ACCESS Barcode Fonts Print your own There are a…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Barcode Fonts
Print your own
There are a variety of barcodes. POSTNET is used for mailings.
Word includes a POSTNET field:
{ BARCODE \u “LiteralText” or Bookmark \b [Switches ] }
- “LiteralText” or Bookmark
- Delivery address and ZIP Code. When followed by the \b switch, a bookmark can replace LiteralText.
For example, the bookmark “ENV_ZIPCODE1” represents the address in the active document; it’s inserted by the Envelopes and Labels command. - \b
- When preceded by a bookmark, uses the ZIP Code information from the address defined by the bookmark.
- \f “letter”
- Inserts a Facing Identification Mark (FIM), specified by letter: “A” inserts a courtesy reply mark; “C” inserts a business reply mark. “A” is inserted if you select the FIM-A Courtesy Reply Mail check box in the Envelope Options dialog box. To print a business reply mark, display field codes, and change the letter to “C.”
- \u
- Identifies the bar code as a U.S. postal address.
POSTNET delivery point bar codes consist of 62 bars broken down as follows:
- 45 bars (9 sets of 5 bars) for the Zip+4 Code.
- 10 bars (2 sets of 5 bars) for the delivery point code. The delivery point code is typically the last two digits of the street address or box number.
For high rise buildings, the delivery point code is calculated according to a more complex set of rules. - 5 bars (1 set of 5 bars) for the correction character. The correction character is calculated by adding all the numbers in the Zip+4 Code and then subtracting that number from the next whole integer of 10.
For example, if the Zip+4 Code numbers total 23, the next whole integer of 10 would be 30, and the correction character would be 7. - 2 bars (2 sets of 1 bar) for the long bars that frame the beginning and end of the bar code.
For other applications, you will have to either buy a new font, or perform a mail merge with Word.
OfficeBarcode.com
Providing barcode tutorials, plug-ins, FAQs, integration and printing solutions for Microsoft Access, Excel, Word, FrontPage and other Office applications.List of sites that sell or give away barcode fonts
BarCode 1 Font Page
(Look for POSTNET)Barcodes for Access or other applications such as Word.
(Barcode clock)
[Edited entry from 1/22/2004]
See all Topics
-
October 30, 2005 at 7:21 am #3115120
ADDENDUM Test Your Typing Practice, Practice “Wi…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Test Your Typing
Practice, Practice
“With the TypingMaster Online Test you can assess your personal typing skills in minutes for free – within your web browser.
Based on the short text typing sample, this Java™ applet will estimate your typing skills including typing speed, accuracy and net speed. You can also receive test results directly to your email address.”
MrKent.com
Typing and Ten-key Tests
Also:
CalculatorCat.comTyping test
Hints and other links.[Edited entry from 1/15/2004]
See all Topics
-
October 31, 2005 at 10:43 am #3114388
POWERPOINT One Slide Only Get to the point Too …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
One Slide Only
Get to the point
Too many PowerPoint shows consist of a massive deck of slides. The audience leaves either overwhelmed or wheeled out unconscious from the overload.Elliot Massie is the head of the MASIE Center is an international e-lab and ThinkTank located in Saratoga Springs, NY.
He is hosting a seminar called
Learning 2005
One feature of the sessions is a presenter’s limit of only 1 page.
Think about this limitation the next time you are asked to lead a meeting.
“Every session at Learning 2005 will be limited to ONE PAGE (a slide, a poster, a mind-map, a single question or even just one word!)
Each facilitator of a case study, discussion, conversation or Radar Screen session will be asked to create a GREAT “1 Pager“. It might be a single question such as,
“What is the impact of increased Compliance on Quality and Budget for Training?”
Or, it might be a mindmap of several concepts. Or, a graphic. Or, a simple list of Do’s or Don’ts. But, it will just be a “1 Pager”!
Most of our rooms will not be darkened to feature the LCD Projector. Instead, these will be posted on LearningWiki, the open wiki/blog software for the event. A facilitator can link to lots of other resources from their on-line 1 Pager. (And you can add your own ideas, questions or resources.) Many of our session leaders will provide a complete set of text and audio materials (PodCasts) for your optional review prior to the session.”
See all
Topics
-
November 1, 2005 at 6:40 am #3114955
WINDOWS Do You See What I See? Free color contro…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Do You See What I See?
Free color control
Continuing with its program to reward and verify legal Windows installations, Microsoft is offering another free gadget for the good guys. ICC profiles can be used to match the colors on your monitor to the colors used by your printer.
Microsoft Color Control Panel Applet
The Microsoft Color Control Panel Applet adds a new ‘Color’ item to the Windows control panel, providing a single place to view and edit color management settings in Windows XP. Using it, you can install and uninstall color profiles, change color profile associations for displays, printers and scanners, view detailed properties for color profiles (including a 3D rendering of the color space gamut), and rename color profiles, keeping the filenames and “internal” names consistent.
International Color Consortium
The ICC was established in 1993 by eight industry vendors for the purpose of creating, promoting and encouraging the standardization and evolution of an open, vendor-neutral, cross-platform color management system architecture and components.
The intent of the International Color Consortium (R) profile format is to provide a cross-platform device profile format. Device profiles can be used to translate color data created on one device into another device’s native color space. It allows users to be sure that their image will retain its color fidelity when moved between systems and applications.
Adobe Gamma
Adobe Gamma is installed when Photoshop is loaded.
Color Management
Color management and color science: Introduction
by Norman Koren
Printer Profiles
Printer Profiles for sale by Digital Domain Inc.
Print with Color Management
Ian LyonsSee all
Topics
-
November 2, 2005 at 10:42 am #3116400
FRONTPAGE Send the Viewer on their Way Move on …
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Send the Viewer on their Way
Move on
If you have an old site that people still address, or a web page that has been moved, see this code and the explanations.
<html><head>
<meta http-equiv="REFRESH" content="3; URL=http://WWW.MiniByteTech.com">
<head><body bgcolor="#FFFFFF" text="#000000">
The new location for this web site is WWW.MiniByteTech.com! You will automatically be redirected in 3 seconds. If your browser doesn't automatically load, click <a href="http://WWW.MiniByteTech.com">HERE</a>.
</body>
</htmlThe operative line is:
<meta http-equiv="REFRESH" content="3; URL=http://WWW.MiniByteTech.com">The value of content is in seconds.
Macalester College St. Paul, MN
How to redirect a web page requestPCMag.com:
Routing Your Web Site Visitors
Help2Go.com:
Redirecting a Web page
ISiteBuild.com:
How to Redirect a Web Page Using a 301 RedirectWebConfs.com:
Redirect CheckerThis tools help you determine if the redirect you have created is Search Engine Friendly.
See all Topics
-
November 3, 2005 at 9:05 am #3117061
EXCEL Graph Data and Shapes Statistical collecti…
by dklippert · about 18 years, 5 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Graph Data and Shapes
Statistical collection
Betty C Jung has put together a serious collection of tutorials, links, and data sources.Here are some of the topics:
Charting Data
Data Presentation
Cumulative Frequencies
Fishbone Diagram
Flowcharts
Frequency Distributions
Gantt; PERT Charts
Graphing With Excel
Analyzing and Plotting Data with Excel
Organizational Charts/Mapping
Social -
November 8, 2005 at 1:22 pm #3135735
WORD Almost All You Need to Know Collection of W…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Almost All You Need to Know
Collection of Word explanations
Shauna Kelly is a Microsoft Word MVP.
She has compiled a gathering of important Word how to’s and whys.
- For new users of Microsoft Word
- Basic concepts – Introduction
- Styles in Microsoft Word
- Tips for understanding styles
- Formatting
- How the Styles and Formatting pane works
- Numbering, Bullets, Headings, Outlines
- How to control bullets
- Templates
- What is the relationship between a Word document and its template?
- Layout
- How to keep a figure on the same page as its caption
- Sharing Microsoft Word documents
- What happens when I send my document to someone else?
Making the most of Word in your business:
Microsoft Word FAQSee all Topics
-
November 8, 2005 at 1:22 pm #3135733
BOOKS An Obsession with Butterflies Quote “Ar…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
BOOKS
An Obsession with Butterflies
Quote
“Architecture is a plant’s first defense. Once a caterpillar begins to eat, compounds in its saliva can be recognized by the leaf as a form of attack. Whang, whang, whang. The entire plant goes on alert. A hormonal burst starts a second defense system, a counter attack that may include rushing newly produced toxins to the damaged leaf, as well as compounds that slow a caterpillar’s ability to digest the plant as food.”
About the Author
Sharman Apt Russell teaches writing at Western New Mexico University. She is also the author of Anatomy of a Rose, Kill the Cowboy and Songs of the Fluteplayer.
She has a unique voice. Inherently complex topics are made enjoyable.Book Description
From the beastly horned caterpillar, whose blood helps it count time, to the peacock butterfly, with wings that hiss like a snake, Russell traces the butterflies through their life cycles, exploring the creatures’ own obsessions with eating, mating, and migrating. In this way, she reveals the logic behind our endless fascination with butterflies as well as the driving passion of such legendary collectors as the tragic Eleanor Glanville, whose children declared her mad because of her compulsive butterfly collecting, and the brilliant Henry Walter Bates, whose collections from the Amazon in 1858 helped develop his theory of mimicry in nature. Russell also takes us inside some of the world’s most prestigious natural history museums, where scientists painstakingly catalogue and categorize new species of Lepidoptera, hoping to shed light on insect genetics and evolution.
By Sharman Apt Russell
ISBN 0-7382-0699-7
Perseus Publishing 2003Also see:
The North American Butterfly Association (NABA)
and,
AmazingButterflies.com:
A Talk with Sharman Apt Russell[Edited entry from 1/29/2004]
See all Topics
-
November 8, 2005 at 1:22 pm #3135734
WINDOWS Don’t Display Logon, Logoff, Startup and…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Don’t Display
Logon, Logoff, Startup and Shutdown Status Messages
To turn these off:
Start Regedit
Go toHKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system
If it is not already there, create a DWORD value named DisableStatusMessagesGive it a value of 1
To turn on:
Locate and then click the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System
On the Edit menu, point to New, and then click DWORD Value.Type verbosestatus, and then press ENTER.
Double-click the new key that you created, type 1 in the Value data box, and then click OK.
Quit Registry Editor.
NOTE: Windows does not display status messages if the following key is present and the value is set to 1:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System\DisableStatusMessages
[Edited entry from 1/17/2004]See all Topics
-
November 8, 2005 at 1:22 pm #3135732
ADDENDUM John Titor a “C204 time displacement” m…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
John Titor — 2036
The future came back
Why speculate about the future, when we’ve already been visited by a representative?
“A tale that disturbed me, concerned me, made me wonder if our world as we know it has less than 15 years left.
It is the tale of John Titor, a self-proclaimed time traveler from the year 2036.
Okay, it sounds crazy. It’s not crazy, though . . .it’s simply a hoax. It’s a compelling hoax, so I decided to write my take on it. After some initial ‘what if’ excitement about it, the reality set in that this wasn’t what it appeared to be. In this piece, I hope to prove relatively clearly that his claims are false both in theory and in fact. He seemed to know enough about physics to pass amongst laymen, but unfortunately he skipped philosophy and economics while he was reading all those physics books.
Since this story just won’t seem to die and there is evidence that the same perpetrator is now claiming to be an alien on various boards across the web, I felt it was worth sitting down and analyzing.”
Tackling John Titor, Time Traveler
Wikipedia:
John Titor“John Titor was the name of a purported time traveler from the year 2036. He posted on several time travel-related Internet bulletin boards during 2000/2001, making many vague and seemingly falsifiable predictions about events in the near future and giving an explicit, detailed account of his supposed native time period. Whether or not John Titor was a hoax is a topic of controversy on web-based paranormal discussion boards.”
“Someone using the assumed name of John Titor and claiming to be a soldier on a mission from 2036 presented a considerable amount of information on the Web beginning around November 2000 about his mission and time travel machine, his perspective on our society, how our society is going wrong, and how society as we know it will end in a very short but massive global nuclear war in 2015. He’s gone now, back to 2036 he said he was going in his last posting on March 24, 2001, and the threads he left across the Web in his five months with us have been slowly evaporating since then.”
John Titor Times
A couple of future reports:- The reason the job of President was split into an office of 5 has 4 main reasons. With 5 (presidents), foreign policy is more consistent, power shifting between parties has less of an impact on the overall government, individual strengths between presidents add to the strength of the overall office, and one president is elected for each major area in the United States.
- What is the extent of Presidential power in 2036?
- The office of President is far more diluted and decentralized than it is here. The powers of the national government are more defined and reside more at the county and state level.
AboveTopSecret.com:
“Although many find it easy to dismiss all this as either science fiction or an elaborate extended hoax, there are those who still read his information and agree that there is something very troubling about John Titor and what he had to say.”
Answers.com:
John Titor” He claimed his time machine — a “C204 time displacement” machine-was created by General Electric. Supposedly, he transported it in a standard motor vehicle (a black, model-year 1966 Chevrolet Corvette Convertible shown in the photographs he provided), and the car also served as his vessel whilst traveling through time (it remained stationary throughout with the engine off). He claimed that the public is fully aware of time travel in his time period, although the extreme skeptics of his day do not believe it exists.”
See all Topics
-
November 8, 2005 at 1:22 pm #3135731
OUTLOOK PayPal PhishingAs part of a series on I…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
PayPal ? Phishing
As part of a series on Identity Protection Resources, PayPal has a section on Spoofing or Phishing.
“Many spoof emails look very real. While there are some telltale signs, it can often be difficult to identify fake emails. Whenever you get an email about your PayPal account, the safest and easiest course of action is to open your browser and log in to your PayPal account directly without clicking any links in the email.
Warning signs that an email about your PayPal account are fake include a generic greeting, a false sense of urgency, and links that don’t include “https://www.paypal.com” immediately before the first “/”.
See all Topics
-
November 9, 2005 at 6:40 am #3120333
WINDOWS Calculator PlusAdd, subtract, convertA…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Calculator Plus
Add, subtract, convert
Another free prize offered by Microsoft to reward users of legitimate Windows XP, is a neat calculator.
Besides all of the features of the built in calculator, both basic and scientific, this tool converts measurements and currency.
Microsoft Calculator Plus download.
See all Topics
-
November 10, 2005 at 6:42 am #3118352
FRONTPAGE Code your Web Site An overview One of…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Code your Web Site
An overview
One of the reasons the Web has expanded so rapidly is the ease of writing simple HTML.
When you want to add more bells and sirens, FrontPage has some built in tools to ease the process.
“In the early 1990s, Web sites were simple. Basic HTML allowed programmers to design sites that relayed basic information to Internet users but that could do little else.
Today, Web sites are often sophisticated and complex. Rather than a static place to present information, Web sites frequently act like business partners, performing complex tasks that can help run and even improve a business or personal endeavor.
To take full advantage of a Web site and truly make it work for you, you need professional coding tools. Microsoft Office FrontPage 2003 provides several new, powerful coding tools that will help you to create dynamic, interactive sites that can do more for you.FrontPage 2003 coding tools can help you to generate clean, efficient code, while also giving you more control over the code. These tools can also help you to increase and apply your knowledge of coding languages.
This article will introduce you to the FrontPage 2003 coding tools and show you how you can use them to code faster and more accurately.”
Pump up your Web site
with coding toolsSee all Topics
-
November 10, 2005 at 9:54 pm #3117628
OUTLOOK PayPal Phishing As part of a series on I…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
PayPal — Phishing
As part of a series on Identity Protection Resources, PayPal has a section on Spoofing or Phishing.
“Many spoof emails look very real. While there are some telltale signs, it can often be difficult to identify fake emails. Whenever you get an email about your PayPal account, the safest and easiest course of action is to open your browser and log in to your PayPal account directly without clicking any links in the email.
Warning signs that an email about your PayPal account are fake include a generic greeting, a false sense of urgency, and links that don’t include “https://www.paypal.com” immediately before the first “/”.
See all Topics
-
November 10, 2005 at 9:54 pm #3117629
WINDOWS Calculator Plus Add, subtract, convert A…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Calculator Plus
Add, subtract, convert
Another free prize offered by Microsoft to reward users of legitimate Windows XP, is a neat calculator.
Besides all of the features of the built in calculator, both basic and scientific, this tool converts measurements and currency.
Microsoft Calculator Plus
download.See all
Topics
-
November 10, 2005 at 9:54 pm #3117630
FRONTPAGE Code your Web Site An overview One of…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Code your Web Site
An overview
One of the reasons the Web has expanded so rapidly is the ease of writing simple HTML.When you want to add more bells and sirens, FrontPage has some built in tools to ease the process.
“In the early 1990s, Web sites were simple. Basic HTML allowed programmers to design sites that relayed basic information to Internet users but that could do little else.
Today, Web sites are often sophisticated and complex. Rather than a static place to present information, Web sites frequently act like business partners, performing complex tasks that can help run and even improve a business or personal endeavor.
To take full advantage of a Web site and truly make it work for you, you need professional coding tools. Microsoft Office FrontPage 2003 provides several new, powerful coding tools that will help you to create dynamic, interactive sites that can do more for you.FrontPage 2003 coding tools can help you to generate clean, efficient code, while also giving you more control over the code. These tools can also help you to increase and apply your knowledge of coding languages.
This article will introduce you to the FrontPage 2003 coding tools and show you how you can use them to code faster and more accurately.”
Pump up your Web site
with coding toolsSee all
Topics
-
November 11, 2005 at 5:57 am #3117506
EXCEL Spreadsheet design Make it work and look g…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Spreadsheet design
Make it work and look good
Timothy Miller uses the nom de screen of “Jethro” (Moses’ Father-in-Law).
His SpyJournal.biz site/blog gives some tips on how to present an Excel solution
- Design and layout
- One of the easiest ways to set up spreadsheets that calculate or generate results that need to be reported is to separate the function from the form. Just like a shiny exterior on a car hides the internal engine and wiring. I always create my reports and front end menus to look good and generate results and calculations in more functional sheets.
- Hiding unnecessary sections
- If you must have calculations and working sections visible, then hide the unnecessary bits. Hiding a row or column is only one way of doing this. Using the group function you can rollup whole rows of information, e.g. components that add to a subtotal or constants and variables such as exchange rates, interest rates, and other indexes.
- Use of colour and graphics
- I like to use the company logo or other graphic as a design element in my spreadsheet. Sometimes I do this by using the corporate colours, other times by using the graphic itself. If I have a spreadsheet with a lot of macro buttons, I may use command objects and use the logo as a picture on the button.
- Removing excel components
- There are a number of excel components that you can turn off. Menu screens and reports screens may not need horizontal or vertical scroll bars, sheet tabs or row and column headings. Using macro buttons to return to a menu can overcome the need for sheet tabs. Not displaying gridlines will give a clean uncluttered look to a layout, and then using borders as necessary can create emphasis in the right areas.
You’ll find the complete text here:
Design Presentation TipsAlso see:
SpreadsheetStyleSee all Topics
-
November 12, 2005 at 9:55 am #3118724
ADDENDUM Light up where you live A nation’s porc…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Light up where you live
A nation’s porch light
“Ben Fry is a doctoral candidate at the MIT Media Laboratory. His research focuses on methods of visualizing large amounts of data from dynamic information sources. This work is currently directed towards “Genomic Cartography” which is a study into new methods to represent the data found in the human genome.”
He has a fascinating demonstration of data display technique:
Type in a zip code one number at a time to see how zip codes are distributed in the US.
[
Edited entry from 2/1/2004
]See all
Topics
-
November 13, 2005 at 9:55 am #3119859
POWERPOINT How to bum out your Audience Audience…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
How to bum out your Audience
Audience antagonizers
What are the three most annoying things about bad PowerPoint presentations?
“According to the survey, conducted on the CommunicateUsingTechnology.com web site, the most common complaints are:
- Speakers reading their slides to the audience (62% of respondents cited this item),
- Text on the slides is too small to be readable (46.9%)
- Slides hard to see because of color choice (42.6%) and
- Full sentences were used instead of bullet points (39.1%).
This survey is one of the first to investigate how presentations are seen from the audience point of view.
Of those respondents who see 100 or more presentations per year, more than half said that 50% or more of the presentations they see suffer from one or more of the annoying traits. The costs of poor presentations are in the time wasted by those who attended and in the extra work that must be done to communicate the intended message again since it was not done properly the first time.”
CommunicateUsingTechnology.com:
Annoying PowerPoint Survey[Edited entry from 2/2/2004]
See all Topics
-
November 14, 2005 at 10:00 am #3119998
WORD Merge Pictures Different picture to every l…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Merge Pictures
Different picture to every letter in a mail merge
A variation of this technique could also be used with an IF statement to display different pictures based on some criteria, such as Zip code.
- Open the Excel worksheet that you use as the mail merge data source.
- Insert a new column that has a column heading such as Picture.
- For each row of the Excel worksheet, insert in the Picture column the path and the file name of the picture that you want to use for that record of the data source. Additionally, enclose the path and the file name in quotation marks (“).
For example, copy the path and the file name of the picture in Windows Explorer. Then, paste the path and file name into the Excel worksheet.
Note The path and the file name of each picture in the Picture column will appear similar to the following example:
“C:\Documents and Settings\username\My Documents\My Pictures\foldername\filename.jpg”
- On the Edit menu, click Replace. Then, replace each instance of a single slash mark (\) with double slash marks (\\) in each path.
For example, each path should now look similar to the following example:
“C:\\Documents and Settings\\username\\My Documents\\My Pictures\\foldername\\filename.jpg”
- Save and then close the Excel worksheet. Then, quit Excel.
In Word, follow these steps:
- Open the mail merge main document.
- If the Excel data source is not attached, attach the data source. To do this, go to Step 3 of 6 in the Mail Merge task pane. Click Browse, and then attach the Excel data source.
- Click Next: Write your letter.
- In the mail merge main document, move the insertion point to the location where you want the picture to appear.
- On the Insert menu, click Field.
- In the Field dialog box, click IncludePicture under Field names, and then click OK.
Note You may receive the following error message:
Error! Filename not specified - Press ALT+F9 to display the field codes in the mail merge main document. You will see a field that is similar to the following field:
{ INCLUDEPICTURE \* MERGEFORMAT }
- Move the insertion point into the field immediately following INCLUDEPICTURE.
- Press the SPACEBAR, and then click More items on the Mail Merge task pane.
- In the Insert Merge Field dialog box, click the picture merge field, such as Picture, and then click Insert.
- Click Close to close the Insert Merge Field dialog box.
The INCLUDEPICTURE field should now look similar to the following field:
{ INCLUDEPICTURE { MERGEFIELD “Picture” } \* MERGEFORMAT }
- Press ALT+F9 to hide the field codes in the mail merge main
- Click Next: Preview your letters.
- Click Next: Complete the merge.
- In the Mail Merge task pane, click Edit individual letters.
- In the Merge to New Document dialog box, click OK.
- On the Edit menu in the merged document, click Select All.
- Press F9 to update the fields in the merged document.
(Word mail merges are not dynamic) - To print your letters from the merged document, click Print on the File menu. Each printed letter will contain the picture that you specified in the Excel data source.
Knowledgebase #909132:
Different picture to every letter in a mail mergeSee all Topics
-
November 15, 2005 at 8:45 am #3131369
ACCESS Normalization Designing an efficient data…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Normalization
Designing an efficient database
Here is an understandable article about how to put together a normalized database.
One topic covered is what should be used for a Primary or foreign key.
“In general, a key field should have these characteristics:
- Should be One Field
- It is possible to define multiple fields as the key fields of a table, but a single field is preferable. …Far better to have a CustomerID number than a combination of other fields to define a customer.
- Should be Numeric
- Access offers an AutoNumber field that is a Long Integer which is ideal for key fields. These values are automatically unique for each record and supports multi-user data entry as well.
- Should Not Change Over Time
- A key field should not change over time. Once identified, like a social security number, it should never change.
- Should be Meaningless
- To ensure a key field doesn?t change over time, it should have no meaning and therefore no reason to change over time.
Here are a few of the other topic headings:
Understanding Your Data
- What Data Do You Need?
- What Are You Going to Do with the Data?
- How Is Your Data Related to Each Other?
- What Is Going to Happen to the Data Over Time?
- Learn How to Use Queries
Database Normalization Tips
By Luke Chung, Founder and CEO of FMS IncAlso see:
Knowledgebase #283878:
Description of the database normalization basics15seconds.com:
Introduction to Relational Databasesand:
See all Topics
-
November 16, 2005 at 8:55 am #3130487
ADDENDUM Hole in Backyard A guy digs a hole in h…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Hole in Backyard
A guy digs a hole in his back yard
“About 2 years ago I decided to dig a hole in my back yard.
Why?
Why not.
Its good exercise and I could get a tan too. Plus holes are cool.”” I’m considering selling scoops of dirt from the hole. I figure 12 bucks should cover the shipping and the trouble. I’ll send you a baggie of dirt, with a signed certificate of authenticity. If you want it, you better ask for it now. My house has a sale pending so I’m not sure how much longer I’ll be able to do this.
If you want some other piece of a hole like a wood chip, a dead frog, or maybe a mud stained rag. Just ask.”
Also guy shoots off rocket with baby daughter:
Rocketship
(a video)See all
Topics
-
November 17, 2005 at 8:55 am #3132014
POWERPOINT Better PowerPoint Presentations More …
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Better PowerPoint Presentations
More suggestions
There are never enough tips for successfully communicating information.Michael Hyatt has these guidelines:
I like the first rule. The purpose of the meeting is to communicate information, not to demonstrate your prowess with a piece of software.
- Rule #1:
- Don?t give PowerPoint center stage.
- Rule #2:
- Create a logical flow to your presentation.
- Rule #3:
- Make your presentation readable.
- Rule #4:
- Remember, less is more.
- Rule #5:
- Distribute a handout.
Michael Hyatt is the President and Chief Operating Officer of Thomas Nelson Publishers, the largest Christian publishing company in the world and the ninth largest publishing company of any kind.
Five Rules for Better PowerPoint Presentations
See all Topics
-
November 18, 2005 at 9:46 am #3131061
EXCEL Su Doku CrossNumber puzzles I have to adm…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Su Doku
CrossNumber puzzles
I have to admit that I have not caught the fever that these puzzles seem to have generated.
Most every newspaper in the world has started publishing these brain teasers.
“Sudoku , sometimes spelled Su Doku, is a logic based placement puzzle, also known as Number Place in the United States. The aim of the canonical puzzle is to enter a numerical digit from 1 through 9 in each cell of a 9×9 grid made up of 3×3 subgrids (called “regions”), starting with various digits given in some cells (the “givens”). Each row, column, and region must contain only one instance of each numeral.
Completing the puzzle requires patience and logical ability. Its grid layout is reminiscent of other newspaper puzzles like crosswords and chess problems.
Although first published in 1979, Sudoku initially became popular in Japan in 1986 and attained international popularity in 2005.”
Here is a download that will construct as many of these puzzles as you might be Jonesing for.
Andy Pope Su Doku
Also:See all Topics
-
November 19, 2005 at 9:28 am #3117401
WINDOWS Dvorak anyone? Alternative Keyboard Layo…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Dvorak anyone?
Alternative Keyboard Layouts
“Free keyboard layouts — called Dvorak layouts — are available for people who type with one hand or finger. These layouts make the most frequently typed characters on a keyboard more accessible to people who have difficulty using the standard keyboard layout (called the “QWERTY” layout).
Dvorak keyboard layouts reduce the amount of motion required to type common English text. Use of these layouts may also help avoid some types of repetitive strain injuries associated with typing.
Studies have also shown an increase in typing speed and accuracy when using the Dvorak layout for two hands. The left-hand or right-hand keyboard layouts can also be useful for people who type with a wand.”
You do not need to modify your hardware keyboard to use these layouts, but you will need to change your keyboard settings to use the Dvorak layouts.
(A keyboard layout is a map or a definition of how keys are laid out on your keyboard. The keyboard layout you use is determined by software in your computer. The letters on your keys indicate the standard layout for your keyboard.)
Introducing the Dvorak Keyboard
By Marcus BrooksA Brief Primer
by Randy Cassingham[Edited entry from 2/3/2004]
See all Topics
-
November 20, 2005 at 9:30 am #3117300
FRONTPAGE Java and all that jazz Free code One …
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Java and all that jazz
Free codeOne way to jazz up a boring web site is to use scripting to present random images or create interesting menus. You could learn to do it yourself, or borrow from the stars.
JavaScript-2.com
is a source for free JavaScript Codes.Find FREE JavaScript codes quickly and easily with the only search engine that searches all the top Java Script libraries, offering a total of over 8,000 free JavaScripts.
[
Edited entry from 2/4/2004
]See all
Topics
-
November 21, 2005 at 9:34 am #3122365
WORD Mail Merge Page Printing One big page After…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Mail Merge Page Printing
One big page
After completing a merge to a new document, the status bar may indicate that the insertion point is located on page 1 of 38 pages. This is a bit of mis-information.
If you turn on Show/Hide and look at the merged document in Normal view, you’ll see that the merged document has section breaks rather than page breaks.
If you try to print what should be Page 1, the entire document will print.
To print just the first section, use “s1” in the Print dialog box.
Another way to handle it is to go to Edit>Replace and replace
“^b” (section break)
With
“^m” (manual page break)
From Office.Microsoft.com:
In the Pages box, type instructions to print one of the following:
- Noncontiguous pages
- Type the page numbers with commas between them. Type the range of pages with a hyphen between the starting and ending numbers in the range.
For example, to print pages 2, 4, 5, 6, and 8, type 2,4-6,8
- A range of pages within a section
- Type p page number s section number.
For example, to print pages 5 through 7 in section 3, type p5s3-p7s3
- An entire section
- Type s section number.
For example, type s3
- Noncontiguous sections
- Type the section numbers with commas between them.
For example, type s3,s5
- A range of pages across sections
- Type a range of page numbers and the sections that contain them with a hyphen between the starting and ending numbers in the range.
For example, type p2s2-p3s5
See all Topics
-
November 22, 2005 at 9:51 am #3123626
OUTLOOK Email Icons Foil the spoilers If you i…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Email Icons
Foil the spoilers
If you include an email address it can be read be the evil robot of the web.
Nexodyne.com will create a free email icon graphic to be used in place of a mail hyperlink.You could also use this piece of Javascript to avoid R2D2.
(user in this case would be “MyJunkMail.Place”
mydomain would be “Gmail.com”)
<script language="JavaScript">
<!-- Begin
user = "myaddress";
domain = "mydomain";
document.write('<a href=\"mai' + 'lto:' + user + '@' + domain + '\">');
document.write(user + '@' + domain + '</a>');
// End -->
</script>
<noscript>
Here goes some text that can be seen if Javascript is disabled.
</noscript>(from SB Projects.com)
See all Topics
-
November 23, 2005 at 9:26 am #3114067
ACCESS Sort Forms Create a sorting function Her…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Sort Forms
Create a sorting function
Here is one way to provide your users with a means to reorder fields in forms.
“Chris Weber develops a solution that allows users to sort the data in their forms (or subforms) that you can add to your application easily.
- The sorting interface should be generic to any form in any database.
- It should also work with subforms.
- It needs to be implemented as expediently as possible to fulfill the bid, and be easily maintained in the future.
- It should be intuitive or reminiscent of other interfaces in Access and Windows.
Scroll down to the bottom of the page. There is a file that can be downloaded with the code.
See all Topics
-
November 24, 2005 at 9:26 am #3113809
ADDENDUM Graphics from the ’50’s Remember it the …
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Graphics from the ’50’s
Remember it the way you want to
Original fifties clipart? Just in time for the holidays, some Ozzie and Harriet style pics.“Most communities in the fifties had small town print shops that doubled as printers of local news and advertising papers. These printers could not afford graphic artists so they used stock clipart supplied by large companies who distributed common graphics for use in advertising sections of the papers. They were provided for the printer in lots of categories to meet any advertiser’s needs.”
See all
Topics
-
November 25, 2005 at 9:23 am #3122667
POWERPOINT More Tips on Presentations From anot…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
More Tips on Presentations
From another point of view
“Holding the honorary title of ?Microsoft Regional Director? for Chennai over the last 6 years, I have delivered hundreds of presentations and lectures. Doing this, I have learned that doing successful presentations is an Art, which can be acquired only over time and by practice.”
Venkatarangan, Chennai, India
There are 3 basic ways to learn this art:
- Listen to great speakers: Attend as many programs of great speakers as possible. Subject spoken is immaterial here, what you are learning is the ?Master’s? way of doing it.
- Read about doing presentations: There are now plenty of books on doing effective presentations and Internet has numerous pages on this. Read them.
- Keep Doing it: Get on stage as many times as you can and just do it. As they say, your mistakes teach you more than anyone. So as you keep doing more and more presentations, you will learn on your mistakes and improve.
Also:
- General Tips:
- Health/Life Style Tips:
- Doing Technical Presentations:
- Authoring Power Point Slide-Decks:
- Laptops, Audio-Video & Systems:
- Sharing the stage:
- Answering Questions — Q & A:
http://www.venkatarangan.com/blog/PermaLink.aspx?guid=dab57735-2976-40d7-a5d0-2e641ddea515">Venkatarangan’s Blog
See all Topics
-
November 26, 2005 at 9:23 am #3044008
WINDOWS Kr jeder Accessibility Shortcuts Sever…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Kürzungen für jeder
Accessibility Shortcuts
Several resources are available to help increase speed and effectiveness for keyboard users. Here are keyboard shortcuts for leading Microsoft products that help save time and effort and provide an essential tool for some people with mobility impairments.
- FrontPage
- Internet Explorer 6/5/4
- Office (2003/XP/2002/2000/97)
- PhotoDraw
- PowerPoint
- Producer
- Publisher
- Windows (2003/XP/2000/98/ME/NT)
- Windows Media Player
- Windows Movie Maker
- Windows XP Media Center Edition 2005
Microsoft.com Keyboard Assistance.
[Edited entry from 2/11/2004]
See all Topics
-
November 27, 2005 at 9:21 am #3043892
FRONTPAGE Internet 099 Basics and Beyond A San…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Internet 099
Basics and Beyond
A 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.”
[
Edited entry from 2/20/2004
]See all
Topics
-
November 28, 2005 at 9:21 am #3122963
EXCEL Free Excel Templates Financial enlightenmen…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Free Excel Templates
Financial enlightenment
Matt H. Evans CPA. CMA, CFM has complied a list of 75 free Excel spreadsheets devoted to financial matters.
Here are a few of the entries:
- Time Value (xls)
- Introduction to time value concepts, such as present value, internal rate of return, etc.
- Lease or Buy a Car (xls)
- Basic spreadsheet for deciding to buy or lease a car.
- Top Five NPV & IRR (xls
- Explains Internal Rate of Return, compares projects, etc.
- Statements (xls)
- Generate a set of financial statements using two input sheets – operational data and financial data.
- Business Financial Analysis Template
- for start-up businesses from Small Business Technology Center
- Income Statement
- What If Analysis
- Assessment Templates
- Set of templates for assessing an organization based on the Malcolm Baldrige Quality Model.
See all Topics
-
November 29, 2005 at 7:07 am #3121878
WORD Automate Word Tables VBA examples and instr…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Automate Word Tables
VBA examples and instructions
The 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.
While Word does provide some tools for displaying tables from databases in its documents, these are somewhat rudimentary, they require a basic understanding of how the database is built, and using them involves a number of steps. In addition, there may also be security and access issues involved, requiring additional layers of protection.
The developer is therefore increasingly confronted with the task of transferring data into Word, whether in the form of tables, or as part of the document text. This article considers some of the major aspects of using the Word object model to work with tables.”
- Introduction to Automating Tables
- Creating Tables Programmatically in Word
- Populating Word Tables with Data
- Adding Linking in Word Tables Programmatically
- Extracting Data from Word Tables Programmatically
A downloadable document is also available for those of us still addicted to paper.
Automating Word Tables for Data Insertion and Extraction
See all Topics
-
November 30, 2005 at 7:02 am #3127608
OUTLOOK Mailto Shortcut Just a quick note You …
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Mailto Shortcut
Just a quick note
You 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’
CMG WebMasters has a free code maker:
Mailto Link Generator
See all
Topics
-
December 1, 2005 at 10:05 am #3128905
ACCESS Other Right Clicks A couple overlooked R…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Other Right Clicks
A couple overlooked
Right-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.
See all
Topics
-
December 2, 2005 at 8:10 am #3129166
ADDENDUM Rewind DVDs Speed the process Sometimes…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Rewind DVDs
Speed the process
Sometimes one finds a solution to a problem that is not seeking an answer.
“Guaranteed Lowest Price on the Internet for DVD Rewinding
No More Embarrassing Fines or Hassles at your Video Rental Store !!!
No Fuss — No Waiting — Do It Online — Do It Now!
Rewind your DVDsSee all Topics
-
December 2, 2005 at 12:14 pm #3127059
ADDENDUM Rewind DVDs Speed the process Sometim…
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Rewind DVDs
Speed the process
Sometimes one finds a solution to a problem that is not seeking an answer.
“Guaranteed Lowest Price on the Internet for DVD Rewinding
No More Embarrassing Fines or Hassles at your Video Rental Store !!!
No Fuss — No Waiting — Do It Online — Do It Now!
Rewind your DVDsSee all Topics
-
December 3, 2005 at 12:08 pm #3128058
POWERPOINT Can We Serve Multiple Masters? Duel …
by dklippert · about 18 years, 4 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Can We Serve Multiple Masters?
Duel Masters and more schemes
Earlier 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 2003
.Makes you want to dance. (Echo’s own image)
Also:
Presentations.com:
Make maximum use of the multiple slide master
[
Edited entry from 2/18/2004
]See all
Topics
-
December 4, 2005 at 4:12 pm #3127834
WINDOWS Zapf your own Dingbat Private Character…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Zapf your own Dingbat
Private Character Editor
Windows XP has its own, hidden, character creator, called the Private Character Creator .
Using Private Character Editor (PCE), you can create up to 6,400 unique characters (such as special letters and logos) for use in your font library. PCE contains basic tools for creating and editing characters, along with more advanced options.
If you want to create a new private character using an existing character as your model, you can copy the existing character to the Edit grid and then modify it to suit your needs, or you can display the existing character in a Reference window alongside your Edit grid for use as a visual reference. You can use any character from any font that is installed on your computer.
The Private Character Editor is accessed at Start>Run and enter “Eudcedit” without the quotes.
After you have constructed and saved the design of your choosing, you can access it from the Character Map by selecting Start>Run “Charmap“.
Drop the Font selection list down and choose All Fonts (Private Characters), then click on the character you have created, copying and pasting it into any document.
Hermann Zapf designed some of the 20th century’s most important fonts, including Palatino and Optima. He also produced a collection of decorative symbols called “dingbats”, modeled after the accidental lead drippings collected by old style typesetters.
Also:
Private Character Editor — Eudcedit
By Vic LaurieKeyboard Utilities for Windows
Alan Woods[Edited entry from 2/19/2004]
See all Topics
-
December 5, 2005 at 8:15 am #3128256
FRONTPAGE Photo Gallery A CSS exercise FrontPa…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Photo Gallery
A CSS exercise
FrontPage does include 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 NichollsSee all
Topics
-
December 6, 2005 at 8:41 am #3126772
EXCEL Dynamic AutoShape Link Show the star Here’…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Dynamic AutoShape Link
Show the star
Here’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.
- Create an AutoShape on the Worksheet
- With the shape selected, type an equal sign in the formula bar.
- Enter the address of the linking cell (or click the cell)
- Hit Enter
Thanks to AutomateExcel.com for the reminder.
See all Topics
-
December 7, 2005 at 8:47 am #3126313
WORD Page Numbers A baker’s dozen of ideas Her…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Page Numbers
A baker’s dozen of ideas
Here 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.
Insert an “if” field into the footer.The field in this case will be a compound entity that consists of two fields nested within a third field.
{ IF { PAGE } = { NUMPAGES } “” “more” }
- Position cursor where you want the field.
- Press Ctrl+F9 to insert the field braces.
- Type the field expression as it appears below, using Ctrl+F9 and arrow keys as needed to keep text within the various braces as you type.
{ IF { PAGE } = { NUMPAGES } “” “more” } - Select the entire expression.
- Right-click the selection and choose Toggle Field Codes.
(or use Alt+F9)
WordMacros.com:
Headers and footers and page numbersAlso see:
Don’t get framedSee all Topics
-
December 8, 2005 at 7:40 am #3129837
OUTLOOK Digitally Sign Messages If you have a n…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Digitally Sign Messages
If you have a need to protect the contents of your email messages, these links should point you in the right direction.
Outlook 2003 supports the following features for cryptographic messaging:
Digitally sign an e-mail message. Digital signing provides nonrepudiation and verification of contents (the message contains what the person sent, with no changes).Encrypt an e-mail message. Encryption helps to ensure privacy by making the message unreadable to anyone other than the intended recipient.
There are additional features that can be configured for Outlook 2003 for security-enhanced messaging, if your organization chooses to provide support for them, including:Sending an e-mail message with an S/MIME receipt request. This helps to verify that the recipient is validating your digital signature (the certificate you applied to a message).
Adding a security label to an e-mail message. Your organization can create a customized S/MIME V3 security policy which can add labels to messages. An S/MIME V3 security policy is code that you add to Outlook that runs automatically to add information to the message header about the sensitivity of the message content. For example, an Internal Use Only label might be applied to mail that should not be sent or forwarded outside of your company.
Overview of Cryptography in Outlook 2003
Slipstick.com:
Encryption and Message Security Tools
TheTechGap.com:
Digital IDs in Outlook
Verisign:
Digital IDs
See all
Topics
-
December 9, 2005 at 7:30 am #3130313
ACCESS Data Modeling Data bits and pieces While…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Data Modeling
Data bits and pieces
While 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.
The goal of the data model is to make sure that the all data objects required by the database are completely and accurately represented. Because the data model uses easily understood notations and natural language, it can be reviewed and verified as correct by the end-users.
The data model is also detailed enough to be used by the database developers to use as a “blueprint” for building the physical database. The information contained in the data model will be used to define the relational tables, primary and foreign keys, stored procedures, and triggers. A poorly designed database will require more time in the long-term. Without careful planning you may create a database that omits data required to create critical reports, produces results that are incorrect or inconsistent, and is unable to accommodate changes in the user’s requirements.”
University of Texas at Austin
Introduction to Data Modeling
Finding the Perfect Fit
By Tim McLellan
AgileData.org:
Data Modeling 101
DataModel.org
See all
Topics
-
December 10, 2005 at 9:43 am #3124247
ADDENDUM Dictionary means never having to say hu…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Dictionary means — never having to say huh?
Google dictionary
“To see a definition for a word or phrase, simply type the word “define,” then a space, and then the word(s) you want defined. If Google has seen a definition for the word or phrase on the Web, it will retrieve that information and display it at the top of your search results.
You can also get a list of definitions by including the special operator “define:” with no space between it and the term you want defined. For example, the search [define:World Wide Web] will show you a list of definitions for “World Wide Web” gathered from various online sources.”
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/9/2004]
See all Topics
-
December 11, 2005 at 1:45 pm #3121080
POWERPOINT If We’re in Trouble It’s Probably Bec…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
If We’re in Trouble
It’s Probably Because People No Longer Really Listen
Yes, now we can add Iraq to the evils perpetuated by PowerPoint.
“Not only is it easier to throw together a stack of PowerPoint slides than it is to write that 10,000-word document, it is much easier to leave out or gloss over parts of the project that might not survive close scrutiny if they were described in complete sentences. Can you say “weapons of mass destruction?” If we cut to the heart of this current controversy about whether Iraq really had WMD, whether the U.S. honestly believed Iraq had WMD, and who got it wrong, I’m sure we’ll end up with a guilty PowerPoint stack. In that stack, you’ll find a slide containing the words “Iraq” and “WMD” but taken out of context, there is no way of knowing what the presenter even intended the slide to mean. Thus, we have plausible deniability through PowerPoint.”For eight years from 1987-95, Robert X. Cringely wrote the Notes From the Field column in InfoWorld, a weekly computer trade newspaper. He is also the author of the best-selling book Accidental Empires: How the Boys of Silicon Valley Make Their Millions, Battle Foreign Competition, and Still Can’t Get a Date.
Most recently, Cringely is the host and writer of the hit PBS-TV miniseries “Electric Money.”
Robert X. Cringely
(
http://www.pbs.org/cringely/
)[
Edited entry from 2/10/2004
]See all
Topics
-
December 12, 2005 at 9:54 am #3197162
WINDOWS Glossary What does it all mean We live …
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Glossary
What does it all mean
We 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.
- Security Glossaries
- Multimedia Glossaries
- Partner and Business Glossaries
- Technical Glossaries
- Non-English Language Glossaries
Microsoft Glossary Information Center
See all Topics
-
December 13, 2005 at 11:19 am #3197689
FRONTPAGE RSS with FrontPage Roll your own Sure…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
RSS with FrontPage
Roll your own
Sure,
Blogger
is great and free. Sure,
RadioUserland
is cheap and easy to use.If 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.
If you spend any time on the Internet, you have probably heard of RSS, and you may decide that you need an RSS feed for your Web site. An RSS feed is an Extensible Markup Language (XML) file that people can use to keep up to date with the content on a Web site. RSS feeds are frequently associated with weblogs (blogs), but you can use them for any Web site.
If you have a Web site that contains content that you frequently update, such as articles or stories, you may want an RSS feed to help your customers keep up with your updates. This article explains the XML behind RSS and provides a Microsoft Office FrontPage 2003 Visual Basic for Applications (VBA) project that you can use to programmatically generate an RSS feed for your FrontPage Web site. The download for this article includes an Extensible Stylesheet Language Transformation (XSLT) file that you can use to display the RSS XML file in a browser.”
Microsoft Developers Network:
Creating an RSS Feed for Your FrontPage Web Site
See all
Topics
-
December 14, 2005 at 11:41 am #3121321
EXCEL Put the Path in a Footer Sometimes the old…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Put the Path in a Footer
Sometimes the old way is still usefulPre 2002, Excel made it difficult to put the file path in the Header or Footer
After 2002, there is an icon to put the path in a header or footer. The code is[File]
Still, you may find some use for the VBA code.
The following macro will insert the full path of a saved file in the center portion of the footer in the active
-
December 15, 2005 at 7:53 am #3125546
WORD SCORE Templates Free business advice SCOR…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
SCORE Templates
Free business advice
SCORE 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.
- SCORE offers Ask SCORE email advice online.
- Face-to-face small business counseling at 389 chapter offices.
- Low-cost workshops at 389 chapter offices nationwide.
- “How to” articles and business templates
Here are some of the available templates:
- A Business Plan for a Start-up Business
- Microsoft Word
- A Business Plan for an Established Business
- Microsoft Word
- Bank Loan Request for Small Business
- Microsoft Word
- Break-Even Analysis
- Excel
- Competitive Analysis
- Microsoft Word
- Financial History & Ratios
- Excel
- Loan Amortization Schedule
- Excel
- Opening Day Balance Sheet
- Excel
- Personal Financial Statement
Excel - Projected Balance Sheet
- Excel
- Start-up Expenses
- Excel
- 4-Year Profit Projection
- Excel
- 12-Month Cash Flow Statement
- Excel
- 12-Month Profit and Loss Projection
- Excel
- 12-Month Sales Forecast
- Excel
See all Topics
-
December 16, 2005 at 7:09 am #3125353
OUTLOOK Protect Your Address Keep the bots at bay…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Protect Your Address
Keep 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
-
December 17, 2005 at 10:06 am #3135289
ACCESS Access on Line Free Basic Instruction Mi…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Access on Line
Free Basic Instruction
Microsoft 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 2003, these suggestions will work with most earlier versions.
For Access look at:
Access 2003If you have avoided Access in the past, a least glance at “Getting started with Access and Database applications“
Also:
These are 30 to 55 minute demonstrations.
“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 2/8/2004]
See all Topics
-
December 18, 2005 at 10:07 am #3120752
ADDENDUM Where in the World is . . . Your spy do…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Where in the World is . . .
Your spy dollars at work
The World Factbook provides a ‘snapshot’ of the world.
The online Factbook is updated regularly – generally weekly – throughout the year.
A 30Meg 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
:- Azerbaijan
- Local scientists consider the Abseron Yasaqligi (Apsheron Peninsula) (including Baku and Sumqayit) and the Caspian Sea to be the ecologically most devastated area in the world because of severe air, soil, and water pollution; soil pollution results from oil spills, from the use of DDT as a pesticide, and from toxic defoliants used in the production of cotton
[
Edited entry from 2/17/2004
]See all
Topics
-
December 19, 2005 at 10:17 am #3123969
POWERPOINT Troubleshoot PowerPoint Live on tape …
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Troubleshoot PowerPoint
Live on tape
On occasion, Microsoft presents Webcasts on interesting subjects.
- Unfortunately they are usually offered at inconvenient times for people with real jobs.
- Fortunately they are offered in a form that you can download or watch “on-demand”.
Here’s one on how to find and fix problems with PowerPoint presentations.
“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 WebcastsSee all Topics
-
December 20, 2005 at 9:46 am #3125044
WINDOWS Stars on Your Desktop Space image wallpa…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Stars on Your Desktop
Space image wallpaper
NASA 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
See all
Topics
-
December 21, 2005 at 9:37 am #3196655
FRONTPAGE Form Design Fancy functionals Here i…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Form Design
Fancy functionals
Here 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.
It’s that last part that we’re going to focus on here. We’ve all heard and read about big usability mistakes time and time again: “Don’t use images or flash for navigation,” “Don’t use Javascript for links,” and I certainly hope we’re all applying those lessons in our work. It’s often the smallest usability quirks, however, that create the biggest annoyances for users, especially when it comes to HTML forms. Follow these guidelines, and you’ll be off to a good start.”
- Use the right field for the task
- Give them room to type
- Shorten your forms and question “mandatory” fields
- Mark mandatory fields clearly
- Provide descriptive labels for all of your fields
- Let the computer, not the user, handle information formatting
- Use informative error messages
- Don’t return users to an altered form
Sensible Forms
Brian CrescimannoSee all Topics
-
December 22, 2005 at 6:12 am #3198070
EXCEL Hide Digits Simple obfuscation The kid s…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Hide Digits
Simple 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
See all
Topics
-
December 23, 2005 at 5:50 am #3196468
WORD Justify Clean up Minimize white space When…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Justify Clean up
Minimize white space
When 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
See all
Topics
-
December 24, 2005 at 9:48 am #3081351
OUTLOOK Yeah, Sure, That’s My Email A lie will s…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Yeah, Sure, That’s My Email
A lie will set you free
Dodgeit.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.
Also see:
Protect Your Address
[
Edited entry from 2/7/2004
]See all
Topics
-
December 26, 2005 at 9:50 am #3082357
ACCESS Parameter Queries Deux Another look at pa…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Parameter Queries Deux
Another look at parameters
The ability to use dynamic criteria in a Query makes Access even more valuable.David Badurina operates
Davidbase.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
[
Edited entry from 2/16/2004
]See all
Topics
-
December 27, 2005 at 9:49 am #3083007
ADDENDUM Where in the World is it Raining? Weath…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Where in the World is it Raining?
Weather maps from around the world
Want 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:
See all
Topics
-
December 28, 2005 at 1:51 pm #3083142
POWERPOINT Animate Charts Make data more moving …
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Animate Charts
Make data more movingWipe away the drool that develops when looking at Office 12 formatting and deal with what we’ve got.
“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.”
In normal view, display the slide that has the chart you want, and then select the chart.
On the Slide Show
-
December 29, 2005 at 9:54 am #3082769
WINDOWS A Hot Spot in your Pocket Or at least ne…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
A Hot Spot in your Pocket
Or at least nearby
It’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.
What if you could marry the short-range power of Wi-Fi with the huge coverage areas of high-speed cellular services such as EV-DO to create a portable hotspot?
Since EV-DO works at freeway speeds, you could even give Internet access to an entire road-trip caravan.Now I can surf for as long as three hours without being tethered to anything but a cell signal. The project isn’t cheap, but prices for the components and service are sure to come down in the next year or so. In the meantime, you can find me in the hills around Southern California. I’ll be the one surrounded by PSP-packing hikers.”
Popular Science:
Be Your Own Hotspot
By Mike OutmesguineSee all
Topics
-
December 30, 2005 at 9:49 am #3081670
EXCEL Animate window size So cool! The followin…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Animate window size
So 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.
This macro will gradually resize a worksheet from small to Maximized. The worksheet appears to be growing:
Sub SheetGrow()
Dim x As Integer
With ActiveWindow
.WindowState = xlNormal
.Top = 1
.Left = 1
.Height = 50
.Width = 50For x = 50 To Application.UsableHeight
.Height = x
Next xFor x = 50 To Application.UsableWidth
.Width = x
Next x.WindowState = xlMaximized
End With
End SubFrom AutomateExcel.com:
ActiveWindow.WindowState
(By Mark William Wielgus)See all
Topics
-
December 31, 2005 at 9:51 am #3081950
WORD Runaway Styles in 2003 Put the horses back …
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Runaway Styles in 2003
Put the horses back in the barn
Word 2003 keeps track of direct formatting applied to a style. This can lead to what has been referred to as “runaway” styles”. Pre 2003 you could find styles by using “What’s This?” (
Shift+F1
) and pointing at the text.Word now has Format>Reveal Formatting in a task pane.
(BTW, turn on the “
Distinguish Style Source
” option at bottom of task pane.)You can no longer update the style using the Style Box. Before, you could make a change, click on the style in the Style Box on the Formatting toolbar and receiving the Modify Style dialog.
To go back to the ways things were in the good old days and help defeat runaway styles, go to Tools>Options.
On the
Edit
tab, uncheck:”
Keep track of formatting
“Allows Word to keep track of your formatting as you type. This enables you to easily apply the same formatting elsewhere.
and check:
“
Prompt to update style
“Specifies that Word prompts you when you directly modify text that contains a style and then select the same style again. When prompted, you can either update the style based on recent changes or reapply the formatting of the style.
Thanks to
Trish Krokosh
from the
WOPR lounge.Here’s a link to some code that will clear extra style appendages:
Macro to Delete CharChar styles
ComputerCompanion.com:
Make Word 2003 Workable
[
Edited entry from 2/6/04
]See all
Topics
-
January 1, 2006 at 9:59 am #3081172
OUTLOOK Duplicate – Duplicates The Walla Walla s…
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Duplicate – Duplicates
The Walla Walla syndrome
More than one copy of Contacts can be produced when, for instance, a user synchronizes a PDA with Outlook.
Microsoft has a cash reserve of about $50 billion. The money was accumulated over time by, among other things, selling software.
They don’t work for peanuts.
I would like to introduce Fr. Simon Rundell of the Parish of the Holy Spirit, Southsea, Portsmouth, England.
He offers a tool to delete duplicate entries in Microsoft Outlook. Calendar items, Tasks, Contacts, notes and mail folders.
He doesn’t work for fruitcakes.
“… available free for download as prayerware – Free to download, use and distribute, as long as you pray for me, Fr. Simon Rundell, Fr. Michael Lewis and our ministry at the Holy Spirit, Southsea.”
The Hlyspirit.or.uk no longer hosts the utility. You can still get it through Slipstick.com.
Whatever currency they normally take is waived for this free download.(Slipstick has other anti-duplicateware at
Duplicate Checkers
[
Edited entry from 2/15/2004
]See all
Topics
-
January 2, 2006 at 7:45 am #3081059
ACCESS Short Menus Control display If you have …
by dklippert · about 18 years, 3 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Short Menus
Control display
If you have left the personalized menus enabled, you don’t have to wait the default amount of time before you can access infrequently used features. Instead, you can display a full menu by double-clicking the menu name when you open it.
If you dislike the new menus, which initially show only the most recently used menu items, you can revert to the standard menu behavior. Right-click on the menu bar and choose Customize from the shortcut menu. Then, click on the Options tab of the Customize dialog box.
Choose either “Always show full menus” or “Show full menus after a short delay“. You can also reset the menus to their original state by clicking the “Reset menu and tool bar usage data” button.
See all Topics
-
January 3, 2006 at 7:53 am #3094586
BOOKS The Big Year : A Tale of Man, Nature, and F…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
BOOKS
The Big Year : A Tale of Man, Nature, and Fowl Obsession
By 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.
For three men in particular, 1998 would be a whirlwind, a winner-takes-nothing battle for a new North American birding record. In frenetic pilgrimages for once-in-a-lifetime rarities that can make or break their lead, the birders race each other from Del Rio, Texas, in search of the rufous-capped warbler, to Gibsons, British Columbia, on a quest for Xantus’s hummingbird, to Cape May, New Jersey, seeking the offshore great skua. Bouncing from coast to coast on their potholed road to glory, they brave broiling deserts, roiling oceans, bug-infested swamps, a charge by a disgruntled mountain lion, and some of the lumpiest motel mattresses known to man. “
PBS.org Newshour:
Conversation: ‘The Big Year’
(with streaming video interview)ChicagoPublicRadio.com:
Chicago Public Radio interview
[Edited entry from 2/21/2004]See all Topics
-
January 4, 2006 at 5:59 am #3094280
ADDENDUM Make a list How to check it January i…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Make a list
How to check it
January 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
See all
Topics
-
January 5, 2006 at 10:01 am #3094820
WINDOWS Control Panel Be empowered “Control Pa…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Control Panel
Be 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.
There are two view options for Control Panel: Category View and Classic View.
Category View displays Control Panel icons according to the type of task that the user wants to perform.
Classic View displays Control Panel icons in a view that is familiar to users of previous versions of Windows.”
- Click Start, and then Settings
- Click Control Panel.
- Click Appearance and Themes, and then click Folder Options.
- Open Folder Options.
- Under Tasks, click “Show common tasks in folders“, and then click OK.
- In the Control Panel box in the upper-left corner of Control Panel, click “Switch to Category” or “Switch to Classic View“.
Go to View and choose how you want the contents to be displayed. “Icons” is the Classic view, but details will show the purpose of each entry.
For more information about Control Panel icons, see:
- Accessibility Options
- Add Hardware
- Add or Remove Programs
- Administrative Tools
- Date and Time
- Display
- Folder Options
- Fonts
- Game Controllers
- Internet Options
- Keyboard
- Licensing
- Mouse
- Network Connections
- Phone and Modem Options
- Power Options
- Printers and Faxes
- Regional and Language Options
- Scanners and Cameras
- Scheduled Tasks
- Sounds and Audio Devices
- Stored User Names and Passwords
- Speech
- System
Microsoft Product Documentation:
Control PanelSee all Topics
-
January 6, 2006 at 9:50 am #3095615
FRONTPAGE Seniors Surf Too No Internet age limit…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Seniors Surf Too
No 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)
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
See all
Topics
-
January 7, 2006 at 8:53 am #3096270
EXCEL Access to Excel Excel at Access You can t…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Access to Excel
Excel at Access
You can think of Excel as a collection of flat file databases. Combining Excel and Access can make use of the best parts of both applications.
“Microsoft Excel is great at a lot of tasks, but it has limits as a database manager. If your Excel data worksheets are beginning to get out of hand, it may be time to call in a little help from Access.”
Creating Access Forms To Work with Excel Data
(Jim Uomini is a long-time trainer, courseware designer, technical writer, newsletter editor, and support manager. He currently manages the help desk for in-store systems at The Sharper Image.)
[
Edited entry from 2/5/2004
]See all
Topics
-
January 8, 2006 at 10:18 am #3095058
WORD Password is Password Safe and Sorry Safe Pa…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Password is Password
Safe and Sorry
Safe
Paul Cornell works for the Office Help team. He wrote a short paper on passwords used in Word and Excel:
Help Protect Word 2002 and Excel 2002 Files with Passwords
“Your organization may store Word and Excel documents in a central location such as a network server computer. However, you may not want all of your coworkers to have unlimited access to these documents. Setting the files to a read-only status does not prevent your coworkers from opening the documents, and denying your coworkers access to the network folder outright may be too restrictive in your organization’s computing environment. One solution is to help protect individual Word and Excel documents with passwords.”
Sorry
Passwords for documents are not, however, truly secure from a determined hacker.
There is a Knowledge Base article #822924 Overview of Office Features That Are Intended to Enable Collaboration and That Are Not Intended to Increase Security that reminds users that some passwords are not as strong as others.
For instance:
“When you are using the Password to Modify feature, a malicious user may still be able to gain access to your password. For example, if you save a word (.doc) file by using the Password to Modify feature enabled in Rich Tech Format (.rtf) a malicious user may be able to gain access to your password.”
Here is a January 7, 2004 article from ZDNet.co.uk:
A simple hack to Word’s password-protection feature means documents may not be as secure as users believe. No fix is on the way, says Microsoft[Edited entry from 2/14/2004]
See all Topics
-
January 9, 2006 at 7:13 am #3080562
OUTLOOK Spam Scam Please forward Here is a video…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Spam Scam
Please forwardHere is a video by Spiros Ioannou that reinforces the “don’t forward that to me” message.
E-mail scam video
See all Topics
-
January 9, 2006 at 11:16 am #3080415
OUTLOOK Spam Scam Please forward Here is a vid…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Spam Scam
Please forward
Here is a video by Spiros Ioannou that reinforces the “don’t forward that to me” message.
See all
Topics
-
January 10, 2006 at 8:59 am #3077966
ACCESS Change Properties in Form View Alteration…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Change Properties in Form View
Alterations 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.
See all
Topics
-
January 11, 2006 at 9:55 am #3079436
ADDENDUM GIF Editor Free tool Here is an onlin…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
GIF Editor
Free 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!
It’s simple! Using the easy-to-use pull down menus. Simply follow the instructions to load any GIF and then manipulate the image using the GIFWorks menus. It’s that easy.
The GIFWorks interface uses standard HTML and JavaScript. It should work correctly in Netscape and Internet Explorer versions 3.x and greater.”
See all
Topics
-
January 12, 2006 at 9:50 am #3080203
POWERPOINT Frame that Slide More PP bling Face i…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Frame that Slide
More PP bling
Face 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 BajajSee all
Topics
-
January 13, 2006 at 9:45 am #3079796
WINDOWS Free WXP Tools Some things you may never…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Free WXP Tools
Some things you may never have known
When you install Windows XP, you also get extra mini applications and tools. Most people know about MS Paint, and Calculator, but there are more.
Chris Pirillo put together a list a few years back.
Here are a few including an on screen keyboard.
(Type osk.exe at Start>Run)Windows Tools You Already Own
- Disk Cleanup = cleanmgr.exe
- Clipboard Viewer = clipbrd.exe (views contents of Windows clipboard)
- Dr Watson = drwtsn32.exe (Troubleshooting tool)
- DirectX diagnosis = dxdiag.exe (Diagnose & test DirectX, video & sound cards)
- Private character editor = eudcedit.exe (allows creation or modification of characters)
- IExpress Wizard = iexpress.exe (Create self-extracting / self-installing package)
- Object Packager = packager.exe (to do with packaging objects for insertion in files, appears to have comprehensive help files).
- System Monitor = perfmon.exe (very useful, highly configurable tool, tells you everything you ever wanted to know about any aspect of PC performance, for uber-geeks only )
- Program Manager = progman.exe (Legacy Windows 3.x desktop shell).
- Remote Access phone book = rasphone.exe (documentation is virtually non-existant).
- Registry Editor = regedt32.exe [also regedit.exe] (for hacking the Windows Registry).
- Network shared folder wizard = shrpubw.exe (creates shared folders on network).
- File signature verification tool = sigverif.exe
- Volume Control = sndvol32.exe (I’ve included this for those people that lose it from the System Notification area).
- System Configuration Editor = sysedit.exe (modify System.ini & Win.ini just like in Win98! ).
- Driver Verifier Manager = verifier.exe (seems to be a utility for monitoring the actions of drivers, might be useful for people having driver problems. Undocumented).
- Windows for Workgroups Chat = winchat.exe (appears to be an old NT utility to allow chat sessions over a LAN, help files available).
DecentDownloads.x-istence.com:
Secret Windows SoftwareSee all Topics
-
January 14, 2006 at 9:45 am #3077512
WORD Fields Tiny code snippets Microsoft has in…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Insert>Fields
Tiny code snippets
Microsoft has included a number of code pieces that you can use without having to haul out the VBA editor. These codes handle such things as page numbers, Table of Contents, Merge data and more.
“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.”
Automate Word Documents with Minimal Code
By Cindy MeisterCindy Meister is a Word MVP.
She also works with bobbin-lace. Here is a sample of a Honiton lace butterfly.
Also:
AddBalance.com:
Using { Fields } in Microsoft WordGMayor.com
Formatting Word Fields with SwitchesBetterSolutions.com:
Fields
[Edited entry from 2/24/2004]See all Topics
-
January 15, 2006 at 1:43 pm #3077378
EXCEL Do You Question the Web? Bring data to your…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Do You Question the Web?
Bring data to your desktop
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.
On the menu bar, go to Data>Import External Data. 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 RevealedMSDN.Microsoft.com/library
Integrate Far-Flung Data into Your Spreadsheets with the Help of Web ServicesDifferent Ways of Using Web Queries in Microsoft Office Excel 2003
And:
Web Queries and Dynamic Chart Data in Excel 2002[Edited entry from 2/13/2004]
See all Topics
-
January 16, 2006 at 9:46 am #3079192
OUTLOOK Email Headers How to read the code Spa…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Email Headers
How to read the code
Spam 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.
It is primarily intended to help victims of unsolicited email (“email spam”) attempting to determine the real source of the (generally forged) email that plagues them; it should also help in attempts to understand any other forged email.
It may also be beneficial to readers interested in a general-purpose introduction to mail transfer on the Internet. ”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.”
University of Bath in Swindon:
Anatomy of an Email Message
[
Edited entry from 2/25/2004
]See all
Topics
-
January 17, 2006 at 9:47 am #3097388
FRONTPAGE History of the Internet Time passes qui…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
History of the Internet
Time passes quickly
You 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.Not the complete history but just the cool stuff. The Internet history from the perspective of a computer geek who likes knowing more than what the instructions simply tell us.
This will not be a complete list but a work in progress. Enjoy.
Netcraft survey reports there are more than 74 million web sites online, while in 1993 only 130 web sites existed online.
A Computer Geek’s History of the Internet
Also:
Here’s a nice site:
The Living Internet
The Internet SOCiety:
History of the Internet
Also:
Internet History
See all
Topics
-
January 18, 2006 at 9:01 am #3099167
ACCESS New Default Access Form Template Set new …
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
New Default Access Form Template
Set new standards
You can change Access’s default form.
To set up a custom template,
- Create your template form by specifying all the properties you want to maintain from form to form.
- Then, save the form using any name.
- Next, select Tools>Options from the menu bar and select the Forms/Reports tab.
- Enter your template’s name in the Form Template box to replace the Access default (Normal) and click OK.
The next time you create a form, Access will base it on your form template rather than the typical Normal template.
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 (2005/06)See all Topics
-
January 19, 2006 at 9:16 am #3098477
ADDENDUM Hip Replacement Do it yourself Well, no…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Hip Replacement
Do it yourself
Well, 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.
Guests
Richard Ellenbogen, M.D. chairman of neurological surgery at the University of Washington School of Medicine, the Theodore S. Roberts Endowed Chair in Neurological Surgery, the Chief of Neurological Surgery at Harborview Medical Center
Eric Froines, M.D., F.A.C.S. chief of general surgery, Capitol Hill Specialty Center Group Health Permanente”
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.See all
Topics
-
January 20, 2006 at 9:14 am #3100037
POWERPOINT Free Assistance Worth a lot more than…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Free Assistance
Worth a lot more than you pay for it
Here 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.”
— Dale CarnegiePresentationHelper.co.uk:
Presentation Helper
See all
Topics
-
January 21, 2006 at 9:13 am #3098863
MUSIC Night Tide (Uxoricide) Big Sandy and His…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
MUSIC
Night Tide
(Uxoricide)
Big Sandy and His Fly-Rite Boys
ASIN B00004UDE3
Hightone Records August 15, 2000About 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 CorralContents
- Night Tide – Big Sandy & His Fly-Rite Boys
- Between Darkness and Dawn
- Tequila Calling
- When Sleep Won’t Come (Blues for Spade)
- If You Only Knew – Big Sandy & His Fly-Rite Boys
- Give Your Loving to Me
- In the Steel of the Night
- Man Like Me
- Hey Lowdown!
- My Time Will Come Someday
- I Think of You
- Nothing to Lose
- South Bay Stomp
- Let Her Know
[Edited entry from 2/22/2004]
See all Topics
-
January 22, 2006 at 9:13 am #3259630
WINDOWS It’s Your Icon Too Brand your own Explor…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
It’s Your Icon Too
Brand your own Explorer
Developers 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 from2/29/2004
]See all
Topics
-
January 23, 2006 at 7:59 am #3260100
WORD Readability Evaluation What grade are you? …
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
WORD
Readability Evaluation
What grade are you?
Word has a built in tool to determine the level of reading difficulty of a document.
To see the statistics:
- On the Tools menu, click Options, and then click the Spelling & Grammar tab
- Select the Check grammar with spelling check box
- Select the Show readability statistics check box, and then click OK
- On the Standard toolbar, click Spelling and Grammar
When Microsoft Word finishes checking spelling and grammar, it displays information about the reading level of the document.
Each readability score bases its rating on the average number of syllables per word and words per sentence.
Flesch Reading Ease score
Rates text on a 100-point scale; the higher the score, the easier it is to understand the document. For most standard documents, aim for a score of approximately 60 to 70.
The formula for the Flesch Reading Ease score is:
206.835 ? (1.015 x ASL) ? (84.6 x ASW)
where:
ASL = average sentence length (the number of words divided by the number of sentences)
ASW = average number of syllables per word (the number of syllables divided by the number of words)
Flesch-Kincaid Grade Level score
Rates text on a U.S. school grade level. For example, a score of 8.0 means that an eighth grader can understand the document. For most documents, aim for a score of approximately 7.0 to 8.0.
The formula for the Flesch-Kincaid Grade Level score is:
(.39 x ASL) + (11.8 x ASW) ? 15.59
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 TestSupport.Microsoft.com:
Frequently Asked Questions About Proofing GrammarSee all Topics
-
January 24, 2006 at 8:01 am #3259294
EXCEL Intro to Excel English Excel The UCL (Un…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Intro to Excel
English Excel
The 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.
The main elements of the course are:
- Analysis of data and treatment of uncertainties of measurement (Data Analysis) – discussed in lectures and illustrated by exercises using Excel
- Use of spreadsheets (Excel) for
- Analysis and presentation of experimental data
- Mathematical modeling, simulation, analysis and problem solving
- Introduction to computer programming by means of Visual Basic for Applications (VBA)
Here are some links to the topics covered topics:
See all Topics
-
January 25, 2006 at 7:59 am #3257523
FRONTPAGE More CSS Can’t get enough Demonstrat…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
More CSS
Can’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.”
See all
Topics
-
January 26, 2006 at 7:56 am #3109782
OUTLOOK BCC, not your old CC Avoid header spaghe…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
BCC, not your old CC
Avoid header spaghetti
There are three parts to the Address section of an email message:- To:
- CC:
- BCC:
CC used to stand for Carbon Copy, but no one knows what carbon paper is anymore so it is now referred to as Complimentary Copy.
BCC is for a blind copy. Recipients will not see that stringy pasta list of names.
Here are a few links to more information.
About.com:
Sending an Email to Multiple Recipients – Cc: and Bcc:
Hamra.net:
Use BCC field when addressing mass mailActrix.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 messagesSee all Topics
-
January 27, 2006 at 7:57 am #3258205
ACCESS Toggle Access Object Views Use the keyboa…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Toggle Access Object Views
Use the keyboard
When 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+> and Ctrl+<
shortcut keys.
These shortcuts can be used with tables, queries, forms, reports, and data access pages.
See all Topics
-
January 28, 2006 at 7:54 am #3110048
ADDENDUM Just Say No to Be To be, or no to be …
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Just Say No to Be
To be, or no to be
E-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.”
- John is lethargic and unhappy.
- John is bright and cheerful.
- John appears lethargic and unhappy in the office.
- John appears bright and cheerful on holiday at the beach.
The result may appear wishy washy, but more accurate.
Also see:
[Edited entry from 2/27/2004]
See all Topics
-
January 29, 2006 at 7:55 am #3109434
POWERPOINT Action When You Want It Move it! Her…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Action When You Want It
Move 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.”
Trigger Happy Animations in PowerPoint
By
Kathryn Jacobs
.
(Kathryn has been a PowerPoint trainer and consultant for over 10 years. She is a Microsoft MVP for PowerPoint.)
Also:
Office.Microsoft.com:
Use triggers to create an interactive slide show in PowerPoint
“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.”
Presentations.com:
Combine animation techniques to create stunning PowerPoint slides
By Ellen Finkelstein“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 from2/28/2004
]See all
Topics
-
January 30, 2006 at 7:53 am #3109302
WINDOWS Forgotten Password Still sign on, or not…
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Forgotten Password
Still 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.
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
See all
Topics
-
January 31, 2006 at 8:06 am #3108658
FRONTPAGE Web Magazine The difference between a …
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Web Magazine
The difference between a blog and a magazine is thin.
Here’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.
Steal our code? Copy our content?
ALA’s content is protected by copyright shared jointly by the magazine and its writers, but our source code is freely available to all.”
See all
Topics
-
February 1, 2006 at 8:06 am #3133252
EXCEL Linked Table Problems Lost functionality …
by dklippert · about 18 years, 2 months ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Linked Table Problems
Lost functionality
Have 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
Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access.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
ZDNet.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.
See all
Topics
-
February 2, 2006 at 6:06 am #3134389
WORD Add Captions Programmatically When the proje…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
WORD
Add Captions Programmatically
When the project seems overwhelming
Faced 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.
Fortunately, the Word object model lets you to apply a caption to a selected object. An add-in that does this for you is only a small chunk of code away. The sample add-in accompanying this article demonstrates how to do this. It also demonstrates many other details about working with shapes and images in Word programmatically that are useful to know about.”
Working with Word 2003 Images Programmatically
See all
Topics
-
February 3, 2006 at 10:10 am #3135175
OUTLOOK Flag that Play! Dog ear your email With…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Flag that Play!
Dog ear your email
With RSS entries, I average 500 or more messages a day. Here’s a suggestion about how to tame the problem.“You clear up one problem and delete the e-mail message — and meanwhile six others pop up in your Inbox. Microsoft Office Outlook 2003 can flag messages with priorities, set reminders, and flag messages for follow-up, so that you can glance quickly at Outlook and know immediately what needs to get done first.”
Office.Microsoft.com:
Demo:
Organize your e-mail more easily than ever
See all
Topics
-
February 4, 2006 at 10:06 am #3097003
ACCESS Relationships How it all ties together …
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Relationships
How it all ties together
“Find out how to reap the benefits of data normalization in Access while ensuring that your system provides users with all the information they need. Learn to relate your application’s tables to each other, so that your users can view the data in the system as a single entity. After you define relationships between tables, you can build queries, forms, reports, and data access pages that combine information from multiple tables.”
Relationships: Your Key to Data Integrity in Access 2003
An article from
Informit.com
and
Sams
by
Alison Balter
.Alison is the founder of InfoTechnology Partners, Inc., a computer consulting firm in California. She is a highly experienced trainer and consultant, specializing in Windows applications.
[
Edited entry from 2/26/2004
]See all
Topics
-
February 5, 2006 at 6:11 am #3096822
EXCEL Where have all the bytes gone? Folder size…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Where have all the bytes gone?
Folder size list
You can create a list in Excel of all the folders on a drive and their sizes.
(The credit goes to Peter Beach, an Excel MVP.)- Copy the code and open Excel.
- Press Alt+F11 and, if necessary, on the Visual Basic Editor menu, Insert>Module
- Paste the code.
- You could use Alt+Tab to bring the worksheet forward.
- Go to Tools>Macros and run the Macro named “GetFolderListing“.
It may take a little time to complete.
BTW, if you feel geeky enough, here is a picture of some of the year 2005 MVPs from John Walkenbach’s site.
[Edited entry from 2/23/2004]
See all Topics
-
February 6, 2006 at 10:58 am #3107014
ADDENDUM Indoor/Backyard Battles Testosterone rel…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Indoor/Backyard Battles
Testosterone relief
Wet, rainy, cold weather activity, or just because.
“Always follow the rules! If you got hit in the head by a band but you don’t want to take the 2-minute penalty (for instance), don’t sit there fighting it out. Just suck it up and do the time. No one’s going to have fun if all you guys end up doing is yelling at each other about rules and regulations. Take your time out, and keep in mind that, in the long run, you’re going to have a much better time.
Clean up afterwards. Nobody’s wife (or husband) likes to see rubber bands sitting in the chicken soup she had left simmering on the stove while she went out to buy some more carrots. (“Interesting flavor, honey…”)
Ultimate Guide to Shooting Rubber Bands
Also,
Now you can build your own rubber band machine gun!
“This beauty is a fully functional machine gun with TWELVE rotating barrels and a live action trigger. Loads 12 bands per barrel for a whopping 144 rubber bands that shoot off as fast as you can turn the handle!”
See all Topics
-
February 7, 2006 at 7:02 am #3093163
POWERPOINT Photo Mlange Colorize without Adobe …
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Photo M?lange
Colorize without Adobe
Photoshop is a great program, but sometimes you just want to add a little pizzazz without the hassle.Geetesh Bajaj has once again come up with a “Why didn’t I think of that!” technique.
” Have you ever wanted to fill a picture with a gradient – or another picture in PowerPoint? Have you wanted to blend two pictures in PowerPoint to create a montage?
Transparent montages in PowerPoint
See all
Topics
-
February 8, 2006 at 7:03 am #3132876
WINDOWS Logon Welcome Warning Opening notice Yo…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Logon Welcome Warning
Opening notice
You can write and display your own warning notice (up to 256 characters).
It takes just a little trip into the bowels of the Registry editor.
Go to the Start button.
Choose Run and type Regedit
Hit Enter:
- Registry Key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon - Modify or Create the Value Name
[LegalNoticeCaption] - Data Type:
REG_SZ [String Value] - Value Name:
LegalNoticeCaption - Value Data for LegalNoticeCaption:
[Type the Caption for the Dialog Box]
- Modify or Create the Value Name
[LegalNoticeText] - Data Type:
REG_SZ [String Value] - Value Name:
LegalNoticeText - Value Data for LegalNoticeText:
[Type the Data for the Legal Notice]
Exit Registry
Reboot
Support.microsoft.com:
How to Enable a Warning Logon WelcomeTheElderGeek.com:
Create Legal Notice Logon Dialog BoxWinguides.com:
Legal Notice Dialog BoxSee all Topics
- Registry Key:
-
February 9, 2006 at 7:24 am #3093717
FRONTPAGE Multiple Page Forms When you need more …
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Multiple Page Forms
When you need more than one
You’ve seen them before; web forms that accept input and then take you to another page for more data entry.
Here is a step by step tutorial:This article describes how to create a multipage form in Microsoft Office FrontPage 2003. Each page of the form contains navigation buttons to move to the previous page or the next page. Additionally, the last page of the form contains a Submit button and a Reset button.
Support.Microsoft.com:
How to create a multipage form in FrontPage 2003
See all
Topics
-
February 10, 2006 at 7:05 am #3253718
WORD Booklets Sized and numbered Word 2002+ ha…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
WORD
Booklets
Sized and numberedWord 2002+ has the built-in ability to print booklets with automatically numbered pages.
“If you don’t want to spend money on an add-in, or use VBA; and are willing to do a bit more work yourself, here is the method I use. I’ve produced booklets up to 100 pages long this way, and it works quite satisfactorily for me.”
Word.MVPS.org:
Booklet printing
Microsoft.com/Education:
Create Booklet
RickySpears.com:
Microsoft Word Booklet Templates
“The WordBookletTemplates.zip file contains Microsoft Word templates for 4, 8, 12, 16, 20, 24, 28, and 32 page booklets, with and without page numbers (16 templates in all). I think I developed these with Microsoft Word 97 and I’ve never made any changes to them. They use a series of text boxes that flow from one to the other to get the text where it is supposed to be in the booklet.”
See all
Topics
-
February 11, 2006 at 6:58 am #3077934
OUTLOOK Excel-lent E-mail Outlook, Excel, and VB…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Excel-lent E-mail
Outlook, Excel, and VBA
Ron de Bruin
, Microsoft MVP – Excel, has put together a collection of VBA routines to make Excel e-mail friendly.See if these topics tempt you:
Example Code for sending mail from Excel
- Mail Workbook
- Mail one Sheet
- Mail more than one Sheet
- Mail the Selection or range
- Mail Every Worksheet with Address in cell A1
- Mail sheet or sheets to one or more people
- Mail range or sheet in the body of the mail (Send personalized email)
- Mail a message to each person in a range with Outlook
- Mail a message to each person in a range with CDO (no security warnings)
- Sending a different file to each person in a range with Outlook
- Zip the ActiveWorkbook and mail it with Outlook
- Security (Prevent displaying the dialog to Send or not Send)
Also
Links
to more Excel e-mail informationAlso see:
John Walkenbach:
Sending Personalized Email from Excel
[
Edited entry from 3/4/2004
]See all
Topics
-
February 12, 2006 at 8:07 am #3077670
ACCESS Business Rules!!! … Rules Bean Counting…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Business
Rules!!!… RulesBean Counting Models
Data modeling can be an exhausting, time consuming process. Here are some samples that may establish a starting point.
The website has close to 100 database models for experimentation, practice and examples.
“My intention is to provide a wide range of ‘Kick Start’ Models that anyone can use as a starting-point, and could extend cleanly and logically, with appropriate reference to the Business Rules.
It is not my intention to provide Models that can be used off-the-shelf to meet the requirements of a large commercial organization.
After all, that is one of the things I do for a living !!!
None of the Models is the complete and final solution in its area, but any of them can be added to easily and quickly to meet a specific requirement. The logic in each Model is intended to be correct and to contain the minimum Entities for the area being modeled.”
Barry Williams
– Founder and Principal Consultant.If you’re attempting a “Big Year” list of blogs, you can add
Viewpoint of a Database Analyst: A Database Design Principles Blog
[
Edited entry from 3/5/2004
]See all
Topics
-
February 13, 2006 at 8:11 am #3133593
ADDENDUM That’s the Way I Beleive It’s Sppelled …
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
That’s the Way I Beleive It’s Sppelled
Wrong list
Spelling feels more like art than science. Here’s a site that shows 100 (actually 250) words that are often misspelled.
It also gives you reasons and memory tricks to get it right.
Not all pens and pencils come with spellcheckers.
The “i-before-e” rule has more exceptions than words it applies to.
Dr. Language has provided a one-stop cure for all your spelling ills. Here are the 100 words most often misspelled (“misspell” is one of them). Each word has a mnemonic pill with it and, if you swallow it, it will help you to remember how to spell the word. Master the orthography of the words on this page and reduce the time you spend searching dictionaries by 50%.
Also:
Most Mispronounced
(You mean it’s not “pronounciation”?
That’s what happens when you have Old-timer’s disease.)See all
Topics
-
February 14, 2006 at 8:08 am #3253145
POWERPOINT How to Flash a PPT Show Embed directl…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
How to Flash a PPT Show
Embed directly
Flash shows, in general, are remarkably easy to create.
Rather than try to duplicate complex animation in PowerPoint, you can add a Shockwave Flash Object to your show.Brainy Betty has a video tutorial show the way:
How to insert Flash into PowerPoint
See all
Topics
-
February 15, 2006 at 9:01 am #3254100
WINDOWS Windows Keyboard tricks Mouse-less motio…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Windows Keyboard tricks
Mouse-less motions
Here is a collection of shortcuts for Windows:
Keyboard shortcuts for WindowsOne of the shortcuts is a way to minimize all Windows from the keyboard.
+M
Also see:
See all Topics
-
February 16, 2006 at 8:15 am #3252414
FRONTPAGE Border magic with CSS Consistent forma…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Border magic with CSS
Consistent formatting
Cascading Style Sheets can be helpful in applying dependable format characteristics to web sites. Like Styles, CSS provides a reference point when a certain look is called for.
Stu Nicholls provides directions for “Fluid” borders:“If you resize your browser window you will see that these borders are fluid and stay in shape. Resize the text and they will also stay in shape.”
Even in this static shot, you can see some nice possibilities.
See all
Topics
-
February 17, 2006 at 7:32 am #3091323
EXCEL SpWebSheets No Excel needed Here’s a sit…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
SpWebSheets
No Excel needed
Here’s a site that lets you design and post spreadsheets on the web.
“Keep your records, lists and spreadsheets in one place online. Easily slice, dice and share with others.
With a free account, you can…
- Access your spreadsheets from anywhere
- Share your spreadsheets easily – just email the URL
- Add spreadsheets to your weblog
- FREE storage
See all Topics
-
February 17, 2006 at 11:31 am #3252261
EXCEL SpWebSheets No Excel needed Here’s a site…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
SpWebSheets
No Excel needed
Here’s a site that lets you design and post spreadsheets on the web.
“Keep your records, lists and spreadsheets in one place online. Easily slice, dice and share with others.
With a free account, you can…
- Access your spreadsheets from anywhere
- Share your spreadsheets easily – just email the URL
- Add spreadsheets to your weblog
- FREE storage
See all Topics
-
February 18, 2006 at 8:10 am #3090790
WORD Date an Octothorpe Some more of those thing…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
WORD
Date an Octothorpe
Some more of those things I’m sure I used to know
The keyboard combination of Alt+Shift+D inserts the current date in MS Word and PowerPoint. Ctrl+; (semicolon) does it in Excel and Access.
If you do not like the date’s format, select a different one with Insert>Date and Time and, if you would like to make that permanent, click on the Default button in the lower left corner of the dialog box (in PowerPoint it’s in the lower right corner).
In Excel, Ctrl+Shift +# formats the entry as day-month-year. Ctrl+1 will display the “Format cells” dialog box.
BTW, the “hash, pound or number” sign # is also called an “octothorpe“.
The person who named it combined Octo for the eight points and Thorpe for James Thorpe.
“Bell Labs engineer, Don Macpherson, went to instruct their first client, the Mayo Clinic, in the use of the new (touch tone phone system). He felt the need for a fresh and unambiguous name for the # symbol. His reasoning that led to the new word was roughly that it had eight points, so ought to start with octo-. He was apparently at that time active in a group that was trying to get the Olympic medals of the athlete Jim Thorpe returned from Sweden, so he decided to add thorpe to the end.”
While we’re at it, the “backwards P, Enter mark” ¶ is actually named a “pilcrow“.
The pilcrow was used in medieval times to mark a new train of thought, before the convention of using paragraphs was commonplace.
Also see:
Geek-speak names for punctuation marksWikipedia:
Punctuation[Edited entry from 3/11/2004]
See all Topics
-
February 19, 2006 at 8:09 am #3253015
OUTLOOK Where do you store your Spam? It’s Your …
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Where do you store your Spam?
It’s Your Mess, Clean It Up
Previous versions of Outlook can handle PST files just this side of 2 GB (1.82) and Outlook 2003 can go up to about 20-30 gigs with the new MSUPST format. However, very few administrators are going to allow users to save anywhere near that amount of information.
Outlook 2002/2003, users do have a tool to managing the size of their mailbox from within Outlook:
- Go to the Tools menu
- Select “Mailbox Cleanup“
This dialog includes quick links to find large items of a chosen size and items older than a selected number of days. You can view the size of folders, fine tune AutoArchive and empty the deleted items folder.
[Edited entry from 3/12/2004]
See all Topics
-
February 20, 2006 at 10:39 am #3102074
ACCESS Duplicate Table Structures No need to rei…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Duplicate Table Structures
No need to reinvent
When setting up a database, you may find that there is a table structure in another database that would be appropriate. You could Import the table, but then you have to clear out the useless records.
Here’s an easier way to do it:
- Choose File>Get External Data>Import from the menu bar
- Select the database that contains the tables you want to copy and click the Import button.
- Select the appropriate tables on the Tables sheet
- click the Options button, select the Definition Only option and click OK
.
To export a table definition from your current database to another:
- Select the appropriate table in the Database window.
- In Access 2000 and above, choose File>Export.
(If you’re using Access 97, choose File>Save As/Export, select the To An External File Or Database option) - Click OK.
- Now, regardless of version, select the target database and press Enter
When the Export dialog box appears, select the Definition Only option button and click OK.
See all Topics
-
February 21, 2006 at 6:46 am #3101121
ADDENDUM Half Staff When and how Issued 2/6/06…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Half Staff
When and how
Issued 2/6/06
A Proclamation by the President: Death of Coretta Scott King
A Proclamation by the President of the United States of America
As a mark of respect for the memory of Coretta Scott King, I hereby order, by the authority vested in me by the Constitution and laws of the United States of America, that on February 7, 2006, the day of her interment, the flag of the United States shall be flown at half staff at the White House and upon all public buildings and grounds, at all military posts and naval stations, and on all naval vessels of the Federal Government in the District of Columbia and throughout the United States and its Territories and possessions until sunset on such day. I also direct that the flag shall be flown at half-staff for the same period at all United States embassies, legations, consular offices, and other facilities abroad, including all military facilities and naval vessels and stations.
IN WITNESS WHEREOF, I have hereunto set my hand this sixth day of February, in the year of our Lord two thousand six, and of the Independence of the United States of America the two hundred and thirtieth.
GEORGE W. BUSH
Free notification of Official orders to fly the flag at half staff. Contact mark@petersonflags.com with: “Add to half staff mail list”, in the subject line.
You will be notified when orders are released.
Also:
Veterans Administration:
Guidelines for Display of the Flag
and:
See all
Topics
-
February 22, 2006 at 6:38 am #3103338
POWERPOINT Make Your Own Templates Fit any need …
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Make Your Own Templates
Fit any need
You are not dependent on microsoft for PowerPoint templates. You can create your own for use on special occasions or to share with others.
What is in a Custom Template?
- Slide background
- Slide Layout- which placeholders appear and their positions
- Color Scheme
- Formatting of placeholders
- Formatting of text and bullets
- Slide transition
- Placeholder animations
Jan’s Web Work & Experiments:
Custom TemplatesIndezine.com:
See all Topics
-
February 23, 2006 at 7:33 am #3100624
WINDOWS Stop that balloon! Turn off pop-ups Th…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Stop that balloon!
Turn off pop-ups
There’s a hard way and an easy way.
Sort of hard:
Balloon pop-ups typically appear when new programs and hardware are installed, when disk space becomes limited. If you do not want balloon pop-ups to appear, you can prevent them by setting values in the registry.
- Go to Start>Run, type Regedit
- In the Root list, select HKEY_CURRENT_USER
- Find Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced
- For EnableBalloonTips, the value 2 enables balloon pop-ups and the value 0 disables them.
For Start_NotifyNewApps, the value 1 enables balloon pop-ups and the value 0 disables them.
- Click OK
Note When EnableBalloonTips is disabled,
enabling Start_NotifyNewApps has no effect.Microsoft Developers Network:
http://www.blogger.com/And, sort of easy:
- Right-click the Start button
- Choose Properties
- Choose the tab Start Menu and then the Customize button
- Select the Advanced tab
- Remove the check by “Highlight newly installed programs“
- Then OK your way out
Vic Laurie, Windows Tips and Tricks:
-
February 24, 2006 at 7:34 am #3102123
FRONTPAGE Survey On Line Test the wind electroni…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE
Survey On Line
Test the wind electronically
Surveys can be used to appraise the sentiments of your audience, or just to gather data.
Here is a tutorial about how to use the FrontPage tools.
“Designing surveys is an art unto itself, requiring careful analysis, skill, and an absolute attention to detail. On the other hand, coding or developing a Web page that contains an electronic form that collects the data from a willing participant is often just as arduous.
FrontPage makes developing and publishing a Web form or survey a breeze. Moreover, it doesn’t require that you know any programming or scripting languages that interactively collect and dynamically display results from a database as you will see in this tutorial.”
Creating Online Surveys Using Microsoft FrontPage
by William C. Jeansonne
Also see:
Survey Forms
See all
Topics
-
February 25, 2006 at 9:59 am #3273494
EXCEL Lookup, Down and Sideways A very useful Ex…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
EXCEL
Lookup, Down and Sideways
A very useful Excel feature
Excel does not have “relational” tables like database applications such as Access.
You, however, can make use of database functions including the ability to look up values in a table based on a value.
You could, for instance look up a salesperson’s records based on an employee ID.
All ‘Bout Computers
has an article describing “Lookups”.
Using VLOOKUP, HLOOKUP, INDEX, and MATCH in Excel to interrogate data tables
John Walkenbach
has a book
“Excel 2003 Formulas”
with a 24-page chapter on Lookup functions and other database/list tricks.
Chip Pearson
talks about lookups on his site as well.
Aaron Blood’s
site offers
download files
explaining lookup. See numbers 36, 37, and 44.One of the zipped Workbooks (number 35) Lookup.zip, is a study in lookup methodology.
[
Edited entry from 3/2/2004
]See all
Topics
-
February 26, 2006 at 9:58 am #3271744
POWERPOINT Baaaad PowerPoint How to make truly h…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Baaaad PowerPoint
How to make truly horrendous PowerPoint Slides
Incase you needed any help, here are some suggestions about how to develop really bad presentations.“Of course, there comes a time when the PowerPoint amateur discovers two very dangerous tools indeed. Custom animations and slide transitions have recently been classified by the UN as ‘weapons of mass destruction’ and cited at the War Crimes tribunal in The Hague on more than one occasion. As far as both of these tools are concerned, my advice is the same: pick a style and stick to it.
Potentially there is boredom if every slide element skates in from the right or fades in from the background. It might be tiring for each slide to segue into the next using a diagonal wipe. But if the alternative is a dizzying combination of mismatched zooms, shrinks, checkerboard wipes and pirouettes then boredom is a very small price to pay.”
Slides From Hell
by Ray BlakeFrom a fascinating “e-zine” called
Indezine
published by Geetesh Bajaj.
Also see:PlasticSurgeryDr.com:
Bad PowerPoint Presentations
[Edited entry from3/7/2004]
See all
Topics
-
February 27, 2006 at 10:02 am #3273023
OUTLOOK Change Categories Fit people into the ri…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
Change Categories
Fit people into the right peg hole
Go to View>Arrange by>Current View and select by Category.
You can create a new Category and then just select Contacts and drag them into the right slot.
This technique works with any Outlook item for many Outlook fields, including Private and Company but won’t work on fields that aren’t editable. You can use it to add Categories but not remove them.
- Make sure at least one item has the new field value.
- Create a new view or edit one of the existing group by views to group by the field you want to change
- Apply the view.
- Select one or more items from the other groups and drag them to the new group and drop.
Slipstick.com:
Group BySee all Topics
-
February 28, 2006 at 6:02 am #3088118
ACCESS Composite Keys Multi-Field Keys To quick…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Composite Keys
Multi-Field Keys
To quickly create a multi-field primary key, while in the table’s Design View:
- Hold the Ctrl key and click each field that you want to make up the primary key.
- Choose Edit>Primary Key from the menu bar, or click the Primary Key button on the toolbar
Access creates the composite primary key for you.
University of Texas at Austin:
Primary and Foreign KeysSee all Topics
-
March 1, 2006 at 10:06 am #3088253
ADDENDUM Animal Distractions Get back at your pe…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Animal Distractions
Get back at your pet for . . .
You know those animals are plotting to get you. Why not take the first offensive.
“Cat Attack, the remote control cat exerciser featuring the world’s first Chaos wand, will keep you and your cat entertained for hours on end! The mouse-shaped toy randomly shakes and twirls the Chaos wand, driving your cat wild with a bobbing tassel.
This movement alone will captivate your favorite feline, but there’s one more surprise in store. You hold a wireless remote control that controls the base of the toy. Getting bored? Drive the Cat Attack across the room and watch your cat chase after and pounce on it. Your remote features forward and spin buttons that allow you to drive anywhere you want with a little practice.”
And let’s not forget that conniving dog!
“It’s not necessary for your dog to put the balls back in the bucket to enjoy his GoDogGo ball launcher – you can always reload the bucket yourself. In fact, most Go Dog Go-addicted dogs have never been trained to do it and still love playing with GoDogGo. However, with just a little training (helpful tips are included with each Go Dog Go,) your dog can learn to put the balls back in the bucket for continuous play with GoDogGo.”
Thanks to BookofJoe.com for the ideas.See all Topics
-
March 2, 2006 at 10:29 am #3087508
WINDOWS Change Your Name Change your company Ev…
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
WINDOWS
Change Your Name
Change your company
Ever work at a computer that had been assigned to someone else in the past and be bothered by seeing their name pop up all the time?
You can take charge of your own life!
- Go to the Start button and open up the Control Panel
- Select User Accounts and click on the account that you wish to Change
- Click the “Change my name” option
Another way is to:
- Go to Start>Run
- Type: regedit
- Find:
HKEY_Local_Machine\Software\Microsoft\WindowsNT\Current Version - On the right pane, look for ‘RegisteredOwner’
- Right click the RegisteredOwner key to edit it
- Right click the entry and select Modify
- You could also change the RegisteredOrganization.
See all Topics
-
March 3, 2006 at 8:01 am #3089873
POWERPOINT Quote Me All You Want What the other …
by dklippert · about 18 years, 1 month ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
Quote Me All You Want
What the other guy says has weight
There are sites that give you
Bartleby Quotations
.Gar Reynold has put together a list of some other sites that can help bolster any argument, no mater how specious.
“In my presentations, I may have several slides which feature a quote from a famous (sometimes not so famous) individual in the field. The quote may be a springboard into the topic or serve as support or reinforcement for the particular point I’m making. A typical Tom Peters presentation at one of his seminars, for example, may include dozens of slides with quotes. “I say that my conclusions are much more credible when I back them up with great sources,” Tom says.”
PresentationZen.blogs.com:
Where to get quotations
“Computers are useless. They can only give you answers.
Pablo Picasso”See all
Topics
-
March 4, 2006 at 7:23 am #3088997
FRONTPAGE/INTERNET Kahanamoku Keyboard Surfboard…
by dklippert · about 18 years ago
In reply to Unofficial Microsoft Office Stuff
FRONTPAGE/INTERNET
Kahanamoku Keyboard
Surfboard – Keyboard
People ask you how to increase the font size in Internet Explorer?
“Oh, well, go to View>Text size and pick one between Largest and Smallest.”
Here’s another way:
- Resize Text Size IE
- Hold down CTRL key and move the wheel on the mouse.
The page text will enlarge or shrink.
Here are some others from Penn State University
- Quick jump to Web Site IE
- Type just the Internet domain name in the URL Address field and hold down CTRL+ENTER keys.
This will fill in www as the machine name and add .com - Presentation Mode IE
- Select the F11 function key to enter Presentation mode (full screen).
Select the F11 function key to toggle back. - Page forward and back IE
- Hold down SHIFT key and move the wheel on the mouse.
This will page forward or backward through the pages selected. - Page scroll using mouse wheel button IE
- Push down on the mouse wheel button and slide the whole mouse up and down.
This will page up and down the screen. - Open a New IE Window with One Click
- Hold down SHIFT and click on the link.
A new IE browser window will appear. - Page forward and back using arrow keys IE
- Hold ALT button and use the arrow keys to page forward and back.
- Get to Your Favorites with Keyboard Shortcut IE
- Enter CTRL+I will bring up your left pane favorites.
Enter CTRL+I will make it disappear
Enter CTRL+B to organize your favorites
Duke Paoa Kahanamoku (1890-1968) is called the Father of Modern Surfing. There were others before him, such as George Freeth, who died in 1919, but Duke is the most widely known.
[Edited entry from 3/1/2004]
See all Topics
- Resize Text Size IE
-
March 6, 2006 at 7:38 am #3084770
WORD ALT Select Old trick This trick has been …
by dklippert · about 18 years ago
In reply to Unofficial Microsoft Office Stuff
WORD
ALT Select
Old trick
This trick has been around for awhile, but it might be forgotten as new information in the right ear shoves old knowledge out the left.*
If you hold down the ALT key while selecting in a Word document, you can select a block. This could be a vertical area, such as the prefixes of a list.
The selection can then be formatted or deleted.
*Also see Michael Feldman’s “Something I Said:
“Innuendo and Out the Other”
“See all
Topics
-
March 7, 2006 at 7:02 am #3085890
OUTLOOK 4-1-9 Nigerian Advance Fee Fraud The Ad…
by dklippert · about 18 years ago
In reply to Unofficial Microsoft Office Stuff
OUTLOOK
4-1-9
Nigerian Advance Fee Fraud
The Advance Fee Fraud (AFF) is known internationally as “4-1-9” fraud after the section of the Nigerian penal code which addresses fraud schemes.
(BTW, it is pronounced 4-1-9, not four-nineteen.)
You’ve most probably been approached via email to help some poor soul smuggle millions out of some war torn province in return for a generous finder’s fee.“A renowned psychiatrist from UC Irvine was duped into squandering at least $1.3 million of his family’s fortune on a Nigeria Internet scam, according to a lawsuit recently filed by his son.
The son, also an Orange County doctor, said his father – Dr. Louis A. Gottschalk – gave as much as $3 million over a 10-year period in response to an Internet plea that promised the doctor a generous cut of a huge sum of cash trapped in African bank accounts in exchange for money advances.
Gottschalk – who at 89 still works at the UCI campus medical plaza that bears his name – said in court papers that the losses were caused by “some bad investments.”
Guy Gottschalk is asking a judge to remove his father as administrator of the $8-million family partnership that was set up for tax purposes after the death of his mother in 1993. A hearing is set for March 14.
The suit alleges that Louis Gottschalk destroyed bank records to cover up the amount of his losses.
“While it seems unlikely, even ludicrous, that a highly educated doctor like [Gottschalk] would fall prey to such an obvious con, that is exactly what happened,” wrote Guy Gottschalk’s attorney in court papers.”
If your willing to take the risk, here is a site that baits the scammers.See all
Topics
-
March 8, 2006 at 7:13 am #3086863
ACCESS Crosstab Query Column Headings Using Mont…
by dklippert · about 18 years ago
In reply to Unofficial Microsoft Office Stuff
ACCESS
Crosstab Query Column Headings
Using Month Numbers
If you display a crosstab query as a datasheet, consider using a month’s or day’s number as a column heading instead of a text abbreviation (e.g., 1 instead of Jan or January, or 2 instead of Mon).
Text abbreviations are sorted alphabetically. Apr appears before Feb, Mon appears before Sun, etc. Number representations will sort in their proper order.
See all
Topics
-
March 9, 2006 at 7:23 am #3084377
ADDENDUM Extreme Tweaks Learn by example When …
by dklippert · about 18 years ago
In reply to Unofficial Microsoft Office Stuff
ADDENDUM
Extreme Tweaks
Learn by example
When you realize that tattoos are only skin deep.
“Some people may look at this website, browse through the portfolios, and come to the conclusion that they want to become part of Steve’s art. Some others may immediately decide that they don’t like what they see. They may be offended or horrified by the subject matter, by the form that Steve’s art takes, by the extreme individualism exhibited herein.
So one person’s idea of body modification is going to be a pierced ear lobe, and another person’s idea of body modification is to look like the el Diablo himself. Just because you don’t agree doesn’t make it wrong.”
Here’s one of Steve’s clients:
“Stalking Cat”See all
Topics
-
March 10, 2006 at 7:30 am #3266929
POWERPOINT High Level Presentation Tips More tha…
by dklippert · about 18 years ago
In reply to Unofficial Microsoft Office Stuff
POWERPOINT
High Level Presentation Tips
More than just a PPT tutorial
Garr Reynolds is currently Associate Professor of Management at Kansai Gaidai University where he teaches Marketing, Global Marketing and Multimedia Presentation Design.
His web site demonstrates more than just how many slides to show in 15 seconds.
There are tutorials and demonstrations covering:
- Organization and preparation
- Delivery and
- Slide tips
Garr quotes Tom Peters:
“. . . presentation skills are worthy of extreme obsessive study.”
See all Topics
-
April 15, 2006 at 7:27 pm #3287051
TechRepublic gets stuck
by dklippert · about 17 years, 11 months ago
In reply to Unofficial Microsoft Office Stuff
The latest entries on my Blog have not been posting here.
-
May 22, 2006 at 2:21 pm #3147969
Art and Words
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
One picture can mess up a thousand words
Linda Johnson
has put together a well laid out basic tutorial about combining text and graphics on a page.
Aligning Text and Graphics in Word
I might have added “Edit Wrap Points“; a feature that allows more control over how text wraps around a picture. Also the use of Format>Picture from the menu. The Layout tab on the dialog box has an Advanced button. The Advanced Layout section presents more precise layout choices if needed.
Linda dismisses the Drawing Canvas that pops up in Word 2002+. I think she is correct, in most situations.
For more information on the “DC” see:
Drawing Canvas – More than I want
[
Edited entry from 3/20/2004
]See all
Topics
-
May 22, 2006 at 2:21 pm #3147970
Netiquette – Etiquette
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Why do you need email etiquette?
A company needs to implement etiquette rules for the following three reasons:
- Professionalism: by using proper email language your company will convey a professional image.
- Efficiency: emails that get to the point are much more effective than poorly worded emails.
- Protection from liability: employee awareness of email risks will protect your company from costly law suits.
If you need to formulate a policy for your company, here are some suggestions:
32 of the most important email etiquette tips
E-mail Etiquette (Netiquette) — Chris Pirillo
[Edited entry from 3/28/2006]
See all Topics
-
May 22, 2006 at 2:21 pm #3147971
Automatically set up Database
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Link in a snap
When you’re creating a new database that will link to data that isn’t in an Access format, you can speed up the setup process.
Rather than creating a new database and then using the File>Get External Data>Link Tables,
- Choose File>Open from the menu bar
- Select the appropriate data format from the Files Of Type dropdown list
- Open the file as you would any Access database
Access will automatically create an MDB file with the same name as the data source you selected and will set up links to the data.
See all Topics
-
May 22, 2006 at 2:21 pm #3147962
Map Yourself
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Make your own
You know you’ve wanted to play with Google maps on your own. It’s not super easy, but here’s a description about how to do it.
“One of the great things about Google maps is it has its roots in XML. To translate for the non-web developers out there, it basically means Google maps are user hackable.
This how-to will show you how to make your own annotated Google map from your own GPS data. Plus, you’ll be able to tie in images and video to create an interactive multimedia map.
We’ll walk you through the steps we took to generate an annotated map of a walk we took recently through our hometown, now that it’s actually starting to get warm enough to want to walk about!”
Make your own annotated multimedia Google map
Also:
gmaptrack.com
“gmaptrack allows you to create and place your own information onto Google Maps, and share with others.”See all
Topics
-
May 22, 2006 at 2:21 pm #3147963
Getting Started
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
PowerPoint and FrontPage
These two applications have presentation as a common core. Both use content and form to communicate information.Cynthia D. Hollingsworth is the Coordinator of Instructional Design for the IU School of Nursing located in Indianapolis, Indiana, on the campus of Indiana University-Purdue University Indianapolis. She has put together a couple of first stage tutorials that can help as startup material, or as a refresher course.
See all
Topics
-
May 22, 2006 at 2:21 pm #3147964
Frequent Problems
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Windows answers
John Barnett has a nice site with over 100 good WinXP solutions.
“The Windows XP frequently asked questions section contains some of the more popular tips/tweaks. Obviously, this section will be updated pretty regularly so do keep visiting to check what new FAQ’s have been added. All FAQ replies are supplied ‘as is’ I am unable to accept any responsibility resulting from the use of any of the FAQ replies. You use them at your own risk!’
Here’s a sample:
- How Do I Enable Show Hidden Files and Folders
- How Do I Get XP To Empty The Temporary Internet File Folder When My Browser Closes (UPDATED)
- How Do I Hide Icons In The Notification Area
- How Do I Add/Remove ‘Supplied By
From Internet Explorer Title Bar - How Do I Replace a lost, broke or damaged Windows XP CD
- How Do I Delete An Undeletable File
- How Do I Create A Desktop Shortcut To The Windows Disk Defragmenter
- How Do I Enable Single Clicking Of Icons To Open An Application
- How Do I Disable The Windows XP Splash Screen
- How Do I Change The Default Location Of The My Document Folder
- How Do I Backup The Registry In Windows XP
See all Topics
-
May 22, 2006 at 2:21 pm #3147965
World’s a Web
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Join the group
Daniel Will-Harris is a designer and author. He has put together a web site with step-by-step instructions about how to set up your own web site.
” Everyone and their dog needs to build a web site these days. But even with the best software there’s all sorts of stuff a mammal has to understand before it can create a truly useful site.
eFuse.com offers information, inspiration, and assistance written in plain English by professional writers and designers so it’s easy to understand and use. eFuse.com is for everyone who wants to build a more attractive and effective web site. Learn what you need, painlessly. No experience necessary. You’ll be web-savvy in no time.Take a look at the site map.
eFuse.com:
Site Map
Learn how to Plan, Design, Build and Grow your web site
See all
Topics
-
May 22, 2006 at 2:21 pm #3147966
Julian Dates
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Gregorian to/from Julian
Julian dates refer to the number of days from the first of the year and the number of days until the end of the year.The year -45 has been called the “year of confusion,” because in that year Julius Caesar inserted 90 days to bring the months of the Roman calendar back to their traditional place with respect to the seasons. This was Caesar’s first step in replacing a calendar that had gone badly awry. Caesar created a solar calendar with twelve months of fixed lengths and a provision for an intercalary day to be added every fourth year. As a result, the average length of the Julian calendar year was 365.25 days.
The Gregorian (Pope Gregory XIII) calendar is based on a cycle of 400 years, which comprises 146,097 days. Since 146,097 is evenly divisible by 7. Dividing 146,097 by 400 yields an average length of 365.2425 days per calendar year, which is a close approximation to the length of the tropical year. The Gregorian calendar accumulates an error of one day in about 2500 years.
From Chip Pearson’s site CPearson.com:
“Many applications (especially mainframe systems) store dates in the Julian format, which is a 5-digit number, consisting of a 2-digit year and a 3-digit day-of-year number. For example, 24-August-1999 is stored as 99236, since 24-August is the 236th day of the year. Excel does not support Julian dates directly, but you can use them with only a few fairly simple formulas.
Converting A Standard Date To A Julian Date
The formula below will convert a standard Excel date in A1 to a Julian Date.
=RIGHT(YEAR(A1),2)&TEXT(A1-DATE(YEAR(A1),1,0),"000")
This formula takes the 2 right-most characters of the YEAR of the date in A1, and then appends the number of days between the date in A1 and the 0th day of that year. The TEXT function formats the day-of-year number as three digits, with leading zeros if necessary.
Converting A Julian Date To A Standard Date
The formula below will convert a Julian date to a standard Excel date.
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3))
If the year digits of the Julian date are less than 30 (i.e., 00 to 29), the date is assumed to be a 2000 century year. If the year digits of the Julian date are greater than or equal to 30 (i.e., 30 to 99), the date is assumed to be a 1900 century year. This formula works by taking advantage of the fact that the DATE function can handle days beyond the “normal” days in a month. For example, DATE correctly computes 100-Jan-1999 to be 10-April-1999.
These Julian dates must have the leading zero or zeros for years between 2000 and 2009. For example the 123rd day of 2000 must be entered as 00123. Format the cell as TEXT before entering the data, or enter an apostrophe before the Julian date — e.g., ‘00123. This will prevent Excel from treating the Julian date as a number and suppressing the leading zeros.”
US Naval Observatory has this definition (and a calculator):
Julian dates (abbreviated JD) are simply a continuous count of days and fractions since noon Universal Time on January 1, 4713 BCE (on the Julian calendar). Almost 2.5 million days have transpired since this date.
April 29, 2004 at 6:00 AM would be 2453854.75
[Edited entry from 3/27/2004]
See all Topics
-
May 22, 2006 at 2:21 pm #3147967
SQL Warning in Word
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Merge Ahead!
When you open a Word 2003 mail merge main document that is linked to a data source, you may receive the following message:
Opening this will run the following SQL command:
SELECT * FROM C:\file_name.logData from your database will be placed in the document. Do you want to continue?
This message helps protect you from unintentionally sending data to a malicious user.
To suppress this message, you must first create the following registry key:- Open Registry Editor.
- Locate, and then click the following registry key:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Word\Options
- Click Edit, point to New, and then click DWORD Value.
- Under Name, type:
SQLSecurityCheck
- Double-click SQLSecurityCheck.
- In the Value data box, type:
00000000
Installing Office XP SP3 appears to cause the same problem.
For Word 2002 (XP also known as 10.0) you need to place the registry key in:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Word\Options
(Thanks to Brian Livingston at WindowsSecrets.com for pointing the way to a solution)
[Edited entry from 3/29/2004]
See all Topics
-
May 22, 2006 at 2:21 pm #3147968
Resend on behalf
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Alternate to Forward
Let’s say you get a message that you would like to forward, but you don’t necessarily want to take “ownership.”
- Open the message in its own window
- Go to Actions>Resend This Message
- When you click Send, you will be reminded that you are not the original sender of the message
- Click OK
The message will be from you, “on behalf of” the original sender.
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.comSee all Topics
-
May 22, 2006 at 2:21 pm #3147955
VBA Variable Problems
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Explicit protection
It’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.
- Open a module (start the VBA Editor)
- Choose Tools>Options from the menu bar
- On the Editor tab of the Options dialog box, select the Require Variable Declaration check box in the Code Settings panel
- Finally, click OK
See all Topics
-
May 22, 2006 at 2:21 pm #3147956
Dead yet?
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Approximate your last breath
Let 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 is planning a 100 year reunion September 15. 2006.
Of the 38,797 graduates, 24,176 or 62% could still be alive.Maybe you saw the movie:
10 Things I Hate About You
See all
Topics
-
May 22, 2006 at 2:21 pm #3147957
Scripts you can use
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
DHTML, Javascripts, PHP
Dynamic Drive provides original DHTML & Javascripts to enhance your web site.
There is an extensive collection as evidenced by this TOC.
- Calendars
- Date & Time
- Document Effects
- Dynamic Content
- Form Effects
- Games
- Image Effects
- Links & Tooltips
- Menus & Navigation
- Mouse and Cursor
- Scrollers
- Text Animations
- User/System Preference
- Window and Frames
From DynamicDrive.com
See all Topics
-
May 22, 2006 at 2:21 pm #3147958
Clip Art at home
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Install more
Do 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 with 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 includes 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.
The Office XP Media Content CD contains approximately 35,000 clips that are a subset of the clips that are available on the Microsoft Office Online Clip Art and Media Web site. The Office XP Media Content CD was included with Microsoft Office XP Professional, Microsoft Office XP Standard, and Microsoft Publisher 2002 Deluxe Edition.
To install the contents of the Office XP Media Content CD on a computer, follow these steps:
- Exit all programs that are running
- Insert the Office XP Media Content CD into the CD drive or into the DVD drive
(Hold down the SHIFT key to prevent the program from automatically starting. If Microsoft Windows Installer automatically starts, click Cancel) - Click Start, click Run, type the following command, and then click OK:
msiexec.exe /i CD_drive:\CAG.MSI ADDLOCAL=ALL /qb
(CD_drive is the letter of the drive that contains the Office XP Media Content CD)
Support.Microsoft.com
How to add clip art to Clip Organizer in Office 2003See all Topics
-
May 22, 2006 at 2:21 pm #3147959
Presentation Prep
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Review before you’re reviewed
Things to keep in mind as you prepare your presentation.
From Scott Hanselman’s blog:
- Speak their Language (Know the Audience)
- Be Utterly Prepared (No excuses)
- CONTENT, CONTENT, CONTENT (Have some)
- System Setup (Be unique, but don’t be nuts)
- Speaking (Um …)
- Accessibility (Two words: Font Size, and this means YOU!)
- Demos and Tools
You’ll find the full suggestions here:
Tips for a Successful MSFT Presentation[Edited entry from 3/24/2004]
See all Topics
-
May 22, 2006 at 2:21 pm #3147960
Zoom, Zoom, Zoom
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Up 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.
ZoomIn is a very simple program to use. Place your mouse over the main window and click and hold the mouse button then drag the “zoom” window over the area of the screen to enlarge. The scrollbar controls the zoom amount.
As an alternative to using a mouse, you can use the arrow keys to scroll the “zoomed” view, and the plus and minus keys control the zoom. Once you have selected the area of the screen, release the mouse button.
By placing your cursor over the pixel in ZoomIn you can see the pixels coordinates as well as the color (in RGB format).
Some of the other free programs on the site are:
- Briscola
- a very famous Italian card game. Play against the computer in this one-on-one card game. There is included help with the rules of the game, for those who have never played Briscola before.
- Dropper
- allows you to get the exact color of any pixel on the screen and converts it to commonly used representations.
[Edited entry from 3/25/2004]
See all Topics
-
May 22, 2006 at 2:21 pm #3147961
Find Word Folders
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Location locator
There are other ways to do it, but you may find this little program of some use.
WordCriticalFolders.exe (not a Word macro), Automatically find certain Word folders.
This file itself is NOT a macro, but may be helpful to those installing macros at times. For instance, it will find your Startup folder and your Template folder for Word and display the full path for you.
These files can be in different locations depending upon your OS.
You are able to print the results, as well.
See all
Topics
-
May 22, 2006 at 2:21 pm #3147948
Mail your MDB
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Don’t let Outlook stop you
There was a lot of frustration with Outlook 2003. 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 2003, Outlook 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:
- Run Regedit, and go to this key:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Security
(change 10.0 to 9.0 for Outlook 2000 SP3 or to 11.0 for Outlook 2003)
- Under that key, add a new string value named Level1Remove.
- For the value for Level1Remove, enter a semicolon-delimited list of file extensions. For example, entering this:
.mdb;.url
would unblock Microsoft Access files and Internet shortcuts. Note that the use of a leading dot was not previously required, however, new security patches may require it. If you are using “mdb;url” format and extensions are blocked, add a dot to each extension.
Note also that there is not a space between extensions.
If you are using this registry entry, a glance at Help>About Microsoft Outlook will show Security Mode: User Controlled above the license information.
After applying this registry fix or using one of the above tools, the user still has to save the attached file to a system drive before opening it. In effect, the fix rolls the attachment behavior back to Outlook 2000 SR-1, with its included Attachment Security Fix.
An end-user cannot bypass this “save to disk” behavior and open the file directly from the mail message, though an Exchange administrator can.
Slipstick.com:
Opening .exe AttachmentsSee all Topics
- Run Regedit, and go to this key:
-
May 22, 2006 at 2:21 pm #3147949
Compact before Synchronizing
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
A DB two step
If 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.
See all
Topics
-
May 22, 2006 at 2:21 pm #3147950
Paper Skyscrapers
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Fold your own steamship
This 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.
Each model was made up of several small cards illustrated with the pieces of the model, all wrapped up in a label. You could cut the pieces out and carefully assemble an intricate little three-dimensional model.
Micromodels were known for the amazing details that people would add to customize their models. There were more than 100 original Micromodels of all types.
See all
Topics
-
May 22, 2006 at 2:21 pm #3147951
Exploding Slides
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Break up or Blow up
Kathy 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.
We are going to step through blowing apart pictures, but this same idea can be used for expanding organization charts, process diagrams, and all kinds of other elements.”
See all
Topics
-
May 22, 2006 at 2:21 pm #3147952
30 days hath …
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
One Day at a Time
Here’s how to add a calendar to your web page.
Publishing Outlook Calendars on the Internet or an Intranet
(From THE definitive Outlook/Exchange site – Slipstick.com.)Other methods:
Htmlgoodies.com
It’s actually just a simple table with a couple of additions. (free)Calendarserver.com
CalendarServer.com is a free service for anyone to publish event schedule information in a monthly calendar view without any tedious HTML work. (free)HTMLCal
HTMLCAL is a Web calendar maker and editor that lets you maintain a group calendar for your Web site or intranet.
This software will let you maintain live calendars on your site that anyone can view or update from any Web browser. ($25)Htmlcalendar.com
HTML Calendar Maker Pro was designed with ease of use in mind. Now you can type your events quickly and easily and they will be transformed into a customized and professional monthly calendar within seconds. Simply follow the on-screen tutorial to create your calendar and then place the finished web page on your site. It’s perfect for planning for the weeks ahead or noting past historic events. ($26.50 +)All about Calendars by:
[Edited entry from 3/28/2004]
See all Topics
-
May 22, 2006 at 2:21 pm #3147953
Access Tools for Free or Fee
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Shareware/Freeware
Peter 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.
Using ShrinkerStretcher means you can develop applications without concern for your end user’s display settings! Scale your 800×600 application down to 640×480, or to any other screen resolution!
For free includes:
- ChromaForm
- Let your users set their own form color schemes.
- Custom Time Functions –
- Perform mathematical operations on custom time values that include fractions of a second.
- TableLinker
- Manage linked tables from multiple databases, ODBC sources, or any combination of the two. Easily refresh table links or connect to tables in a different data environment.
[
Edited entry from3/30/2004
]See all
Topics
-
May 22, 2006 at 2:21 pm #3147954
Thirtieth Condition Formating
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Three is not always enough
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
See all
Topics
-
May 22, 2006 at 2:21 pm #3147943
Word Converters
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Pick a flavor
There 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.
- Web page
- Web page, Filtered
- Web Archive
- Plain Text
- Encoded Text
- Rich Text Format (RTF)
- XML
- Recover Text (import only)
The following text converters are set to the Run from My Computer installation state.
- Word 97-2003 & 6.0/95 RTF Converter
- Recover Text Converter
- Word 97 for Windows/Word 98 Macintosh
The following text converters are set to the Installed on First Use installation state
- WordPerfect 6.x Converter
- WordPerfect 5.x Converter
- Microsoft Works for Windows 7.0
Support.Microsoft.com
Description of the text converters that are available with Word 2003See all Topics
-
May 22, 2006 at 2:21 pm #3147944
Font Change Email Sig
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Correct the error
If you use Word to edit your email, you might have stumbled on the problem of “sticky” fonts.
You change the signature font to Trebuchet – Red, but it still displays Times New Roman -Black.
When you create a signature in Microsoft Outlook, the signature does not retain the font or the color that you specified.
Here’s how Microsoft suggests you fix the glitch.
- Create a new e-mail message in Outlook. The new e-mail message should open in Word.
- On the Tools menu, click Options.
- Click the General tab.
- Click Web Options.
- Click the Fonts tab.
- In the Proportional font box, click to select a font other than Times New Roman.
- Click OK to close the Web Options dialog box.
- Click OK to close the Options dialog box.
- Close the new e-mail message and exit Word.
When you create a signature in Outlook, the font and color that you specify should now be saved.
You can now set the font in the Proportional font box to Times New Roman.
Support.Microsoft.com:
A signature does not retain the font or the colorSee all Topics
-
May 22, 2006 at 2:21 pm #3147945
Watermelon Pickles
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Actually quite good
- Cut a watermelon into slices (for best results, use a melon that’s not overly ripe).
- Cut the rind off the pink portion and cube the flesh.
- Soak the watermelon cubes overnight in brine made by dissolving 2 Tbsp. of pickling salt in 1 qt. water.
- In the morning, drain the brine off the melon cubes.
- Put a dill head and stem (or a couple of teaspoons of dill seed) in each quart jar. If you desire, also add a hot pepper (chili) and whole allspice and/or mixed pickling spice to each quart.
- Bring to a boil 1 cup white vinegar, 2 cups water, and 1/2 to 1 cup granulated sugar (try the smaller amount first and increase the amount if you decide you like your watermelon pickles sweeter).
- Pour the pickling solution boiling hot over the melon in the jars, filling them to 1/2 inch of the top of the jars.
- Wipe the rims and seal the jars with sterilized lids and rings.
- Process in a boiling water bath for 15 minutes, just long enough so the contents won’t ferment. (If you process the pickles too long, they will be too soft.)
Here’s the Volga Deutsch site:
See all Topics
-
May 22, 2006 at 2:21 pm #3147946
Keyboard Mobility Options
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Other methods
There are a myriad of reasons that it is good to know alternate means to work Windows.
Alan Cantor has a booklet available, and there is a lot of practical information in his FAQ and a section on macros.
To drive Windows from the keyboard, it is more important to internalize techniques than it is to memorize hotkeys. Once these techniques have been mastered, it is possible to perform almost all tasks in Windows – perhaps 98% – without a mouse.
Some people have no choice but to learn mouseless techniques. For example:
- Individuals who are totally blind cannot see the mouse pointer, and therefore cannot use a mouse.
- People who are deaf and blind cannot use a mouse, either. Most deaf and blind individuals use a standard keyboard, but “read” the screen using a hardware device called a refreshable Braille display.
- Individuals who have low-vision may be able to discern an enlarged mouse pointer, but finding and identifying targets may be visually taxing. In many situations, pressing two or three keys is easier and more reliable than reaching for the mouse.
- Users with upper-body mobility impairments, including one-handed typists, toe-typists, and people with dystonia and cerebral palsy, may also find it awkward to point and click. The same is true for individuals who access PCs via mouthstick, headstick, or similar appliance.
- Pointing and clicking may be difficult for people with musculoskeletal injuries.
- People who have learning disabilities that affect hand-eye coordination may also find it easier to perform certain tasks by keyboard.
- When users develop temporary disabilities or are injured – for example, a broken arm, dislocated shoulder, or tennis elbow – the ability to use the mouse may be compromised, and a few keyboard techniques can be beneficial.
- Older users and children sometimes have difficulties controlling a mouse for certain tasks. Double-clicking is especially difficult for some individuals.
Finally, anyone who wants to work quickly and with fewer errors can benefit from knowing a few keyboard “tricks.” Many tasks that require precise mouse movements and accurate clicking can be done by pressing one or two keys on the keyboard. For reasons of efficiency, speed, and directness, power users often prefer using the keyboard to the mouse.
See all Topics
-
May 22, 2006 at 2:21 pm #3147947
666
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
The Devil is in the Details
Try to follow the 666 rule when developing a presentation.
- There should be no more than six words in each bullet point
- No more than six bullet points per slide.
- No more than 6 text slides without a graphic
(The last point was just included to make it 666)
If you find that you have too much text on a slide, you could cut and paste or fiddle around with the Outline pane; demoting or promoting items.
You could use one of the AutoFit Options.
When the text overflows the text placeholder, with AutoFit turned off, if you click inside the text, the AutoFit Options button will appear, usually on the lower left side of the text box.
The AutoFit Options button looks like two horizontal lines with an arrow above and below pointing towards the two lines.
When you click on the AutoFit Options button, you will see a sub-menu.
One of the options on this sub-menu is Split Text Between Two Slides.
Click on this option and PowerPoint will split the text you have typed into two slides automatically.
It tries to split the text evenly between the two slides so that each slide can have as large a font as possible.
It will leave the same title on the new slide.
[Edited entry from 3/31/2004]
See all Topics
-
May 22, 2006 at 2:21 pm #3147936
Digital Dashboard
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Beep, Beep
Here is a way to have Outlook/Explorer display information from internal and outside sources.
Here are some sites that have information and some suggestions-tools-code-samples to fiddle around with in your own Dashboard setup.
Three Ways To Create a Digital Dashboard and Add a Web Part
This article introduces you to digital dashboards and Web Parts. It presents the steps necessary to create a digital dashboard by using the Digital Dashboard Resource Kit, Microsoft Office XP Developer, and Microsoft SharePoint Portal Server. This article also demonstrates how to add existing Web Parts to a digital dashboard and create a custom Web Part.
Also see:
Creating Dynamic Digital Dashboards
[
Edited entry from 4/7/2004
]See all
Topics
-
May 22, 2006 at 2:21 pm #3147937
CSS, PHP, and all that stuff
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Collections of suggestions
Under 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.
Also:
Links and Discussion About the Best CSS Resources Available on the Web.
CSS Help Pile
See all
Topics
-
May 23, 2006 at 8:18 am #3146966
Make the Office Assistant Dance
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Make up your own advice
Clippy is a dying breed. He probably will not be in Office 12.
In Office 2003, if you installed him, the on/off switch is on the Help menu.
It is relatively easy to program the Office assistant to say what you want and to move the way you want.
There are only a few properties
- Heading
- Specifies the bold text appearing at the top of the Office Assistant balloon.
- Text
- Specifies the text appearing in the body of the Office Assistant balloon. This text appears after the heading but before any check boxes, labels, or buttons.
- Labels
- Returns the collection of labels in the balloon. The format of the labels is determined by the BalloonType property. Labels appear after the balloon text. The list of labels can be numbered or bulleted, or a list of buttons. Unlike check boxes, the user’s choice is registered as soon as a button is clicked.
- CheckBoxes
- Returns the collection of check boxes in the balloon. The user selects the check box and clicks the appropriate button at the bottom of the balloon (for example, OK or Next) to register his or her choice.
- Close
- Closes and dismisses a modeless balloon, but doesn’t release the object variable. The object variable assigned to the balloon is still valid – you can display it again, or you can modify it and display it later. You can use this method only on modeless balloons.
- Show
- Displays the balloon, and all the objects inside it, to the user. Use this method only for Balloon objects; use the Visible property for the Assistant object.
Overview of the Office Assistant
See all Topics
-
May 24, 2006 at 8:13 am #3147761
Redact Fails
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Erased not marked through
If you tried the Microsoft add-in that allowed you to edit documents like the CIA. You might have found that it didn’t work as promised.
When you mark text for redaction in Microsoft Office Word 2003, the text is deleted from the document instead of being redacted.This issue may occur if you installed the Word 2003 Redaction Add-in version 1.1 and then installed the Microsoft .NET Framework 2.0.
The latest version is 1.2:
Word Redaction v1.2
.
(5/2/2006)
Also see:
Redact That!
See all
Topics
-
May 25, 2006 at 8:34 am #3146549
Get Hooked up
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Link to apps in Outlook
The 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
See all
Topics
-
May 26, 2006 at 8:14 am #3155252
Customize Shortcut Menus
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Access, Word, PowerPoint
The shortcut menu that’s displayed when you right-click your mouse provides quick access to actions that are relevant to the object you click on. But, it’s often likely that the shortcut menu is lacking a selection that you feel would make working easier.
Fortunately, it’s easy to customize shortcut menus to your liking. To do so, right-click on any visible toolbar and choose Customize. Then, click on the Toolbars tab and select the Shortcut Menus check box.
A toolbar that contains menus for major work environments within Access, such as Database, Query and Module. Text, Table, Draw for Word. Text, Table, Draw, Slide Show in PowerPoint.
(How to customize menus and menu bars in Excel )
Now, click on the Commands tab and scroll through the Categories and Commands list boxes to locate the command you want to add. Then, click and drag the command up to the appropriate menu and submenu on the Shortcut Menus toolbar.
For example, let’s say that you want to customize the shortcut menu that appears when you right-click on a Table Cell to include a choice for Inserting the Date. To do so,
- Select Insert in the Categories list box.
- Then, drag Date from the Commands list box to the Table menu on the Shortcut Toolbar, without releasing the mouse button.
- When your mouse pointer is over the menu it will automatically expand to reveal its submenus.
- Drag the mouse pointer over Table Cell and you’ll see the other choices that are displayed when you right-click on a control.
- Simply drag the Date command to the position on the menu that you want and release the mouse button.
- When you’ve finished customizing the shortcut menu, click Close to dismiss the Customize dialog box.
See all Topics
-
May 27, 2006 at 8:10 am #3158229
What if the Truth Teller Fibs?
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
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.
FALSE:
The restaurant chain formerly known as “Kentucky Fried Chicken” changed its name to KFC to eliminate the word “fried” from its title.
TRUE:
At the moment the Titanic hit an iceberg in the north Atlantic, the silent version of the film The Poseidon Adventure was being screened aboard ship.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 4/1/2004
]See all
Topics
-
May 28, 2006 at 8:09 am #3156039
Re-color-Transparent
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Change clip art
Re-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.
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 4/11/2004
]See all
Topics
-
May 29, 2006 at 8:11 am #3155835
Windows Version
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Check the numbers
The version of Windows being used can be seen by Right-cliking on My Computer and choosing Properties.
Also try typing into Start>Run:
winver.exe
to see the version installed.
Also:A way to see if your installation on Windows has been activated is to use:
Oobe/msoobe /a
Just type it into Start>Run
Microsoft.com:
Internet Activation
See all
Topics
-
May 30, 2006 at 11:35 am #3156583
Photo Blog
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Daily shots
I 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.
“With 8.8 Million monthly visitors and over 360 Million photos to explore, Webshots is the world’s largest photo sharing site.
Webshots provides consumers with a variety of ways to enjoy photos: on their computer desktops as wallpaper and screensavers, on their wireless phones, and in their own homes and offices as prints.
Webshots also offers a number of ways for friends and family to share photos with one another, such as Photo Messages, online photo albums, and custom prints and gifts. Through free homepages and its Favorite Members network, consumers can connect with friends, family and millions of others worldwide.”
Webshots! Over 20 MILLION FREE screen saver and wallpaper photos!See all Topics
-
May 31, 2006 at 10:47 am #3157714
Polyglot Polynomials
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
ToolPak Translator
I 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?
This utility extracts this data from your LOCAL MS Excel edition.
As such this table can be generated for ANY LANGUAGE EDITION of MS Excel, even when this language is not yet integrated in the utility.”
See all
Topics
-
June 1, 2006 at 6:45 am #3157598
Echo Document Data
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Enter once — use again
Enter 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.
See all Topics
-
June 2, 2006 at 6:59 am #3165543
Delegate Delete Deliveries
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Choose the folder
When 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
- Click Start, and then click Run
- Type regedit, and then click OK
- Locate the registry key that is appropriate for your version of Outlook
For Outlook 2003:HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Options\General
- Right-click the DelegateWastebasketStyle value, and then click Modify
If the key is not present, use the following steps to create it:
- Right-click the General folder
- Point to New, and then click DWORD Value.
- Type DelegateWastebasketStyle, and then press ENTER
- Change the value data in the Edit DWORD Value dialog box to one of the following values:
8 = Stores deleted items in your folder
4 = Stores deleted items in the mailbox owner’s folderNOTE: Make sure that the delegate user has at least Author level rights for the Deleted Items folder of the owner’s mailbox.
- Quit the Registry Editor
- Restart Outlook
Support.microsoft.com:
Items deleted from a shared mailbox go to the wrong folder in OutlookSee all Topics
-
June 3, 2006 at 10:28 am #3166140
A Hoard of Tips
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Good for all levels of user
Allen Browne’s tips for Access users
Here is a list of the sections on this site; something for everyone.
- Casual Users – basic tips and explanations;
- Serious Users – ideas for forms, combos, reports, and code;
- Flaws in Access – unfixed bugs that will bite you;
- Traps to avoid – problems that may not be obvious;
- Specific Applications – a couple of examples where people get stuck;
- Tips for xBase developers – for people who used the old dBase;
- Functions you can use – code to copy;
- Upgrading – issues when changing versions;
- Other sites – links to other sites with free Access tips.
[Edited entry from 4/9/2004]
See all Topics
-
June 4, 2006 at 6:28 am #3165983
Plain Numbers
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
I’d Like to Make It Clear
Plain Figures is a method of transforming statistical and financial data into figures, tables and graphs that people readily understand.
Have you ever:
- squinted your eyes trying to see the numbers in a PowerPoint presentation?
- scratched your head at a charity leaflet with an indecipherable pie chart titled ‘Where your donation goes’ … and set it aside?
- missed discussion at a meeting because you were busy trying to figure out the figures?
- put aside a graph or table, thinking “I’m not good with numbers.”?
Then you know how important the clear display of numerical information can be.
Common problems
People have trouble using numerical information for many reasons. Most commonly, authors don’t know:
- what to include: when unsure what numbers are important, people frequently display them all, overpowering the reader with irrelevance.
- which format to use: the choice between text and table, table and chart, bar and pie.
- how to use the technology effectively: computer software generates graphs easily, but the results hide your point behind incomprehensible chartjunk.
- how to explain the information: selecting the right words for titles, columns and captions.
Plain Figures is a partnership between Sally Bigwood, located in Wakefield, Yorkshire, UK, and Melissa Spore, who divides her time between Toronto and Saskatoon, Canada. Sally and Melissa are sisters and both have dual citizenship in the United States.
[Edited entry from 4/21/2004]
See all Topics
-
June 5, 2006 at 12:17 pm #3164988
Simple Shows
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
In brevity is success
Blogger/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 you?re optimal font size.
See all
Topics
-
June 6, 2006 at 9:27 am #3165242
Print Problems
by dklippert · about 17 years, 10 months ago
In reply to Unofficial Microsoft Office Stuff
Some clues
I’m sure that printing problems will pop up in the future as well, but here are some suggestions for the machines we use today:
Support.microsoft.com:
How to troubleshoot general printing problems in Windows XP
“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
See all
Topics
-
June 7, 2006 at 9:11 am #3145326
Restore Defaults
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Office 2003 redo
To reset the original settings in Office 2003, follow these steps.
Make sure that you back up your files before you follow these steps.- 1. Start any Office 2003 program.
- On Help menu, click Detect and Repair.
- Click to select the Discard my customized settings and restore default settings check box, and then click Start.
- Quit the application, and then click Ignore.
- Click OK when you receive the following message:
Reset of setting to default succeed.
See all Topics
-
June 8, 2006 at 9:15 am #3143506
Access – Excel – HTML – XML
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Transfer data
XML 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
See all
Topics
-
June 9, 2006 at 9:28 am #3144307
Save Clean Document
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Protect your layout
Sometimes 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:
- You open the document from a Microsoft Outlook e-mail attachment.
- The Allow starting in Reading Layout option is turned on in Word.
- The table of contents in the document is three or more pages long.
- The document was saved in the page layout view.
Microsoft offers these suggestions to prepare your baby for its best look.
When you send a Word document as an e-mail attachment, make sure that you save the document in normal view before you send the document.
Turn off reading layout view
- Start Word.
- On the Tools menu, click Options.
- Click the General tab, click to clear the Allow starting in Reading Layout check box, and then click OK.
Turn off all formatting marks
- Start Word.
- On the Tools menu, click Options.
- Click the View tab, click to deselect the All check box under Formatting marks, and then click OK.
Manually update all the page numbers
- Open the Word document.
- Select the table of contents in the document, and then press F9 to update all the page numbers.
Support.Microsoft.com
The page numbers in the TOC are incorrectly displayedSee all Topics
-
June 10, 2006 at 9:16 am #3143337
Use HTML in Messages
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Slick up your mail
“Outlook does not provide a command to insert tables or other complex elements into HTML messages, nor does it give you a way to edit the source of an HTML message.
The View Source command that you see on the right-click context menu in an HTML message does not let you save any changes to the source back into the message.
There are several ways to compose complex HTML messages, though.”
Slipstick.com lays out five methods to create formatted HTML messages:
Composing Complex HTML Mail Messages
Also:
PageResource.com:
Introduction to HTML Email
[
Edited entry from 4/16/2004
]See all
Topics
-
June 11, 2006 at 9:17 am #3145049
Auto Form
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Just add Data
Highlight 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.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 4/17/2004
]See all
Topics
-
June 12, 2006 at 9:55 am #3145700
Your Grand-cestors swore
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Your Grandmothers told them to stop
What 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.
Even the quintessential Good Book abounds in naughty passages like the men in II Kings 18:27 who, as the comparatively tame King James translation puts it, “eat their own dung, and drink their own piss.”
Refered to by:
LanguageHat.com
The Antiquity Of CursingSee all Topics
-
June 13, 2006 at 9:41 am #3141471
I need more guides
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Line it up straight
A 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.See all
Topics
-
June 14, 2006 at 7:13 am #3271087
Free Fonts, Free Drinks
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Typographic connections
Fonts 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.
Many link descriptions are boozy and fuzzy. Some opinions are simply pathetic, but I do not want to leave this world without making a fool of myself. To make up for the awful service, I am inviting any type lover visiting Montreal to my house for drinks.”
Type Design, Typography, Typefaces and Fonts
See all
Topics
-
June 15, 2006 at 9:55 am #3269973
Automated Newsletter
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
ASP and HTML
Pre-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.
Step 2 : Create a simple Access database to store user’s email addresses.
Step 3 : A simple admin ASP page from where you can send email messages to all the users whose email addresses are present in the database.
Step 4 : An ASP page from where the users can delete their email addresses from the database if they later choose to.
Stardeveloper.com:
An ASP Tutorial to create your own News Letter
See all
Topics
-
June 16, 2006 at 9:51 am #3268633
Excel – 2003- VBA Help File
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Download from Microsoft
Here 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
See all
Topics
-
June 17, 2006 at 11:21 am #3145915
May I Comment on Your Balloon
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Markup stuff
How to turn off balloons for comments and track changes in Word 2002 and Word 2003
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.
To turn off or hide the balloons for comments and track changes in the right side margin of a Microsoft Word document, follow these steps:
- On the Tools menu, click Options.
- On the Track Changes tab, do one of the following:
- In Word 2003, change the Use Balloons (Print and Web Layout) box to Never.
- In Word 2002, click to clear the Use Balloons in Print and Web Layout check box.
- Click OK to close the Options dialog box.
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
[Edited entry from 4/6/2004]
See all Topics
-
June 18, 2006 at 11:36 am #3145734
Multiple Mail Drag
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Quick trick
To 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:[
Edited entry from 4/24/2004
]See all
Topics
-
June 19, 2006 at 7:31 am #3270549
Fiscal Year in Access
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Make up your own year
You 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
See all
Topics
-
June 20, 2006 at 7:53 am #3269680
Crash Notepad
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
An odd little trick
That innocuous little app, notepad, is not immune to problems.
Here’s how to do it:
- Open up Notepad
- Type in this sentence exactly (without quotes): “this app can break“
- Save the file to your hard drive.
- Close Notepad
- Open the saved file by double clicking it.
Most people will see empty squares, but if you have the ‘SimSun” font installed, you’ll see Chinese (CJK) characters.
Turns out it works with any sequence of 4, 3, 3, and 5 lower-case alpha characters [a-z] separated by a space,
“xxxx xxx xxx xxxxx“
also works.
Here’s the techy explanation:
Some files come up strange in NotepadAlso:
Aftermarket Pipes:
This API can break
WinCustomize.com
How to Break Windows NotepadSee all Topics
-
June 21, 2006 at 7:44 am #3142383
And the Audience Slept on
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Are 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. . .
As the lecture proceeded attention spans became shorter and often fell to three or four minutes towards the end of a standard lecture.”Both of these studies note the severe lapse of attention 15 to 20 minutes into a lecture. Given that students have an attention span of around 15 to 20 minutes and that university classes are scheduled for around 50 or 75 minutes, instructors must do something to control their students’ attention. We recommend building a “change-up” into your class to restart the attention clock.
Joan Middendorf and Alan Kalish
Teaching Resources Center
Indiana UniversityThe National Teaching & Learning Forum:
The “Change-Up” in Lectures
See all
Topics
-
June 22, 2006 at 7:45 am #3268856
Stop Spock Salute
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
No more three fingers
If 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.
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon
- Value Name: DisableCAD
- Data Type: REG_DWORD (DWORD Value)
- Value Data: (0 = Require Ctrl+Alt+Delete, 1 = Disable)
For more tricks try Winguides.com:
Press Ctrl+Alt+Delete Before LogonSee all Topics
-
June 23, 2006 at 7:45 am #3269274
Test Your Web Site
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
How 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.
- Readability Test
- The readability test analyses a Web page to determine how readable it is.
- CSS Analyzer
- The CSS analyzer tests for basic accessibility errors such as color contrast and units of measurement.
- Luminosity Contrast Ratio Analyzer (Beta)
- Tests whether foreground and background colour combinations are sufficient using a new algorithm developed by Trace R&D Center.
- Color Contrast Analyzer
- The color contrast analyzer tests whether the contrast between the background and the foreground is sufficient.
- Image Analyzer
- The image analyzer tests Web pages to ensure that images have been specified properly.
- Link Analyzer
- The link analyzer lists all links on a page with an icon to indicate whether or not the link resolved successfully.
Juicystudio.com:
Quality AssuranceSee all Topics
-
June 24, 2006 at 2:15 pm #3143064
Lists in 2003 – Tabled in 2007
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
One improvement?
Much of what’s new in Excel 2003 is technically interesting, but probably will go unused is a majority of installations; i.e. XML data exchange, Sharepoint, and Smart documents.
One of the smaller new features might be used more often; that’s the enhanced list management tools.
Microsoft has a 20 minute course, if you have Office 2003 installed, “How to use Lists in Excel 2003.”
Though on reflection, it’s not such a big deal. See John Walkenbach’s comment at:
Excel 2003 Review(If you don’t have Office 2003 or an Active X browser, you can’t see the information.
Here’s the explanation: Troubleshoot why you can’t see some pages on Office Online.)There is, also, a Quick Reference card.
- Toggle Total Row button
- This button automatically totals the last column in the list. You would just click the Toggle Total Row button. Voil?! Excel would add an additional row with the word “Total” and with the sum.
- Multiple Lists
- When you use the List command, you can have more than one list on a worksheet. You can add or delete a row in one list without adding or deleting a row in a list next to it, an ability new in Excel 2003.
- Multiple Sorts
- You can also sort those lists separately, because using the List command automatically gives each list its own AutoFilter arrows.
For Office 2007:
You cannot find the Excel List feature in the new Microsoft Office Excel 2007 Ribbon.
The Excel List feature still exists, but it has been renamed. Excel lists are now called Excel tables.
To create an Excel table (previously known as an Excel list), select the range that you want to turn into a table, and then do one of the following:
- On the Insert tab, in the Tables group, click Table.
- Keyboard shortcut In addition to CTRL+L, you can now press CTRL+T to create a table.
The List toolbar no longer exists (of course) and you can’t insert SubTotals in a table.
Lists turned out to be another one time feature.
[Edited entry from 4/5/2004]
See all Topics
-
June 25, 2006 at 11:47 am #3142868
Protected Spell Checker
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Correct the protected
Unfortunately, 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 4/10/2004
]See all
Topics
-
June 26, 2006 at 8:38 am #3163861
Delete Days
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Erase the future
If 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
- Start Outlook 2003, and then click your Calendar folder.
- On the View menu, point to Arrange By, click Current View, and then click By Category.
- On the View menu, point to Expand/Collapse Groups, and then click Collapse All.
- In the Table pane, right-click each category, and then click Delete. This deletes every item that belongs to each category.
After you delete all of the items in all of the categories, the Calendar folder is empty.
How to delete all Outlook Calendar items
Outlook 2007 appears to work the same way:
See all Topics
-
June 27, 2006 at 9:13 am #3112154
Data Security
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Access style
With all the news about database spying, here’s some information about protecting your own Access db.
Don’t tell the New York Times.
This is Margaret Blauvelt’s TOC from Mendoclick.com:
- General Protection from Unauthorized Users
- Protect your Logon Identity
- How to Change your Password in Access
- User Logon, Security and Data Integrity
- The Access Workgroup Security File
- Object Permissions and User Logon
- Access Sessions and the Workgroup File
- Joining to another Workgroup Security File from within Access
- Opening a Database from the Command Line
- Opening a Database from a Shortcut
- Backup
- Compact and Repair
Mendoclick.com
Access Security for End UsersSupport.microsoft.com:
Frequently asked questions about Access security warningsFor Access 2007:
Data Security in Microsoft Access 2007See all Topics
-
June 28, 2006 at 8:18 am #3110686
Paper Power
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
What do steam and paper have in common?
I find origami and paper sculpture intriguing.
Ed Bertschy provides a template that can be downloaded and printed on good paper to be used in the construction of a paper steam engine.This paper steam engine is based on a Riches and Watts nominal 2 1/2 horsepower vertical A-frame double acting simple slide-valve steam engine circa 1870-75. The original engine was used to drive a water pump to irrigate the fields of Norfolk. If this model had a scale, it would be roughly 1:19. I had to double the size of the eccentric and strap in order to make it buildable. Everything else is close to scale, but changed in design and appearance because, well, paper isn’t iron.
Everything will work on this engine, the flywheel turns, there really is a slide valve in the valve chest, the piston works, the cranks and the connecting rods, eccentric and strap all work if built carefully. The final model stands about 12 inches high. I hope you have as much fun building it as I had designing it.
See all
Topics
-
June 29, 2006 at 9:14 am #3113251
Internet Shows
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Is the Web any place for a PowerPoint Show?
How should a PowerPoint file be saved for use on the web?The University of Wisconsin-Stout ran an experiment.
Tested Methods
Save as HTML or Web Page [Not Recommended]
PowerPoint Presentation (*.ppt) [Recommended]
PowerPoint Show (*.pps) [Not Recommended]
PowerPoint Animation (*.ppa) [Not Recommended]
Pack-n-Go [Not Recommended]
ASF – Streaming -
June 30, 2006 at 11:38 am #3113058
Change Windows XP View
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Adjust how it looks
Sometimes the performance of Windows XP can be tweaked by adjustinga few settings.
- Right Click the My Computer Icon
- Choose Properties
- Go to Advanced>Performance>Settings
Pick one of these options:
- Let Windows choose what’s best for my computer
- Restore settings to Windows choice.
- Adjust for best appearance
- Turn on all visual effects
- Adjust for best performance
- Turn off all visual effects
Or uncheck these settings:
- Fade or slide menus into view
- Fade or slide ToolTips into view
- Fade out menu items after clicking
- Show Shadows under menus
- Slide open combo boxes
- Slide taskbar buttons
- Use a background image for each folder type
- Use common tasks in folders
See all Topics
-
July 1, 2006 at 9:03 am #3111310
Web Things to Remember
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
A few small things you shouldn’t forget
The Web Workshop suggests that these four items are among the many you should make sure are used correctly on your web page:
- The Page Title
- The Background Color
- The Submit Button in Forms
- Non-Breaking Spaces
[Edited entry from 4/3/2004]
See all Topics
-
July 2, 2006 at 8:42 am #3111113
Large Text Files
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Split between worksheets
While this problem is alleviated in Excel 2007 with its 1,048,576 rows by 16,348 columns, The old XL versions are still here.
Text files with a large number of records are better handled in a program like Access. Having said that, there can be times that these lists must be imported into Excel. If the file has over 65,536 records, the data will not fit on a single worksheet.
Here’s a Microsoft Knowledge Base article with the macro code needed to bring oversized text data into Excel and split it into multiple worksheets:
Sub LargeFileImport()
'Dimension Variables
Dim ResultStr As String
Dim FileName As String
Dim FileNum As Integer
Dim Counter As Double
'Ask User for File's Name
FileName = InputBox("Please enter the Text File's name, e.g. test.txt")
'Check for no entry
If FileName = "" Then End
'Get Next Available File Handle Number
FileNum = FreeFile()
'Open Text File For Input
Open FileName For Input As #FileNum
'Turn Screen Updating Off
Application.ScreenUpdating = False
'Create A New WorkBook With One Worksheet In It
Workbooks.Add template:=xlWorksheet
'Set The Counter to 1
Counter = 1
'Loop Until the End Of File Is Reached
Do While Seek(FileNum) <= LOF(FileNum)
'Display Importing Row Number On Status Bar
Application.StatusBar = "Importing Row " & _
Counter & " of text file " & FileName
'Store One Line Of Text From File To Variable
Line Input #FileNum, ResultStr
'Store Variable Data Into Active Cell
If Left(ResultStr, 1) = "=" Then
ActiveCell.Value = "'" & ResultStr
Else
ActiveCell.Value = ResultStr
End If
'For Excel versions before Excel 97, change 65536 to 16384
If ActiveCell.Row = 65536 Then
'If On The Last Row Then Add A New Sheet
ActiveWorkbook.Sheets.Add
Else
'If Not The Last Row Then Go One Cell Down
ActiveCell.Offset(1, 0).Select
End If
'Increment the Counter By 1
Counter = Counter + 1
'Start Again At Top Of 'Do While' Statement
Loop
'Close The Open Text File
Close
'Remove Message From Status Bar
Application.StatusBar = False
End SubImporting Text Files Larger Than 16,384/65,536 Rows
Notice the code about 17 lines from the bottom of the macro.
‘For xl97 and later change 16384 to 65536.
Also, after import, the data must be parsed. Use Data>Text to columns.
Also:
Daniel Klann:
Importing large text files (more then 65,536 rows) into Excel
If you have not worked with macros before, Dave McRitchie has a tutorial:
Getting Started with Macros and User Defined Functions
[Edited entry from 4/14/2004]
See all Topics
-
July 3, 2006 at 9:20 am #3113574
Backup Your Word
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Stand behind your documents
Backup/restore or transfer AutoCorrect, AutoText, Macros, and other critical files from one version of Word and Windows to another
- Normal.dot:
Stores formatted AutoCorrect entries, AutoText entries, keyboard shortcuts, menu customizations, custom toolbars, styles, macros. - acl file:
Stores unformatted AutoCorrect entries (the majority of your AutoCorrect entries). - custom.dic:
Words you add during spellcheck. - Templates you create (.dot files).
From ProductivityTalk.com:
MS Word’s critical files
Word comes with a supplemental macros template that includes the AutoCorrect Utility. The utility is used to backup and restore entries. If you only do the backup portion, it will create a regular Word document that you can print..In Word 2002/2003: it’s part of the support.dot (included on Office installation CD)
See all Topics
- Normal.dot:
-
July 4, 2006 at 9:36 am #3168643
Send to All Your Friends
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
While you still have any
Hoax e-mail, at one time, threatened to overflow offices and homes with deleted electrons.
Some of the offers and “insights” seemed so real and they came from respected senders.If you have doubts about claims that:
- We should Boycott 7-11
- That California Bill AB 2651 Outlaws Christian Foster Parents?
- There are Formosan Termites in Mulch from New Orleans?
- Bush won an honest election
Or any other spam claims, take a look at:
BreaktheChain.org
Another spot to check is:See all Topics
-
July 5, 2006 at 8:09 am #3167971
Reduce Entry Mistakes
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
Disable AutoExpand
When you type an entry in a combobox control Access will typically attempt to complete the entry based on the control’s lookup list.
This is controlled by the AutoExpand property, which is set to Yes (-1) by default.
Although such behavior is helpful, it can cause problems if your value list contains several items that are close in spelling, since it’s easy for users to accidentally let Access choose the wrong item.
You can avoid errors by setting the control’s AutoExpand property to No (0) in Design view or using VBA to set the property equal to 0.
Once you’ve made the change users are forced to type the entire entry or select an item using the combobox control’s dropdown list.
(Works the same in Access 2007)
See all
Topics
-
July 6, 2006 at 7:54 am #3167037
Triangle with 3 Right Angles
by dklippert · about 17 years, 9 months ago
In reply to Unofficial Microsoft Office Stuff
They said – “Imposible!”
Forget high school geometry. A triangle can have more than on ninety degree angle.
Here’s how it was done:
“Caution!!!! Some of the optical illusions on this blog may cause dizziness or possibly epileptic seizures. The latter happens when the brain can’t handle the conflicting information from your two eyes. If you start feeling unwell when using this website, immediately cover one eye with your hand and then leave the page. Do not close your eyes because that can make the attack worse.”
See all
Topics
-
July 7, 2006 at 10:51 am #3167433
Military Clipart
by dklippert · about 17 years, 8 months ago
In reply to Unofficial Microsoft Office Stuff
Thousands of items
If you find the need for Armed Forces photos and art, here is the place to look.
Regardless of your opinion about their present mission, the military does present a spectacular visage.
“06/17/06 – An F/A-18E Super Hornet aircraft sits at the ready as storm clouds pass overhead aboard the Nimitz-class aircraft carrier USS Ronald Reagan (CVN 76) in the Philippine Sea June 17, 2006.
(
U.S. Navy photo by Photographer’s Mate 2nd Class Aaron Burden
)All of these files are in the public domain unless otherwise indicated. However, we request you credit the photographer/videographer as indicated or simply “Department of Defense.”
See all
Topics
-
August 27, 2006 at 6:49 pm #3209032
TechRepublic Slow
by dklippert · about 17 years, 7 months ago
In reply to Unofficial Microsoft Office Stuff
The last entry posted here was back in July. There of course are many more postings.
-
-
AuthorReplies