Tuesday, September 19, 2017

Great Collection

Examples and ideas


The experts show you how they have developed some pretty spectacular animations and designs using PowerPoint out of the box.


"PowerPoint Heaven is a website providing PowerPoint showcase, artworks, PowerPoint games, animation templates, PowerPoint animations and tutorials on animating Microsoft PowerPoint."


PPTHeaven.mvps.org



See all Topics

Monday, September 18, 2017

Google Search Tips

Drill down to the answer


20 search tips to be used with Google.

Here are a few:

  • Either/or. Google normally searches for pages that contain all the words you type in the search box, but if you want pages that have one term or another (or both), use the OR operator -- or use the "" symbol (pipe symbol) to save you a keystroke.


  • Quotes. If you want to search for an exact phrase, use quotes.


  • Not. If you don't want a term or phrase, use the "-" symbol.


  • Similar terms. Use the "~" symbol to return similar terms.
  • Definitions. Use the "define:" operator to get a quick definition.
  • Vertical search. Instead of searching for a term across all pages on the web, search within a specialized field. Google has a number of specific searches, allowing you to search within blogs, news, books, and much more
20 Google Tips



See all Topics

Sunday, September 17, 2017

Auto Number

Don't be smart



There should not be any "intelligence" in an AutoNumber field. It is meant as an index field and not anything else.

If the need should arise to reset the field, if your table does NOT contain any records, simply compacting the database again will set the Autonumber field back to 1.

Another way would be to delete the AutoNumber field and re-insert it in the table.

Here's a long way to start at a specific number.
  1. Create your table with an AutoNumber type field, but don't enter any records.
  2. Create another table with only a single Long Integer Number type field.
  3. This field must have same name as the AutoNumber field in the first table.
  4. Enter one record in the second table that is a number one less than the required start of the AutoNumber for the first table.
  5. Now create an append query to append the record in the second table to the first table and run the query.
You can now delete the second table and begin entering your data into the first table.
Also: Access AutoNumber Reset
"This is some sample code that shows how to programmatically reset all AutoNumber fields in an Access Database to a correct value (whether it be 0 or the max value + 1). In addition, it contains code for Compacting and Repairing an MS Access Database. This is perfect for people who are working with a complicated Access Database and have experienced AutoNumber bugs!
And: Creating an AutoNumber field from code  



See all Topics

Saturday, September 16, 2017

Countdown Slide

3-2-1




It can be useful to let your audience know when the show is going to begin. Here's a description about how to do it:

Create Countdown Slide Without VBA
(There is also a sample PowerPoint file with all the hard work done for you!)


The MVPS.org site also has a way to do it with VBA:
Simulate a countdown timer using Sleep API

Indezine.com has a tutorial:
Countdown Timer

Tushar-Mehta.com offers a free download:
PowerPoint Timer add-in
The add-in provides a variety of capabilities missing from PowerPoint itself. During a slideshow, it can:

  • Show the current time
  • Show the elapsed time of the presentation
  • Count down the time remaining for the presentation.
  • Optionally, it includes the ability to terminate the presentation at the end of a separately configurable grace period!
Also a tutorial on auto scheduling a PowerPoint show



See all Topics

Friday, September 15, 2017

Create Hyperlinks in Access Tables

Simply


When you populate a hyperlink field in a table, you probably cut and paste the URL from your browser into the Insert Hyperlink dialog box.
There's an even easier way to do this using Internet Explorer.

  1. First, open the Access table you're updating and Internet Explorer.

  2. Select the hyperlink field you want to create the link in and choose Insert >Hyperlink from the menu bar.

  3. Press Alt+Tab or use your mouse to select the browser window.

  4. Browse to the page you want to link to and then switch back to Access.
You'll find that the URL is automatically inserted in the dialog box.



See all Topics

Thursday, September 14, 2017

Where'da go?

Sent mail vanishes


Trying to find out why an email message does not arrive at its intended location can be difficult.

This tip is from Office-Watch.com. Look into their weekly newsletter.

Here are some suggestions:

Where could that message be?



See all Topics

Wednesday, September 13, 2017

5 Tips

A few useful ideas


"If you use Word in your daily work, a few simple tips will help you save an hour of your time per week, maybe more. Best of all, these tips are so easy to use that you can put them to work immediately upon finishing this article. Yes, they are that easy to use!"
  • Let Word type names and other words and phrases for you

  • Let Word insert your favorite text or graphics

  • Let Word type information about your documents

  • Let Word alphabetize lists for you

  • Change the way Word works
5 Time-Saving Tips



See all Topics

Tuesday, September 12, 2017

Data Validation

Control input



Mark Rowlinson provides a discussion by Kid Van Ouytsel that does an excellent job explaining data validation. He has also constructs a sample workbook that you can download and play with.

Data Validation
"Data validation is a tool that can help you control the input/changes someone can make in a spreadsheet. It can help you or your users to make choices, guide them to make relevant input/changes, or restrict input to a specific type of data or structure. It can help you or your users to save time and to keep formulae working properly."

Also:

Contextures:
Excel -- Data Validation

Ozgrid:
Data Validation and Conditional Formatting

Microsoft Office Online:
Overview and samples of data validation



See all Topics

Monday, September 11, 2017

Keyboard Shortcuts

Extra pilcrows?



Here is a list of keyboard shortcuts I once or never knew.

The one that struck me was:

Ctrl Alt K — Remove extraneous paragraph marks.

This removes doubled pilcrows (¶¶).

Word-Tips


  • Alt F6 — Swap open documents
  • Alt Shift D — Insert date
  • Alt Shift Up/Down — Move table rows or paragraphs up or down
  • Shift F5 — Go back to last position
  • Shift F3 — Change case
  • Ctrl Space — Remove direct formatting
  • Ctrl Q — Remove paragraph formatting
  • Ctrl Shift N — Apply Normal style
  • Ctrl Y — Repeat action
  • Ctrl ] — increase font size by 1pt
  • Ctrl [ — decrease font size by 1pt
  • Ctrl Shift > — Increase font to next size up
  • Ctrl Shift < — Decrease font to next size down




See all Topics

Sunday, September 10, 2017

Split Access Database

Separate tables



You don't need to keep all of your data in one file. You can split your MDB file into data and application files.

"Even if all your data is in Access itself, consider using linked tables. Store all the data tables in one MDB file - the data file - and the remaining objects (queries, forms, reports, macros, and modules) in a second MDB - the application file.
In multi-user situations, each user receives a local copy of the application file, linked to the tables in the single remote data file."

  • Maintenance: To update the program, just replace the application file.
    Since the data is in a separate file, no data is overwritten.

  • Network Traffic: Loading the entire application (forms, controls, code, etc)across the network increases traffic making your interface slower.
In some cases you will link additional files:
  • Static look-up data such as postal codes might be kept in its own file.
  • Linked temporary tables might avoid the need to compact the application file.
From Allen Brown's tips for Access users
Access has a tool to do the splitting for you, go to: Tools>Database Utilities Database Splitter
In Access 2007+:
  1. On the Database Tools tab, in the Move Data group, click Access Database.
  2. In the Database Splitter dialog box, click Split Database.
  3. Type a name for the back-end database, and then click Split.
Also:
Knowledgebase:
How to manually split a Microsoft Access database

MSDN:
About sharing an Access database on a network  



See all Topics

Saturday, September 09, 2017

Backgrounds for you

A large number of designer slides


PP'ers are always on the lookout for colorful, useful backgrounds.

Camtasia Studio, a maker of video capture software has a lot of PowerPoint backgrounds that are yours for the downloading.


"Based on the popularity of our MenuMaker background templates, we've created background templates for use with Microsoft PowerPoint. These free templates are designed for use with PowerPoint presentations recorded with TechSmith's Camtasia Studio. However, they are standard templates and can be used for any PowerPoint presentation."

Camtasia Backqrounds



See all Topics

Friday, September 08, 2017

Open to Contacts

Your choice


To create a shortcut for your Outlook Contacts folder on the desktop


  1. Right click on an open area of the desktop

  2. Select New / Shortcut

  3. Enter in the path to your outlook program followed by outlook:contacts. Note the quotes are necessary:
C:\Program Files\Microsoft Office\Office12\OUTLOOK.EXE outlook:contacts





See all Topics

Thursday, September 07, 2017

Runtime for Access

Free Download !


Access is not included in the basic Office 2007+ suites. If you want to distribute your database projects to others in the office, you'll need this download.

The Access 2003 Developer Extensions cost about $500. The 2007-10 downloads are free!


"Microsoft Office Access 2007 provides a rich platform for developing database management solutions with easy-to-use customization tools.

If no end-user customization is required (including report modifications), you can choose to distribute those Access 2007 solutions so that they run without requiring a full installation of Access 2007.

To do so, you must package and distribute your application with the Access Runtime.

The Access Runtime is similar to previous runtimes in that all design-related UI is either removed or disabled.

You do not need to buy any special SKU in order to redistribute the Access Runtime. You can freely redistribute it or point users to this download."


Access 2007 Runtime

Access 2010 Runtime

Access 2013 Runtime



See all Topics

Wednesday, September 06, 2017

Move a Column

No Cut, No Paste


With a little practice you can quickly move columns or rows.

  1. Select the entire column or row you want to move
    The move will effect whatever is selected; cells, or columns, or rows

  2. Move your mouse pointer to the edge of the selection until it changes from a normal pointer cross to an arrow (four headed arrow in 2007+).
    (Put the pointer on the selected cells, not the Row or Column indicators.)

  3. Hold down the shift key and click the left mouse button and drag the column/row to the new position.

  4. Release the mouse button before releasing the shift key




See all Topics

Tuesday, September 05, 2017

DOCTYPE

Customize



At the top of an HTML file source, you may see some code that indicates the version of HTML that is going to be used.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">

The O'Reilly Net.com has a discussion:
DOCTYPE Explained.

"There are three variants on HTML 4.01, for example:
  • HTML 4.01 Strict, which describes the structural portions of HTML 4.01 and does not provide any frame-related markup.
  • HTML 4.01 Transitional, which includes the presentational markup such as >B< and >FONT<, but does not include frame-related markup.
  • HTML 4.01 Frameset, which is the same as HTML 4.01 Transitional except that it adds a description of frame-related markup."
Also:
Fix Your Site With the Right DOCTYPE!
Choosing a DOCTYPE  
The global structure of an HTML document  



See all Topics

Monday, September 04, 2017

Fuzzy Prewview

Fix the resolution


If the preview image is not clear, this Knowledgebase article may help:

Because of changes in how the preview image is saved in Microsoft Office PowerPoint 2007, in Microsoft Office PowerPoint 2003, and in Microsoft PowerPoint 2002, the preview image File Open dialog box is more difficult to read than in PowerPoint 2000 and earlier versions.


In PowerPoint 2007
  1. Click Start, click Run, type regedit, and then click OK.

  2. Locate and then click the following key in the registry:

    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\PowerPoint\Options

  3. On the Edit menu, point to New, and then click DWORD value.

  4. Type Preview Picture Precision, and then press ENTER.

  5. On the Edit menu, click Modify.

  6. Click Decimal in the Base area.

  7. Type 320, and then click OK.

  8. Exit Registry Editor.
Support.Microsoft.com:
Preview image is fuzzy



See all Topics

Sunday, September 03, 2017

Attention Grabber

For Print Screen or lost spectacles


Those Apple type people have a gadget called "Mouseposé". You might have seen it in videos demonstrating applications. It darkens the screen and puts a spotlight on the point of interest.

Those of us who use real machines have a similar add-in.



It's not from Boinx.
It's the magnifier or "Dragnifier" from Ed Halley.



See all Topics

Saturday, September 02, 2017

Indent Code

Realign a bunch


Indenting blocks of VBA code, such as statements within loops or If...Then statements, makes reading a procedure much easier.

You probably indent a code statement using the [Tab] key, and outdent by using [Shift][Tab].

However, you may not be aware that the [Tab] and [Shift][Tab] techniques also work when multiple code lines are selected.

The Visual Basic Editor also provides Indent and Outdent buttons on the Edit toolbar that allow you to easily reposition blocks of code.



See all Topics

Friday, September 01, 2017

Convert List Numbers to Text

Pesky lists


Applying the list numbering style to paragraphs is easy. The problem is that if the style is removed, the numbers disappear as well.

The same thing is true with bullets.

The following macro will change the list numbers and LISTNUM fields to text and the bullets to a symbol font.


Sub NoAutoNum()
ActiveDocument.ConvertNumbersToText
End Sub

You can now do such things as individually format numbers and bullets.
The action is not reversible, so either use Undo right away, or use it on a copy of the original.

ConvertNumbersToText



See all Topics

Thursday, August 31, 2017

Tips and Formulae

Functions and Macros



I'm always looking for Excel sites. A fresh perspective can make the view more clear.
While he does approach from a Mac angle, the Excel world welcomes those of all persuasions.

J.E. McGimpsey's XL Pages

Here are some of the tips:

  • Remove internal worksheet/workbook protection
  • Why your sum is a penny off...
  • Highlight row without losing color formatting
  • Why use -- in SUMPRODUCT formulae
  • Using SUMPRODUCT() to calculate variable rates and commissions
  • Three-dimensional SUMIF()s
  • Bitwise Logical Functions
  • Sampling from a range
  • Summing every Nth column or row
  • Worksheet and Workbook names using the CELL() function




See all Topics

Wednesday, August 30, 2017

Color Code Appointments

Red letter day



Outlook 2002+ allows you to assign colors to appointments and meetings.
To format a single appointment:
  1. Simply right click on the event
  2. Select Label
  3. From here you can select from a variety of pre-selected colors
Appointments can also be Automatically formatted.
  1. Right-click a meeting entry and choose Automatic Formatting...
  2. Click on Add and name the Rule.
  3. Next, click Condition and set up a Filter such as having the word "Dr" in the subject or note field.
      In the future, whenever you set up an appointment that has "Dr" in the text, the entry will be color-coded.

      New Folders

       Also see:

    1. Slipstick.com To add color coding to Calendar items
"… if you have ten or fewer main categories that you use on a regular basis, you might want your label names to be the same as your categories. To change the default label names, go to the Edit menu from the Calendar view and click on the Labels option."
University of Wisconsin-Eau Claire: Color Coding Appointments - 2007 



See all Topics

Tuesday, August 29, 2017

Folder Tree

DOS is back


"To find out how many folders there are on your hard disk, you can open a Command Prompt and use the Tree command. You'll get a very nice looking graphical tree structure showing all the folders on your hard disk.

The only problem is that the display will scroll by your screen so fast and exceed the buffer size, so you'll never be able to see it."


Import Tree command into Word

(Open Command Prompt as Administrator. Rather than "Insert>File", open the file with Word and choose the MS-DOS format))



Tree command



See all Topics

Monday, August 28, 2017

Loop the Beginning

Then start the show


It can be effective to have an opening segment run before the actual presentation begins.

We all know how to set up a show that will run in kiosk mode until you hit escape.

Here are instructions about how to set up the loop so that you can seamlessly start the show without an interruption.

Creating & Running an Opening Loop



See all Topics

Sunday, August 27, 2017

World War I

Color pictures


"Louis Lumière had already invented instant photographic plates and the Cinematographe when, in late 1903, he and his brother Auguste patented a new process for producing colour photographs : the Autochrome.

Before the invention of the Autochrome, colours were separated using a complex three-colour process whereby three successive exposures had to be taken and then superimposed onto each other.

Louis Lumière, however, devised a method of filtering light by using a single three-colour screen made up of millions of grains of potato starch dyed in three different colours.

This mixture was then laid out on a varnished glass plate, which would be ready for use once it was coated in a black and white emulsion.

Developing the plate entailed applying the same process as was used for black and white photographs at the time, with the impression being processed to reversal.


Institut-Lumiere.org
Here are some examples:

"It looks like a painting by impressionist Edouard Manet, but it is a real color picture, made in 1914, by Jean-Baptiste Tournassoud, Commander of the Photography and Cinematography Section of the French Army.

When the Great War broke out, in 1914, French poilu's (common soldiers) still wore their Napoleontic uniforms with red trousers. They made perfect targets.

Here are some more:
World War I Photos

The Great War



See all Topics

Saturday, August 26, 2017

Access Field Highlighting

More code


This technique can also be applied to controls like option groups.

Instead of using OnGotFocus and OnLostFocus events you must use the OnEnter and OnExit events.

In addition, the control group's BackStyle property must be set to Normal to take advantage of the Windows color scheme:

Function Highlight(Stat As String) As Integer
Dim ctrl As Control
On Error Resume Next
Set ctrl = Screen.ActiveControl
If Stat = "GotFocus" Then
ctrl.BackColor = vbHighlight
ctrl.ForeColor = vbHighlightText
ElseIf Stat = "LostFocus" Then
ctrl.BackColor = vbWindowBackground
ctrl.ForeColor = vbWindowText
End If
End Function

Take advantage of global constants. Just add the following two statements to a module:

Global Const Orange = 39423
Global Const LightBlue = 16776960

Then, set the OnGotFocus and OnLostFocus events for the controls in the following format:
Private Sub controlName_GotFocus()
controlname.BackColor = Orange
End Sub
Private Sub controlName_LostFocus()
controlname.BackColor = LightBlue
End Sub

Highlight data on forms by using conditional formatting



See all Topics

Friday, August 25, 2017

Spies in the Mailbox

Who'd read my mail?



"Espionage and email: as the Pentagon discovered, the two often go hand in hand. Following the arrests of two U.S. servicemen suspected of spying, the Pentagon is broadening its investigation of possible espionage activities at Guantanamo Bay, Cuba. According to CNN, at least one of the security cases has involved suspicious emails that were discovered as part of a routine monitoring process."


OutlookPower magazine has an article on the problem:

Espionage and email: tips for managing your own email archives
By Ann James



See all Topics

Thursday, August 24, 2017

Tuva or Bust

Richard Feynman's Last Journey


By Ralph Leighton
ISBN 0-393-32069-3
W.W.Norton & Company, Inc. 2000, 1991


Tuva or Bust

There has been a lot made of the PowerPoint contribution to the failure of the Challenger shuttle (see Edward Tufte.)

Before that was the Columbia disaster. Richard Feynman found the problem with the "O" rings, He too complained about PowerPoint like presentations:
"Then we learned about bullets — little black circles in front of phrases that were supposed to summarize things. There was one after another of these little goddamn bullets in our briefing books and on the slides."

This book however is about something altogether different.
As a stamp-collecting boy always fascinated by remote places, Nobel Prize-winning physicist Richard Feynman was particularly taken by the diamond-shaped stamps from a place called Tannu Tuva. He hoped, someday, to travel there. In 1977, Feynman and his sidekick — fellow drummer and geography enthusiast Ralph Leighton — set out to make arrangements to visit Tuva, doing noble and hilarious battle with Soviet red tape, befriending quite a few Tuvans, and discovering the wonders of Tuvan throat-singing. Their Byzantine attempts to reach Tannu Tuva would span a decade, interrupted by Feynman's appointment to the committee investigating the Challenger disaster, and his tragic struggle with the cancer that finally killed him. Tuva or Bust! chronicles the deepening friendship of two zany, brilliant strategists whose love of the absurd will delight and instruct. It is Richard Feynman's last, best adventure.



Quote
"Sure enough, occupying a notch northwest of Mongolia was a territory that could well once have had the name Tannu Tuva.
"Look at this," remarked Richard, "The capital is spelled K-Y-Z-Y-L."
"That's crazy," I said. "There's not a legitimate vowel anywhere!"
"We must go there," said Gweneth.
"Yeah!" exclaimed Richard. "A place that's spelled K-Y-Z-Y-L has got to be interesting."



More Tuva:
Tuva Movies and Sounds
Friends of Tuva

Also:
Listen to the music of Tuva on this CD. Willie Nelson is on one track, but it does demonstrate two toned throat singing:

Tuva Throat Singing

Here's another great Tuva story:

Genghis Blues

" Paul Pena is a blind San Francisco blues singer who has played with the likes of John Lee Hooker and Jerry Garcia (he also penned "Jet Airliner," which Steve Miller covered). One night while listening to his shortwave radio, he picked up a Radio Moscow broadcast and heard the mesmerizing, gutteral sound of throat singing, which is peculiar to Tuva's region of upper Mongolian. Enthralled, he became a master of this obscure art form. Enter Friends of Tuva, a curious group that included Nobel Prize-winning physicist Richard Feynman, who likewise had become fascinated with Tuva. In 1993 they sponsored a San Francisco appearance by Tuvan singers. Pena was in the audience and met with the singers afterward. Pena so impressed the Tuvans that he was encouraged to come to Tuva and participate in its annual festival competition. Genghis Blues chronicles this incredible journey."




See all Topics

Wednesday, August 23, 2017

Location Indicator

Point to the spot


Here's a link to the code that produces conditional formatting on the fly to the cells in the current row and column.



Color banding location



See all Topics

Tuesday, August 22, 2017

BIOS Bias

A bootstrap script


Way down deep in the innards of a PC there lives a tiny control freak named the Basic Input/Output System.

And that's just the beginning.

"The BIOS software has a number of different roles, but its most important role is to load the operating system. When you turn on your computer and the microprocessor tries to execute its first instruction, it has to get that instruction from somewhere.
It cannot get it from the operating system because the operating system is located on a hard disk, and the microprocessor cannot get to it without some instructions that tell it how."

Here are a couple of links for more information:

How BIOS Works

Wikipedia-BIOS

What is BIOS



See all Topics

Monday, August 21, 2017

No Black Slide

End the show


After creating a presentation, save it as a PowerPoint show. This allows you to run the show and not be faced with all the paraphernalia that was used to create it.

One negative is that at the end of the show a black slide is displayed.

To eliminate this last distraction, so that the show will run and then just return to the desktop, Go to PowerPoint Options (Tools>Options or Logo PowerPoint options in 2007+).

Remove the check from "End with black slide". Resave and carry on.



This will hold for every show until the setting is changed. It is not saved with the file.


"To force the presentation to end without the black screen on every computer, add an action button or autoshape on your last slide within the presentation.

You can now set the . . .action setting to "end show". This will force your presentation to end without displaying the final black screen and end of slide show message.

123PPT.com



See all Topics

Sunday, August 20, 2017

Learn to Draw

No match cover required


Do you want to learn how to draw? Now you can online! Learn how to draw like an artist, from a professional artist. Begin by learning the fundamentals of drawing with easy to follow interactive instruction.

Learn how to draw a person and make it actually look like the person! Take drawing people further and learn how to draw a caricature of a person!

  • DRAWING BASICS
    You don't know how to draw? Begin learning how to draw.

  • DRAWING PEOPLE
    You know how to draw, but you can't draw people.

  • DRAW CARICATURES
    You want to draw funny people, but you don't know how?

LearntoDraw.com



See all Topics

Saturday, August 19, 2017

Slashed Zero

Oh!

ø

There is a discussion of the slashed zero at:
How to Insert a Slashed Zero (0 Overlaid with a /)

You can also download the Monaco font that has a slashed ø
(Monaco is an embeddable font)

Andale.ttf (Mono) has a dotted 0

Seagullscientific.com has a font called Crystal

Windows has a free font editor. Type eudcedit on the Start>Run line.
Vic Laurie has a description of the Private Character Editor- Eudcedit

You could also use the EQ field to create a strike through and assign it to an AutoCorrect entry.

{EQ \o (0,/)}

The easiest is, probably Alt+0216 or Alt+0248 It's a Latin "oh" with stroke, but it looks close.

The HTML character code is &oslash; ø



See all Topics

Friday, August 18, 2017

Zeros - Before and After

Nothing's a problem



"When you import data into Microsoft Access, trailing zeros may be lost. This will happen when you import data that is formatted to show these zeros, but where the zeros are not actually part of the data.
For example, in a Microsoft Excel workbook, you can format the number 1234 so that it will be displayed as 1234.000. When you import this workbook into a Microsoft Access table, the number will be displayed as 1234.
This article shows you how to preserve trailing zeros when you import data into Microsoft Access."


How to Preserve Trailing Zeros When Importing Data
Also:

Word — Decimal Point or Trailing Zeros Missing When You Merge Microsoft Access Database

Excel — Using a Custom Number Format to Display Leading Zeros



See all Topics

Thursday, August 17, 2017

Document Panes

Divided Doc


To divide the view of a document into panes, use the tiny divider mark in the upper-right corner of the document window.

It's above the up arrow at the top of the vertical scroll bar at the right side of the window.

Click on the marker and drag it to where you want the document window divided.

The size of the panes can be adjusted by dragging the divider up or down.

You can look at the top and bottom at the same time, or have one pane in Page View and the other in Outline View

Double click the marker to return to the full view.



See all Topics

Wednesday, August 16, 2017

Link to Word

Excel to Word connection


The Insert Hyperlink dialog will allow you to link to any file.

To link to a particular bookmark in a Word document, you can specify the bookmark by adding it yourself, adding a # (pound sign) plus the bookmark name to the path and file name.

C:\My Documents\MyDocument.doc#MyBookmark

To link to a page in a Word document, add a pound sign and the page number after the document path and file name:

C:\My Documents\MyDocument.doc#4

See Jon Peltier's hyperlink collection:
Hyperlinks



See all Topics

Tuesday, August 15, 2017

DNS Cache

Down the drain


Internet connection problems can, sometimes, be traced to a corrupted DNS cache.

Flushing this cache is an easy fix to many of these problems.

Here is how to fix that corrupted DNS cache.


  1. Click the Microsoft Start logo in the bottom left corner of the screen

  2. Click All Programs

  3. Click Accessories

  4. Right-click on Command Prompt

  5. Select Run As Administrator

  6. To view the DNS cache, type ipconfig /displaydns at a command prompt.

  7. In the command window type the following and then hit enter: ipconfig /flushdns

  8. You will see the following confirmation:

    Windows IP Configuration
    Successfully flushed the DNS Resolver Cache
    .




See all Topics

Monday, August 14, 2017

Presentation Review

Suggestions included


... (the) CEO of Whole Foods Market, John Mackey, gave a presentation called "Past, Present, and Future of Food" for an audience of 2000 in Berkeley, California.

... (he) was there to make a presentation and have a conversation that would . . . (show) a skeptical Berkeley audience that his large company still has the credibility to lead the food movement into the future.

. . .(the) 45-minute talk "aided" by 67 text-filled slides followed by an on-stage conversation

. . . Most people felt that the evening generally was successful given Mackey's sincerity, honesty, and general likability, but John Mackey's "multimedia presentation" as it was billed, could have been so much more.
----------------------------------------------------------------------------------------------------------------
. . . (the) presentation in Berkeley is a wonderful example of a presentation by an intelligent, personable, and passionate leader that easily could have been insanely great but was not. "[He] raced through the slides like a Ph.D. student presenting his dissertation," said the UC Berkeley reporter in the audience.

. . . it's a shame the presentation itself was not better planned and delivered given the importance of the topic and the profile of the speaker. Frankly, when you're trying to change the world, there is no excuse for being dull.
  • It's a story. This topic screams "Story" yet there was no story that I could follow.
    There were bits and pieces (some of it interesting) and way too much history and data-without-purpose.

  • Make it shorter. Cut the presentation part of the evening to 20-25 minutes and spend more time discussing on stage with the host, taking questions from the audience, etc.

  • Make it visual. There are no boring topics, but this topic is especially interesting and provocative.
Signal vs. Noise



See all Topics

Sunday, August 13, 2017

Unkept Secrets

From Microsoft

"After supporting Microsoft Excel for years, technical Support Professionals have found that some of the most powerful and useful features and functions in Microsoft Excel remain undiscovered by you, our users.

For example, you may create a new macro to perform a calculation when an existing formula or function can perform the task. Or, you may create a new macro to perform a task when you could use an existing feature that performs the task."

Undiscovered Tips About Microsoft Excel for Windows
Here are just a few:
  • Secret #1: Joining Text Together

  • Secret #3: Excluding Duplicate Items in a List

  • Secret #7: Using a Data Form

  • Secret #11: Linking a Text Box to Data in a Cell

  • Secret #12: Linking a Picture to a Cell Range

  • Secret #17: Using OFFSET to Manipulate Data in Cells that are Inserted

  • Secret #21: Using INDEX and MATCH to Look up Data

  • Secret #25: Returning Every Nth Number

  • Secret #29: Using One Keystroke to Create a new Chart or Worksheet

  • Secret #30: Setting up Multiple Print Areas on the Same Worksheet




See all Topics

Saturday, August 12, 2017

Ripple the Ribbon

Change the look


"Learn how you can create a custom Office Fluent Ribbon for an Access 2007-13 database by using only Office Fluent extensibility markup XML and macros.

Discover how to create a command space without writing any code and also learn about more advanced scenarios that require code."

Customizing the Office Fluent User Interface



Customize the Ribbon



See all Topics

Friday, August 11, 2017

Attachment Default Save

Set the solution



Here's how to set the default location that Outlook will use to save attachments:

  1. Click Start, and then click Run.

  2. In the Open box, type regedit, and then press ENTER.

  3. In Registry Editor, locate the following subkey in the registry:

    HKEY_CURRENT USER\Software\Microsoft\Office\11.0\Outlook\Options 

  4. On the Edit menu, point to New, and then click String Value.
  5. Type DefaultPath, and then press ENTER.

  6. Double-click the DefaultPath value.
    In the Edit String dialog box, in the Value data box, type the path, including the drive letter, to the folder that you want to use for your Outlook saved items, and then click OK.

  7. Exit Registry Editor.
Office.Microsoft.com



See all Topics

Thursday, August 10, 2017

New Excel Web Grabber

Web Toy


"The Excel 2007 Web Data Add-In makes it easy to use a Web page as a data source in Excel. The add-in plugs into Excel 2007 seamlessly, its entry point located on the Data Tab under the From Web option.

The system extracts data by learning from a user's selection of data they wish to capture into Excel. The more selections, the more the system is trained.
An example scenario: You wish to import and track data from MSN's weather page. Visit the site using the tool, enter Data Capture mode, and select a row or two of data from the table. Then click Select Similar, and the system will find similar data based on your previous selections.

You then can click Import and leverage Excel's rich data-editing capabilities, including the Refresh command, which will revisit the Web page and extract potentially new, updated data."

Web Data Add-In

(Webservices 2013)

From the Excel Blog team



See all Topics

Wednesday, August 09, 2017

Icon Tile Opacity

See through


To make the background of desktop icons transparent, go to:

Control Panel > System > Advanced

Click Settings in the Performance section.



On the Visual Effects tab, check "Use drop shadows for icon labels on the desktop".



See all Topics

Tuesday, August 08, 2017

Secret Slide Numbers

PPT does not forget


"PowerPoint numbers slides in several ways and it pays to know the difference.

When you create a new slide, it gets a unique SlideID, a unique number that's read-only… you can't change it manually or programmatically. Reordering the slides won't cause it to change. Once a slide is created, it keeps the same SlideID forever.

SlideIndex is the ordinal number of the slide in the presentation as it's currently arranged. Move a slide around in slide sorter and its SlideIndex changes to reflect its new position in the show."

Slide number, SlideID, SlideIndex and all that jazz

From Informit.com:
Sample Code to Print Slide Numbers for a Custom Show


"Microsoft PowerPoint has the ability to create custom slide shows, which are subsets of existing slides within your presentation. When you print a custom show, PowerPoint prints the page number defined for that slide. For example, if you print a custom show named My Show that consists of slides 2, 8, and 13 of your presentation, the numbers 2, 8, and 13 appear on the printed output.

This article provides a sample Microsoft Visual Basic for Applications macro that prints out a specified custom show and numbers the pages consecutively, beginning with the number 1."

Also:
Working with Slide Objects
and

Microsoft PowerPoint Objects



See all Topics

Monday, August 07, 2017

Themes and Templates

Need a look?



Themes are a collection of design elements and color schemes that can be applied to your web site to give it a unified appearance.

Templates include themes and layout modules to aid in quickly creating a web site. Templates can be purchased through the web, but here is one of the locations that provide free design help.

FreeLayouts.Livejournal.com
"Want a great new look for your website? Free Layouts.com offers you just that - select from our huge database of complete "look and feel" designs. Professional, sports, technical and others - they are all here. Free Web Templates are available for you to download now.

Look around and download your favorite page layouts - for free. Also, submit templates of your own and increase traffic to your website greatly. Currently over 500 free HTML templates and 50 Flash templates for you to download!"




See all Topics

Sunday, August 06, 2017

Highlight the Current Control

Code vs. property


Many users have trouble knowing which text box on a form they're currently working with. One way to make it clear for users is to highlight the current one, for example, with a yellow background.
Access 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 Highlight(Stat As String) As Integer
Dim ctrl As Control
On Error Resume Next
Set ctrl = Screen.ActiveControl
If Stat = "GotFocus" Then
ctrl.BackColor = 65535
ElseIf Stat = "LostFocus" Then
ctrl.BackColor = 16777215
End If
End Function

Save and close the module, then open the form you want to apply the highlighting to in Design view.
Click the Code button and insert

Highlight("GotFocus")

in each text box control's GotFocus event procedure. Likewise, add

Highlight("LostFocus")

to each text box's LostFocus event procedure.
When you've finished,save the changes, close the VBE, and switch to Form view.

When you tab to a field, it's shaded yellow. When you tab away from the field, its background is restored to white.



See all Topics

Saturday, August 05, 2017

Wage is Too Minimum

Low pay by state


Since 1997, the federal minimum wage has been stuck at $5.15. The new Congress plans to introduce legislation raising the minimum wage to $7.25-an increase that is long overdue.

This minimum wage increase would boost earnings for 13 million American workers-9.8 percent of the United States workforce.

Six million families with children-46 percent of the total low wage-earning families with children-currently receive all of their earnings from minimum wage jobs.

Raising the minimum wage will increase annual earnings to $15,000 from $10,700.

Without this increase, a family of three supported by one minimum wage earner will live roughly $5,400 below the federal poverty line.

At the 350 largest public companies, the average CEO total direct compensation was $11.6 million in 2005. At this rate of compensation, it takes the average CEO only one hour and 55 minutes to earn the annual pay of a minimum wage worker.

Here is an interactive map that will show how your state relates to the others.

Minimum wage map



See all Topics

Friday, August 04, 2017

Calendars - Perpetual

It's that year again


One Month and One Year perpetual calendars are available.

These Excel file calendars do not use macros and can be used in OpenOffice or other Excel compatible software.

  • Perpetual calendars with Week starting on Sunday

  • Perpetual calendars with Week starting on Monday

  • A simple "universal" one month calendar that will update for any month and any year (after 1900) just by changing a date cell.

  • A "universal" one year calendar that will show 12 months starting with a user defined Month and Year.
Start dates can be at the beginning of any year and any month.

DotXLS.com: Perpetual calendars
 
Microsoft: How to make calendars



See all Topics

Thursday, August 03, 2017

Custom Forms

Template collection



"At one time, Microsoft had a pretty nice collection of custom Outlook forms anyone could download. While a number of the forms are no longer available from Microsoft, a sizable collection remains. You can use these as-is or as a basis for your own custom forms."

See Slipstick.com - Sample Forms for the forms that are available.
  • Calendar Corporate Calendar
  • Expense Report
  • Help Desk
  • Holiday Card List
  • Job Candidates
  • Purchase Order Request
  • Real Estate Listings
  • Software Inventory Form
  • Student Attendance
  • Technical Repair Request
  • Time Card
  • Travel Request
  • Vacation Request
  • Web Site Listing
While they were all designed for Outlook in the Outlook 97/98 time frame, every one I've tried works with all versions of Outlook. However, the self-installers may not work due to security settings and you'll need to publish the form yourself. If you need step-by-step help to publish a form, see:
Outlook.net - Publish Form

OutlookCode.com - Send Form  

OutlookCode.com - Microsoft Outlook Custom Forms



See all Topics

Tuesday, August 01, 2017

Equations = Word 2007, 2010, 2013 and 2016

Real text


Remember, back in the old days of pre-2007-10 Word. Equations were a pain. Messy to set up with the Equation Editor and difficult to edit and reformat.


Brace {yourself} there have been changes.



  • Equations are regular Word text (not objects), so they're integrated with regular Word formatting.

  • High-quality display and typography: we're using TeX standards and a brand-new Math Font to produce great-looking equations

  • Two input methods: UI and Linear Format (keyboard syntax)

  • MathML support: now you can write an equation in Word, paste it into a calculating or graphing application, and get results!

Equation Demo
 
Equations in Word 2007, 2010, 2013 and 2016



See all Topics

Classroom Ideas

Ideas and tutorials



If you're looking for student projects and tutorials involving PowerPoint and more, look here:

PowerPoint - Creating Classroom Presentations

More information is located at:
EducationWorld.com

  • a search engine for educational Web sites only, a place where educators can find information without searching the entire Internet;
  • original content, including lesson plans, practical information for educators, information on how to integrate technology in the classroom, and articles written by education experts;
  • site reviews;
  • daily features and columns;
  • teacher and principal profiles;
  • Wire Side Chats with the important names in education;
  • employment listings.




See all Topics

Monday, July 31, 2017

Drop Down Menu

Validation



You can create a dropdown list that gets its choices from entries located in another part of the spreadsheet.

  1. Type the entries in one column or row.

    You can name the list by selecting the entries and then clicking in the Name box on the Formula bar and entering a name, and then press Enter.

  2. Next, select the cell where you want the dropdown list.

  3. On the Menu bar, go to the Data menu, click Validation, and then click the Settings tab.
    In the Allow box, click List.

  4. Enter the name of the list or its location.

    Make sure the reference or name is preceded with an equal sign (=).

    Make sure the In-cell dropdown check box is selected.

    If your list is short, you can type the entries directly in the Source box, separated by commas.
Debra Dalgleish, Excel MVP has a complete discussion on her Contextures.com site. She covers resizing the dropdown box. The site also includes other information about data validation:
Excel — Data Validation —Tips  



See all Topics

Sunday, July 30, 2017

Soup is no Joke

A ladle humor


"Garçon, le mouche dans ma soupe!"

"Non, monsieur, la mouche"

"Mon Dieu, you Belgians have wonderful eyesight!"

Soup Jokes



See all Topics

Saturday, July 29, 2017

Hiding Columns

In Datasheet view


When you're working in Datasheet View, you can easily hide columns containing data that you don't need to immediately work with.

To do so, select any field in the column and choose Format >Hide Columns from the menu bar.

As an alternative, right- click on the column's field name and select Hide Columns from the shortcut menu.

To redisplay hidden columns, select Format>Unhide Columns from the menu bar.
Then, select the check boxes next to the field names of any columns you want displayed and click OK.

You can select the Unhide Columns command even if no columns are hidden, allowing you to easily hide multiple columns by clearing the appropriate check boxes.



See all Topics

Friday, July 28, 2017

Footnote Customization

Line it out


In Normal View:
  1. Go to View>Footnotes.

  2. Click the All Footnotes box arrow, and select Footnote Separator from the drop-down list.

  3. Click on the existing separator line and delete it.

  4. Go to Format>Borders And Shading.

  5. On the Borders tab, select the border you want.

  6. Select the color you want.

  7. Click OK.
You will see the new separator line for your footnote will appear in Print Layout or Print Preview.

Also:
Footnote FAQ



See all Topics

Thursday, July 27, 2017

New Folder

Organize



If you are involved with a project, or you do a lot of work in a specific area, you may wish to create separate folders for e-mail related to that assignment.

You do not have to limit yourself to creating folders for e-mail; you can also create new Calendars or collections of Contacts.

One way to do this is to go to View>Folder list.

Select the "Root" of the directory tree, or choose a folder to create a sub-directory.

Right click the location and choose New Folder ...

Give it a name and then choose what information that folder should contain.

You can have a Contacts folder with names from a single company, or your personal list.

This way they will not be intermingled with your main collection.

You can do the same thing with personal Calendars.


New Folders

Managing Outlook Folders in Office 2003
Special Edition Using Microsoft Office Outlook 2003 from Que publishing

Microsoft Office Online:
Using Folders



See all Topics

Wednesday, July 26, 2017

Hide Dups

Format don't show



Duplicate entries can be formatted to "disappear", but still be available for computation.
  1. Select the range

  2. Goto Format>Conditional Formatting

  3. Select Formula Is

  4. Enter
    =A2=A1

  5. Click the Format button.

  6. Select a font color to match the cell background color.

  7. Click OK and OK
Dups can also stand out:
  1. Select the range

  2. Go to Format>Conditional Formatting

  3. Choose Formula Is

  4. Enter
    =COUNTIF($A$2:$A$100,A2)>1

  5. Click the Format button.

  6. Select a font or background color for highlighting.

  7. Click OK and OK
Hide Duplicate Values

Also:
Hide Records with Duplicate Cell Entries



See all Topics

Tuesday, July 25, 2017

STIFF

The Curious Lives of Human Cadavers


By Mary Roach
ISBN 0-393-05093-9
W.W. Norton 2003


About the Author
Has written for Salon, Discover, New York Times Magazine

Book Description
For two thousand years, cadavers -- some willingly, some unwittingly -- have been involved in science's boldest strides and weirdest undertakings. They've tested France's first guillotines, ridden the NASA Space Shuttle, been crucified in a Parisian laboratory to test the authenticity of the Shroud of Turin, and helped solve the mystery of TWA Flight 800. For every new surgical procedure, from heart transplants to gender reassignment surgery, cadavers have been there alongside surgeons, making history in their quiet way.

In this fascinating, ennobling account, Mary Roach visits the good deeds of cadavers over the centuries -- from the anatomy labs and human-sourced pharmacies of medieval and nineteenth-century Europe to a human decay research facility in Tennessee, to a plastic surgery practice lab, to a Scandinavian funeral directors' conference on human composting.

Quote
Besides a study about what happens to our remains, Roach has this comment:

"Anthropologists will tell you that the reason people never dined regularly on other people is economics. While there existed, I am told, cultures in Central America that actually ranched humans -- kept enemy soldiers captive for awhile to fatten them up -- it was not practical to do so, because you had to give up more food to feed them than you'd gain in the end by eating them. Carnivores and omnivores, in other words, make lousy livestock."




See all Topics

Monday, July 24, 2017

Headline Animator

Up to date



Introducing the Headline Animator:

Unofficial Microsoft Office Stuff

FeedBurner.com
"We're happy to introduce our latest publisher service: the Headline Animator. When you burn your RSS or Atom feed with FeedBurner, you can take advantage of this cool, different way of looking at your feed.

Just by pasting some HTML code into, say, your email signature file or bulletin board profile, you'll get a nice little badge that always shows your latest five blog postings. No Javascript or Flash required -- we generate an animated GIF on-the-fly from your feed."




See all Topics

Sunday, July 23, 2017

Hue has the Color

Interactive Color Wheel


Richard Franzen has an interactive color wheel that you may want to play with.
You can experiment with saturation, intensity, hue, and luminosity.

SIH Wheel



See all Topics

Saturday, July 22, 2017

Where in the World is it Not

Trouble map


If it's not happening here, it's coming down over there.

Here's a Google map mashup of the world wide mashups.

Global Incident Map



See all Topics

Friday, July 21, 2017

EMail Fontcology

Comic vs. Arial


Does the font used in an email message color the perception of the reader?

"Summary: This study investigated the effect that a font has on the reader's perception of an email. Based on a previous study by Shaikh, Chaparro, and Fox (2006), a sample email message was presented in three fonts (Calibri, Comic Sans, and Gigi). The three chosen fonts represented a high, medium, and low level of congruency for email messages."


The Effect of Typeface on the Perception of Email

Also:

The Personality of Fonts



See all Topics

Thursday, July 20, 2017

Downloadable 2013 Books

On the Internet shelf



  • Downloadable book: Getting started with Office 2013


  • Downloadable and printable content (available in .doc, .pdf, or .xps file formats) about how to get started with Office 2013.

  • Downloadable book: Planning guide for Office 2013


  • Downloadable and printable content (available in .doc, .pdf, or .xps file formats) about how to plan a deployment of Office 2013.

  • Downloadable book: Deployment guide for Office 2013


  • Downloadable and printable content (available in .doc, .pdf, or .xps file formats) about how to deploy Office 2013.

  • Downloadable book: Group Policy for Office 2013


  • Downloadable and printable content (available in .doc, .pdf, or .xps file formats) about how to deploy and configure an installation of Office 2013.

  • Downloadable book: Operations guide for Office 2013

and more.

Technet.Microsoft.com



See all Topics

Wednesday, July 19, 2017

Translate on the Fly


Translate Text



Ahora usted puede exhibir un grado de la sofisticación que excede tu conocimiento


On the Tools menu, click Research.

  1. In the Search for list, select Translation.
  2. To change the languages used for translation, in the Research task pane, under Translation, select the languages you want to translate from and to.
Do one of the following:
  • To translate a specific word, press ALT and click a word. The results appear under Translation in the Research task pane.
  • To translate a short sentence, select the words, and then press ALT and click the selection. The results appear in the Research task pane under Translation.
  • To translate a whole document, in the Research task pane, under Translation, click Translate whole document A translation of your document appears in your Web browser
  • To translate a word or phrase, type the word or phrase in the Search for box, and then click Start Searching .
Also see:
Speaking of translating a fly, here's another kind of translation: BzzzPeek A collection of 'onomatopoeia' from around the world using sound recordings from native speakers imitating the sounds of mainly animals and vehicles.



See all Topics

Tuesday, July 18, 2017

5 of 10 Commandments - Access

Writ on tables


"And it came to pass that the cries and lamentations of the Access newbies were heard on high by the gods of the Database, and their hearts were moved to pity for their followers. And they opened their mouths and spake, saying: "Nevermore shall the young and innocent wander witless on their journeys!
  1. Thou shalt design normalized tables and understand thy fields and relationships before thou dost begin.
  2. Thou shalt never allow thy users to see or edit tables directly, but only through forms and thou shalt abhor the use of "Lookup Fields" which art the creation of the Evil One.
  3. Thou shalt choose a naming convention and abide by its wisdom and never allow spaces in thy names.
  4. Thou shalt write comments in your procedures and explain each variable.
  5. Thou shalt understand error handling and use it faithfully in all thy procedures.
  6. . . .

Thus spake the gods of the Database, and blessed be their names!"

The full list can be found on:
The Access Web



See all Topics

Monday, July 17, 2017

Browser Utensils

Tiny tools



Bookmarklets
Easy to use, free Java scripts.


"Bookmarklets are simple tools that extend the surf and search capabilities of Netscape and Explorer web browsers.

Bookmarklets are free.

Bookmarklets allow you to:
  • Modify the way you see someone else's webpage.
  • Extract data from a webpage.
  • Search more quickly, and in ways not possible with a search engine.
  • Navigate in new ways.
…and more. Over 150 bookmarklets are available."
Here's a list of available bookmarklets:

List of Offline Bookmarklets



See all Topics

Sunday, July 16, 2017

All Programs Sort

Alpha my Adobe


After a while, the list of programs on the All Programs list can get out of order.

Here's the super tech way to fix it:

Right click on the Programs menu and select Sort by Name.

Thank you very much.



See all Topics

Saturday, July 15, 2017

Show Suggestions

10-20-30


A show should have 10 slides, last no more than 20 minutes and have at least 30 point font.
Guy Kawasaki is a venture capitalist with some piquant points about presentations.

The 10-20-30 Rule



See all Topics

Friday, July 14, 2017

Resend Again

Send the same message


Here's how to resend a message. The intended recipient might have accidently deleted it or would just like to see it again.

Open the message. Now you'll see the correct menus:

In Outlook 2003 – look on the Actions menu.

In 2007+ it's under Other Actions




For 2010:

  1. In Mail, in the Navigation Pane (Navigation Pane: The column on the left side of the Outlook window that includes panes such as Shortcuts or Mail and the shortcuts or folders within each pane. Click a folder to show the items in the folder.), click Sent Items.
  2. Double-click the message that you want to resend.
  3. On the Message tab, in the Move group, click Actions, and then click Resend This Message.




See all Topics

Thursday, July 13, 2017

Numbers to Words

Cardinal numbers



You can create a User Defined Function in Access to covert numbers to words.
The function can be used in a calculated field or control in a form or report.

From the Microsoft Knowledgebase collection:
How to Convert a Numeric Value into English Words



Also:
The Access Web (MVPS)
Convert Currency ($500) into words (Five Hundred Dollars)

TECH on the Net.com
Convert currency into words
(The Access code also works in Excel)

To create Cardinal numbers in Excel see:
Excel - Numbers to Words
(The Excel code also works in Access)

Word appears to be the only Office app with a built in cardinal number function.

For Word see:
Word - Numbers to Words



See all Topics

Wednesday, July 12, 2017

Numbers to Words

Cardinal numbers



From the Microsoft Knowledgebase collection:

How to Convert a Numeric Value into English Words

This support article contains the VBA code needed to create a User Defined Function, You can, then, change 32.50 into "Thirty Two Dollars and Fifty Cents" by entering something like the following formula into a cell:

=SpellNumber(32.50)


Also:

For Access see:
Access- Numbers to Words


To create cardinal numbers in Word, see:
Word - Numbers to Words



See all Topics

Tuesday, July 11, 2017

Numbers to Words

Cardinal numbers



Word can format numbers in several ways when they are represented by field codes. The DollarText field code is one choice.

Press Ctrl-F9 to insert a pair of field-code delimiters, which resemble boldface curly brackets {}. (The brackets can not be entered directly from the keyboard).

Between the field-code delimiters, enter = followed by the number. Then append the DollarText field switch. The result should look like this:

{ =34,582.13 \*DollarText \*Firstcap }
There are spaces in the field. Here is how it should be entered:
{space=34,582.13space\*DollarTextspace
\*Firstcapspace}

Right-click on the field and choose Update Field. You should now see the number spelled out in words:

Thirty-four thousand five hundred eighty-two dollars and 13/100.

Word provides some other numeric field codes. Here are a few of the more useful ones:

{ =42 \*CardText } - forty-two
(Spell our page numbers with a fields like this { PAGE \*CardText \*Caps } )

{ =42 \*OrdText } - forty-second

{ =42 \*Ordinal } - 42nd

{ =42 \*ROMAN } - XLII

KB article:

How to Use DollarText to Convert Numbers to Cardinal Text

and:

Microsoft Word - General Switches for Field Codes

For Access see:
Access - Numbers to Words

To create Cardinal numbers in Excel see:
Excel - Numbers to Words



See all Topics

Monday, July 10, 2017

Print Web Pages

Control Internet Explorer


The first few attempts to print from the Explorer Browser usually turn out to be a mess.re are some hints that may help.


Print Pages in IE Without Headers or Footers



See all Topics

Sunday, July 09, 2017

Make Your Own Fonts

No molten lead required


Not satisfied with the billions of available typefaces for free or pay? Do it yourself.

"Okay. Fine. I'll let the secret out. This tutorial explains my personal font-making technique. It may not be the academically approved typographic design process, but it works for me, and it can be done on any Mac or PC with the proper software installed. You've been working with the alphabet since you were a small child. Now you can make a font of your own."


How to Make Your Own Fonts



See all Topics

Saturday, July 08, 2017

Color Feels Right

Colors and emotions


When you're mad, do you see teal?

"Color plays a vitally important role in the world in which we live. Color can sway thinking, change actions, and cause reactions. It can irritate or soothe your eyes, raise your blood pressure or suppress your appetite.

When used in the right ways, color can save on energy consumption. When used in the wrong ways, color can contribute to global pollution.

As a powerful form of communication, color is irreplaceable. Red means "stop" and green means "go." Traffic lights send this universal message. Likewise, the colors used for a product, web site, business card, or logo cause powerful reactions.

Explore : The concept of color can be approached from several disciplines: physiology, psychology, philosophy, and art."


ColorMatters.com



See all Topics

Friday, July 07, 2017

Time Interval

Run code at timed intervals


You may occasionally want to run a procedure associated with a form at set intervals. To do so, add the code to the form's Timer event procedure. Then, set the form's TimerInterval property to the number of milliseconds that should elapse between each time the code is run. (in Access 2007+, the TimerInterval property setting is a Long Integer value between 0 and 2,147,483,647.)

Keep in mind that you shouldn't use a very small TimerInterval, otherwise your application will likely suffer a performance hit. To prevent the Timer event from firing, set the TimerInterval to 0.

Also see:
HOW TO: Create a Stopwatch Form in Access



See all Topics

Thursday, July 06, 2017

Microsoft Bob

No second act



Bob
"Microsoft Bob was one of the most publicly scorned programs Microsoft has released. Microsoft, like other companies who made software for OS/2, BeOS, and others that flopped in the retail sector, learned a hard lesson; if you try to be a smart aleck in your user interface or application software, it won't sell. You might have a few loyal users that are supportive of your wit, but will they sustain your business?

And speaking of Bob's "creator," a lady named Melinda French was the Project Manager for Microsoft Bob and also came up with the concept of Bob's "personal guides" (and Microsoft Office has never been the same since 1996).

Ms. French went on to become none other than Mrs. Bill Gates."
Also see:

Melinda Gates goes public



See all Topics

Wednesday, July 05, 2017

Select Text

Pick a word


  • If you double click on a word, it will be selected.
    Triple click and you will select the paragraph.

  • If you hold down the CTRL key and click, you will select a sentence.
    (Word is looking for a period, so it will also stop after the period in "Mr. Smith")


  • Move the mouse pointer to the left side of the document. It will change to a NE (upper left) pointing arrow.

    • Click once and a line is selected; a line, not just a sentence.

    • Click twice to select the paragraph.

    • Click three times and the entire document will be selected.

  • Place the insertion point where you want the selection to begin, press F8, and use the arrow keys on the keyboard to highlight the selection. Press Esc to end the extended selection.

  • Click to the left of the first word you want selected. Hold down the Shift key and click to the right of the end of the selection.

  • Hold down the ALT key and drag down to select a "column"; perhaps the first two characters that precede a list of items.


Also:
See this link for a way to enter text for testing

Also:

Selecting Text from Word Tips.



See all Topics

Tuesday, July 04, 2017

Select by Code

Programmatically pick cells


Microsoft has provided 22 ways to select cells/ranges by using Visual Basic procedures in Excel.

Here are a few of the subjects covered:

  • How to Select a Cell on the Active Worksheet

  • How to Select a Cell on Another Worksheet in the Same Workbook

  • How to Select a Range of Cells on the Active Worksheet
  • How to Select a Named Range on a Worksheet in a Different Workbook

  • How to Select a Cell Relative to the Active Cell

  • How to Select the Union of Two or More Specified Ranges

  • How to Select the Intersection of Two or More Specified Ranges

  • How to Select the Last Cell of a Column of Contiguous Data

  • How to Select the Blank Cell at Bottom of a Column of Contiguous Data

How to select cells/ranges by using Visual Basic procedures

Dick Kusleika has some comments on the coding:
Spreadsheets are the Devil



See all Topics

Monday, July 03, 2017

Nameless Surfing

Masked strangers


Anonymous surfing is exactly what the terms suggests. You go online without revealing any of the personal or technical information on your computer. It's done by having a special computer -- called a proxy server -- screening you from the websites you are contacting. Your computer contacts only the proxy server, which contacts the website for you. The website, in turn, sees only your proxy server and not you. In addition to hiding your IP.

From Ask Bob Rankin:
Anonymous Web Surfing



See all Topics

Sunday, July 02, 2017

Animation Samples

A little taste


The samples on this site make use of advanced animations that are introduced in PowerPoint 2002/XP and above. They will not run correctly when viewing with PowerPoint 2000 or earlier versions. You are free to use it for your presentation as long as proper credit is given.

Note: The animations found in these presentations or showcases are done entirely using PowerPoint. NO animated gifs, video or flash are used.

Shawn Toh was awarded Microsoft Most Valuable Professional for PowerPoint (MVP PowerPoint) and has been certified as Microsoft Office Specialist (MOS PowerPoint, Word, Excel).

PPTHeaven.MVPS.org



See all Topics