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

Saturday, July 01, 2017

Sunrise, Sunset

Times




Here is a location that will give you times for sun and moon, rise and set,
Civil Twilight, Nautical Twilight. and Astronomical Twilight anywhere in the world.




SunriseSunset.com



See all Topics

Friday, June 30, 2017

Presentation Tips

Ideas



Unique Presentation Solutions
(See the list of articles under "Creative Techniques" .)

Terberg Design specializes in creating unique presentations. Here is an interview with Julie Terberg from Indezine.com.
PowerPoint Personality



See all Topics

Thursday, June 29, 2017

Word Calendar Template

Take control


"Customizable Word template for generating and printing Outlook weekly and monthly calendars.
  • Print any Outlook calendar that you have access to, including calendars from other users' mailboxes and Public Folders.
  • Add color coding by category or by type of item (one-day event, multiple-day event, etc.)
  • Specify time and date formats and the title for the calendar.
  • Freeware.
Outlook 365



See more at Slipstick.com



See all Topics

Wednesday, June 28, 2017

Getting 2010-13 Reference Guides

Where'd they hide that thing?


Wondering where your favorite Word 2003 commands are located in the new Word 2010-13 interface? Or just want to explore the rich, new design with a little guidance?

... rest the mouse pointer over a Word 2003 menu or button to learn its new location in Word 2010-13. To see an animation of the location of the command or button in Word 2010-13, just click it.


Command reference guides for:

Office 2010

Office 2013





See all Topics

Tuesday, June 27, 2017

Face New Fonts

The free type


UrbanFonts offers over 8,000 free typefaces and dingbats.



The winner is the person who dies with the most ampersands.

UrbanFonts.com



See all Topics

Monday, June 26, 2017

Share Your Show

Kinda' tube it


Let's say you spend all your time in PowerPoint. You don't have a video to post somewhere, and you want others to see your work.

Take heart! The solution is here.

You can save your PowerPoint show on the web in "U-Tube"y fashion.





Slideshare.net



See all Topics

Sunday, June 25, 2017

Comment code

Edit toolbar



You'll many times want to change blocks of code to comments in VBA modules; temporarily convert a block of VBA code to comments so that it's ignored during a trial run. Inserting an apostrophe before each line of code is a bother. Office 2000+ simplifies this task by letting you convert a block of code to comments with a click of a button.

Open any module in the Visual Basic Editor (VBE), and then choose View>Toolbars and choose Edit from the menu bar to display the Edit toolbar.

Select the lines of code that you want to turn into comments. Then, click the Comment Block button on the Edit toolbar (it's the sixth button in from the RIGHT end of the toolbar).
Each line of the selected code is now preceded with an apostrophe.



To convert the comments back to executable code, select the appropriate lines and click the Uncomment Block button, which is immediately to the right of the Comment Block button.
This, of course, works in any application that uses the VBE.

It's been suggested that two or three apostrophes (sometimes called inverted commas) be placed around existing comments. When the Comment Block is used, the original comments will not be removed.



See all Topics

Saturday, June 24, 2017

Data Security Charts

Ways to look closer



Professional statisticians typically have powerful software at their disposal to perform advanced analyses and create slick graphs. But many professionals in the quality field don't enjoy that luxury.

Faced with a limited budget, they must be resourceful with the software they already have. Besides, not everyone needs the capability to perform nonlinear regression with custom loss functions for maximum likelihood!

Fortunately, many occasional data analysts already own a versatile software capable of providing most basic quality analyses -- Microsoft Excel.

  • Shewhart control charts

  • Pareto charts

  • Simple box-and-whisker plots


Excel for Data Analysis



See all Topics

Friday, June 23, 2017

Google Searches

Some hints


Google still rules the search engine world. Here are a few tips on how to refine your info-hunt.

Tip #1: Use the Correct Methodology

Tip #2: Conduct an "Either/Or" Search

Tip #3: Include or Exclude Words in Your Search

Tip #4: Search for Similar Words

Tip #5: Search for an Exact Phrase

Tip #6: List Similar Pages

Tip #7: Fine-Tune Your Search with Other Operators

Tip #8: Search for Specific Facts

Tip #9: Search the Google Directory

Tip #10: Use Googles Other Specialized Searches

Ten Tips for Smarter Google Searches



See all Topics

Thursday, June 22, 2017

Shortcut Controls

Switch them into shape


There are four ways that Explorer uses to display folders and file.


  1. It will open a single pane window (no Explorer bar).

  2. It will allow the user to navigate out of the folder (i.e. to the folder’s parent and beyond).

  3. The default is for none of the items in a folder to yet be selected.

  4. If there is already an open Explorer window displaying that folder, then the operating system will switch to that existing view, as opposed to opening a new one.


You can display the alternatives by usinf=g switches.
  • /n forces it to open a new window, even if it duplicates a window that is already open.

  • /e uses Windows Explorer view (multi-paned).

  • /root,X restricts Explorer to showing only the contents of file folder X (and its sub-folders).

  • /select,Y automatically selects Y (either a file or folder).


For a complete explanation, go to:
CodeJacked.com



See all Topics

Wednesday, June 21, 2017

Airplanes

modèles de papie



Model Templates for paper airplanes


Also:

Collection of paper airplanes

Build the best paper airplane in the world

Record winning paper airplanes


More sites

Fiddler's Green paper airplane models, some free some for sale



See all Topics

Tuesday, June 20, 2017

Use Access or Excel

When to use one or the other


Use Access when you:
  • Require a relational database (multiple tables) to store your data.

  • Might need to add more tables, in the future, to an originally flat or nonrelational data set.

  • Keep a very large amount of data (thousands of entries).

  • Keep data that is mostly text.

  • Rely on multiple external databases to derive and analyze the data that you need.

  • Need to maintain constant connectivity to a large external database, such as one built by using Microsoft SQL Server.

  • Want to run complex queries.

  • Need many people working in the database and you want robust options that expose that data for updating.
Use Excel when you:
  • Require a flat or nonrelational view of your data (that is, you do not need a relational database with multiple tables).

  • This is especially true if that data is mostly numeric - for example, if you want to maintain a financial budget for a given year.

  • Want to run primarily calculations and statistical comparisons on your data - for example, if you want to show a cost/benefit analysis in your company's budget.

Use Access or Excel to manage your data



See all Topics

Monday, June 19, 2017

Changes in 2013

Ribbon plus

There were a number of changes in Outlook 2010-13. For one, it now uses the Ribbon rather than the toolbar.

Changes in Outlook 2013

Here are some suggestions if you need to migrate from '07:

Migration considerations for Outlook 2007



See all Topics

Sunday, June 18, 2017

Citations and Bibliography

2007+ feature


"What if you write a paper for your literature class, but an educational journal wants to publish it? You used MLA style for formatting the citations and bibliography, but the journal uses APA style. It would be tedious to edit every citation and revise the bibliography to switch them from one style to the other. Fortunately, Office Word 2007 can switch bibliography styles. Choose a different style, and Word automatically reformats all the citations and the bibliography.

What about the next time that you write a paper on a related subject? If your specialty is Mark Twain, you will probably cite many of his same works in more than one paper. Word stores your master list of sources for you. Whenever you start a new paper, you can choose from your list of sources for the citations that you make in that paper."


Academic features: citation & bibliography tools

Previous versions
Footnote, Endnote, and Bibliography Questions



See all Topics

Saturday, June 17, 2017

Menus via CSS

Code and directions


"The core of any Web site is the navigation mechanism, the menu. If Web sites are primarily about organizing and presenting content, a site's menu provides the means of traversing this information set.
In designing a Web navigation system, it is often difficult to balance the competing objectives of simplicity, flexibility, usability, and maintainability. Often very simple designs are not flexible; flexible designs trade off with usable ones; and easily maintainable designs are rarely even considered."

Build a Flexible CSS Web Navigation Architecture



See all Topics

Friday, June 16, 2017

How Access Grew

History



A history of Microsoft Access, including key features and milestones from the release of Access 1.0 to Access 2010.

20 years of Access

Also:



Old Access Versions



In Access 1.0, if you found the "Easter egg" list of developers, at the very end there was a pond with two birds floating around.

A large foot then comes down and crushes the pair of ducks. (Paradox was Microsoft's rival at the time.)



See all Topics

Thursday, June 15, 2017

Shortcuts

A few good ones


Here are some keyboard shortcuts that can be used when running a show:

N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or the SPACEBAR (or click the mouse)
Perform the next animation or advance to the next slide

P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE
Perform the previous animation or return to the previous slide

number+ENTER
Go to slide number



  • B or PERIOD
    Display a black screen, or return to the slide show from a black screen

    W or COMMA
    Display a white screen, or return to the slide show from a white screen

    S or PLUS SIGN
    Stop or restart an automatic slide show

    ESC, CTRL+BREAK, or HYPHEN
    End a slide show

    E
    Erase on-screen annotations

    H
    Go to the next hidden slide

    CTRL+P
    Redisplay hidden pointer and/or change the pointer to a pen

    CTRL+A
    Redisplay hidden pointer and/or change the pointer to an arrow

    CTRL+H
    Hide the pointer and navigation button immediately; prevent the pointer from appearing if your mouse is moved.

    CTRL+U
    Hide the pointer and navigation button in 15 seconds

    SHIFT+F10 (or right-click)
    Display the shortcut menu

    TAB
    Go to the first or next hyperlink on a slide

    SHIFT+TAB
    Go to the last or previous hyperlink on a slide

    ENTER while a hyperlink is selected
    Perform the “mouse click” behavior of the selected hyperlink

    SHIFT+ENTER while a hyperlink is selected
    Perform the “mouse over” behavior of the selected hyperlink


    • Ctrl-M: New slide
    • Ctrl-D: Duplicate the current slide
    • Ctrl-Shift-C: Copy Autoshape style
    • Ctrl-Shift-V: Paste Autoshape style
    • Ctrl-Shift G: Group objects
    • Ctrl-Shift H: Ungroup objects
    • Shift-F9: Toggle the grid on and off
    • Alt-F9: Toggle the guides on and off
    • F5: Start presentation
    • Right arrow: Next slide or build
    • Left arrow: Previous slide or build
    • Home: First slide
    • End: Last slide


    Also see: Support.Microsoft




    See all Topics
  • Wednesday, June 14, 2017

    Carophile

    All things auto


    "Jalopnik loves cars.

    Secret cars, concept cars, flying cars, vintage cars, tricked-out cars, red cars, black cars, blonde cars
    sometimes, cars just because of the curve of a hood."
    Jalopnik.com



    See all Topics

    Tuesday, June 13, 2017

    SQL Statements Automatically

    Hidden code


    If you're having trouble figuring out a complex SQL statement for use in code, you may be able to simplify the process by first setting it up the query you want in the query design grid.

    Once you've got it configured correctly, choose View >SQL view to reveal the underlying SQL statement, which you can copy and paste into your code.

    You may have to make minor modifications, but this technique often eliminates much of the hassle of manually constructing SQL statements.

    You can also tweak the underlying SQL code to adjust your Query. This code can also be copied and reused in other Queries after a little customizing.



    See all Topics

    Sunday, June 11, 2017

    VCard

    Pick a card



    If you wish to share information about yourself and your company when networking with others a handy solution is electronic business cards, called vCards (virtual business cards), which can be sent using Outlook 2000+.

    To send a vCard to an individual, open the contact and on the Actions menu, click "Forward as vCard". Outlook attaches the contact information in a vCard file called .vcf

    Note You can automatically include a vCard every time you send a message. Just add the vCard to your signature!

    If you want to be able to insert a vCard in a message that you have already started, save the file for that vCard to a convenient location where you can access it.

    Open the contact, on the File menu, click "Export to vCard". Specify the location where you want to save the file, and then click Save. When you want to insert the file in an item that you have opened, on the Insert menu in the item, click File, and then select the .vcf file.

    In the message that contains the vCard you received, double-click the vCard attachment.
    Add any other information you want about the contact, and then on the File menu, click "Save and Close".

    How to Use vCard in Outlook

    Signed, Sealed, and Delivered: Outlook's Signature and vCard Features

    Sharing Microsoft Outlook Calendar and Contacts



    See all Topics

    Easy Reading

    Clean up the screen


    Word 2003 introduced a view of documents that eliminates a lot of the distractions of Task Panes and toolbars.

    It's called Reading Layout.

    Office.Microsoft.com:
    Word Reading Layout View



    In 2007-16 it's View>Full Screen Reading



    See all Topics

    Saturday, June 10, 2017

    Color Safe Not

    The other side of the wheel



    Death of the Websafe Color Palette?
    One of the givens of Web design, the holiest of holy truths, is the sanctity of the 216 websafe color palette. It's a rite of initiation for every Web designer or developer: Use only these colors, we were told, and don't question why.

    By David Lehn and Hadley Stern. David is a senior information architect and interface developer in the Milan office of Razorfish. Hadley is a senior designer in Razorfish's Boston office.



    See all Topics

    Friday, June 09, 2017

    Before Windows

    The old days



    Here's Guidebook, a website dedicated to preserving and showcasing Graphical User Interfaces.

    Remember GeoWorks?

    GeoWorks



    How about HP's NewWave.

    I bought NewWave when it came out, because surely HP would be beat out those new guys at MS.



    See all Topics

    Thursday, June 08, 2017

    Random Slides

    Vary the show


    Here is the code that can be used to mix up the order of your slides.


    Sub sort_rand()
    
    Dim i As Integer
    Dim myvalue As Integer
    Dim islides As Integer
    islides = ActivePresentation.Slides.Count
    For i = 1 To ActivePresentation.Slides.Count
    myvalue = Int((i * Rnd) + 1)
    ActiveWindow.ViewType = ppViewSlideSorter
    ActivePresentation.Slides(myvalue).Select
    ActiveWindow.Selection.Cut
    ActivePresentation.Slides(islides - 1).Select
    ActiveWindow.View.Paste
    Next
    
    End Sub

    PowerPoint Tools:
    Randomize the order of a PowerPoint presentation



    See all Topics

    Wednesday, June 07, 2017

    Legal Understanding

    See what they mean


    Through precise definitions, an act can be compared to what's allowed and what is prohibited.

    This very process of clarification can make the statutes difficult for the layman to understand.

    " Welcome to Nolo's Legal Glossary, your life-raft in the sea of legal jargon. Do you need to know the meaning of sprinkling trust, toxic tort or some equally puzzling legal term? Look it up here. Our glossary contains plain-English definitions for hundreds of legal terms, from the common to the bizarre."

    Toxic tort
    A personal injury caused by exposure to a toxic substance, such as asbestos or hazardous waste. Victims can sue for medical expenses, lost wages and pain and suffering.
    Willful tort
    A harmful act that is committed in an intentional and conscious way. For example, if your neighbor builds an ugly new fence and you intentionally run it down with your truck, that's a willful tort. But accidentally backing into the fence as you pull out of your driveway is not willful, though it's still a tort.


    Everybody's Legal Glossary



    See all Topics

    Tuesday, June 06, 2017

    View Multiple Page of an Access Report

    More than one at a time


    When you preview an Access report, you may want to see several pages at one time to examine the layout of the report.
    You may know that you can do so by choosing View >Pages from the menu bar. However, this technique limits how you view the pages -- you can only view 1, 2, 4, 8, or 12 at a time.

    For more control over how the pages are displayed, right-click on the report preview itself, and choose Multiple Pages from the shortcut menu.

    The default layout grid is 2 x 3 pages. However, if you click and drag with your mouse, you can select a range of up to 4 x 5 pages.



    See all Topics

    Monday, June 05, 2017

    Click to Type

    MacroButton



    When you open a template for a Memo, Letter, or Fax, you will see a field like this:

    [Click here and type Name]


    When you click and type the field goes away.

    Here's how to create on of your own.

    1. Place the Insertion point in the document where you want the field.

    2. Hit Ctrl+F9 to create field brackets {}.
      (they can not be just typed in)

    3. Between the brackets type:

      {MACROBUTTON NoMacro [Click here and type junk]}


    4. Press Alt+F9 and the field code will disappear.


    For more information see The Word MVP site:
     Using MacroButton fields.



    See all Topics

    Sunday, June 04, 2017

    Automatically Renumber Records

    Been looking for this


    What happens to a list when one record is deleted?

    If you need to correct the numbering, see these instructions.

    Automatically renumber the records in an Access table when one is deleted

    from Martin Green - FontStuff.com



    See all Topics

    Saturday, June 03, 2017

    Bricks as Pets

    Is it right?


    Tired of picking up after your pet?
    "Red Bricks (Brickus vermillius) are found around the world. Their association with humans is a long one, for bricks have been found in archaeological sites from the very ancient to the modern.

    The vast majority of bricks are working bricks, used mainly in construction of human houses and other buildings. A tiny minority of bricks, however, are unfortunately kept for human consumption, a use that is thankfully dwindling under the force of anti-brick-cruelty laws."


    Pet Brick FAQ


    The site also has more than enough information about rats.
    Rat Behavior and Biology



    See all Topics

    Thursday, June 01, 2017

    Grandma Knew Best

    Advice from the past



    History does repeat itself, so we might learn from advice from the past.

    "Take a step back in time as I share words of wisdom from my collection of about 1,000 classic advice books in a quest to solve modern-day dilemmas.

    The books span from 1822 to 1978 and cover the age-old topics of dating, love, living together, marriage, health, beauty, puberty, sex, etiquette, housekeeping, home economics, and home repairs. I've spent years scouting out used bookstores and thrift shops to locate these treasures of self help. "

    MissAbigail.com



    See all Topics

    Wednesday, May 31, 2017

    Send E-Mail with Access

    Automate the drill


    You can use Access as a data source and use Word to merge to Outlook. Here, however, is a way to do it from Access itself.
    "You can use the SendObject method to send a MAPI mail message programmatically in Microsoft Access. However, the SendObject method does not give you access to complete mail functionality, such as the ability to attach an external file or set message importance.

    The example that follows uses Automation to create and send a mail message that you can use to take advantage of many features in Microsoft Outlook that are not available with the SendObject method.

    There are six main steps to sending a Microsoft Outlook mail message by using Automation, as follows:

    1. Initialize the Outlook session.
    2. Create a new message.
    3. Add the recipients (To, CC, and BCC) and resolve their names.
    4. Set valid properties, such as the Subject, Body, and Importance.
    5. Add attachments (if any).
    6. Display/Send the message.

    Use Automation to send a Microsoft Outlook message using Access

    Access to E-Mail



    See all Topics

    Tuesday, May 30, 2017

    Categories

    Organization



    Create a new Contact, or edit an existing entry.

    At the bottom right corner of the dialog box is a button labeled
    Categories.

    You can assign your contact to multiple categories. You can add new ones to the Master Categories list.

    Now you can use Categories to sort entries and use them for Mail Merges.




    Tips::
    Five tips for organizing your Outlook Inbox

    Getting Started With Outlook 2010

    Basic Tasks in Outlook 2013



    See all Topics

    Monday, May 29, 2017

    A Way Cool Paint-Picker

    Just slap it on



    If you have decided to paint your home, or just this inside of the downstairs coat closet, the Behr paint people have a neat tool.

    Color Smart

    You still have to slop the paint on yourself, though.

    Here are other color generators:

    Top 8 Color Tools

    EasyRGB matches generated RGB values to paints, inks, etc.



    See all Topics

    Sunday, May 28, 2017

    Internet History

    Two tin cans



    From Forbes:

    The Internet: A Short History of Getting Connected.
    When the Defense Department issued a $19,800 contract on December 6, 1967, for the purpose of studying the "design and specification of a computer network," the world didn't take notice. But it should have. For, from that small, four-month study grew the ARPANET. And, from ARPANET emerged the Internet.

    Also:
    Living Internet
    "An elegantly organized tour of the history of the Internet -- both fun and informative -- a rare combination!"
    Steve Crocker, invented the Request For Comments.


    All About the Internet

    Hobbes' Internet Timeline v11.0


    A Brief History of the Internet

    "When the late Senator Ted Kennedy heard in 1968 that the pioneering Massachusetts company BBN had won the ARPA contract for an "interface message processor (IMP)," he sent a congratulatory telegram to BBN for their ecumenical spirit in winning the "interfaith message processor" contract."




    See all Topics

    Saturday, May 27, 2017

    Auto Show

    Also Dumb No Dot



    A PowerPoint show can be set up to run automatically when it is opened.

    To do this, you could go to File>Save As and choose PowerPoint Show (*.pps) from the Save as type: list.

    Another way is to change the extension (the three letters that appear after a file name such as Report.DOC).

    PowerPoint uses .PPT for normal files, .POT for templates.

    A PowerPoint show uses .PPS.

    Microsoft "dumbed down" Windows Explorer so that, by default, extensions are not displayed.

    To see them:
    1. Go to Windows Explorer.
    2. On the Menu bar go to Tools>Folder Options
      (Organize>Folder and Search Options in Vista)
    3. Click on the View tab.
    4. In the Advanced settings list, remove the check mark from "Hide file extensions for known file types."
    5. OK your way out.
    To change a regular PowerPoint file to a show:
    1. Locate the file in Windows Explorer.
    2. Right click the file name and choose Rename.
    3. Touch the End key on the keyboard and the Backspace three times.
    4. Enter the letters PPS
    5. Hit Enter.
    You now have a PowerPoint show that will automatically run when it is opened.

    (This also works with *.PPTX files



    See all Topics

    Friday, May 26, 2017

    Be a Local Scoble

    Photo Walk


    Robert Scoble, tech evangelist, has been touting the fun of Photowalking. Getting together with a group of like-minded people to just walk around and take pictures.

    Robert has made a number of videos that you can see on his blog The ScobleShow.

    Locally Kevin Freitas, a web developer and community supporter, solicited participation in a Tacoma area walk.

    Since digital film is free. After you've got a camera, why not set a walk up in your city?



    The results of our stroll can be seen at theses links:


    Thursday, May 25, 2017

    New Line in Memo

    Labels and Text boxes


    When you're using a form to enter text in a memo field, pressing [Enter] within the text inserts a line break.

    However, when you're working with a memo in a table's Datasheet view, pressing [Enter] moves the focus to the next field.

    You can force line breaks when you're entering text by pressing [Ctrl][Enter]. This technique also works with text fields and can be applied when you're entering text in labels or text boxes on a form.

    To permanently configure a text box so that pressing [Enter] inserts a new line, set its EnterKeyBehavior property equal to New Line In Field.



    See all Topics

    Wednesday, May 24, 2017

    Did You Know

    Nerd Conversation Nibblets



    Here's a part of the list of knowledge tidbits from Kelly's Bar

    Did You Know?
    • Barbie's measurements if she were life size: 39-23-33.
    • The dollar symbol ($) is a U combined with an S (U.S.)
    • Our eyes are always the same size from birth, but our nose and ears never stop growing.
    • The Statue of Liberty's tablet is two feet thick.
    • There are two credit cards for every person in the United States.
    • Hacky-sack was invented in Turkey.
    • Cat's urine glows under a blacklight.
    If you have doubts about these "facts", look at the Snopes Urban Legends Reference Pages



    See all Topics

    Tuesday, May 23, 2017

    Can the Narration

    Pre-Record



    PowerPoint and Narration
    By Geetesh Bajaj from Indezine

    "Narration is one of PowerPoint's least-used and most-misunderstood aspects. Many people try narration within PowerPoint only to get frustrated and give up.

    Surprisingly, most PowerPoint narration problems stem from outside PowerPoint - from incompatible sound cards to loose microphone cables or messed-up Multimedia properties in the Windows control panel.

    Or maybe you set your microphone volume settings very low or even mute! That's why I've provided a checklist of things you should do before you even attempt to begin narration in PowerPoint."




    See all Topics

    Monday, May 22, 2017

    Progress bars

    Don't go away



    If your macro is going to take a bit of time to complete, it is good manners to inform your users what is going on. If screen updating is turned off, they may think their machine has frozen.

    Andy Pope has some great charting examples and also demonstrates a number of
    Progress meters

    Here's a static example:

    Progress display

    John Walkenbach, also, has tips about how to create a Progress indicator

    also see:
    Chip Pearson



    See all Topics

    Sunday, May 21, 2017

    Color Blind

    Be seen by all



    Books on web design warn against using the colors red and green.

    One out of twenty people have problems with some form of color blindness.

    Here is a site that will let you check your web pages. You will be able to see the page as it appears to someone with one of the three main types of color deficit.

    Vischeck

    Normal



    Deuteranope color blindness

    hats, deuteranope



    Colorblind Web Page Filter


    How do things look to Color Blind People


    Web Colors



    See all Topics

    Friday, May 19, 2017

    President's Day or Presidents' Day

    Neither


    The third Monday in February is officially Washington's birthday, not Presidents' Day according to the federal government.

    Individual states may designate the day as anything they want, but the federal holiday is Washington's birthday.

    Snopes.com





    Interestingly enough, although Georgia celebrates Washington's Birthday, the Governor is accorded the right to designate when state holidays occur. In Georgia, Washington's Birthday is recognized the day after Christmas.

    There is an urban legend that when the Uniform Monday Holiday Act was implemented in 1971, President Richard Nixon issued a proclamation calling for a Presidents' Day on the third Monday to honor all U.S. presidents.

    Each February both the Law Library at the Library of Congress and the Nixon Library field an upsurge in calls on this question. No evidence of this exists in Nixon's official papers.

    Wikipedia



    See all Topics

    Open 2007-2010 in 2000-2003

    Not everyone is going to jump at once


    How to open and to save Word 2007, Excel 2007, and PowerPoint 2007 files in earlier versions of Office
    Microsoft Office Word, Microsoft Office Excel, and Microsoft Office PowerPoint versions 2000 through 2003 cannot natively open documents that are stored in the Office Open XML Formats in 2007 Microsoft Office programs.

    You can install the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats to open or to save 2007 Office files.

    Microsoft Office XP and 2003
    Word, Excel, and PowerPoint

    After you install the Compatibility Pack, you can use your existing version of Word, Excel, and PowerPoint to open, edit, and save the file formats that are new to Word 2007, Excel 2007, or PowerPoint 2007. For example:
    • You can open Word, Excel, or PowerPoint 2007 files by double-clicking them exactly as you do with your existing Word, Excel, and PowerPoint presentation(s).
    • You can save Word, Excel, or PowerPoint 2007 files by clicking the Save button in your version of Word, Excel, or PowerPoint.
    Microsoft Office 2000
    Word, Excel, and PowerPoint
    Word 2000
    • After you install the Compatibility Pack, you can open, edit, and save the document file formats that are new to Word 2007 within Word 2000.
    • You can open files in the formats that are new to Word 2007 by double-clicking the files.
    • You can save files in the formats that are new to Word 2007 by clicking Save in Word 2000.
    Excel 2000 and PowerPoint 2000
    • After you install the Compatibility Pack, you can open and save the file formats that are new to Excel 2007 and to PowerPoint 2007 from the Microsoft Windows operating system.
    • You can open files in the formats that are new to Excel 2007 and to PowerPoint 2007 by double-clicking the file on the desktop, in the My Documents folder, or in Microsoft Windows Explorer.
    • You can save files in the formats that are new to Excel 2007 and to PowerPoint 2007 by right-clicking an Excel 2000 file or a PowerPoint 2000 file and then clicking Save As.
    Compatibility Pack Functions

    Compatibility Pack Download




    See all Topics

    Thursday, May 18, 2017

    Wednesday, May 17, 2017

    Non Designers Type Book, The

    By Robin Williams


    ISBN 0-201-35367-9
    Peachpit Press 1998



    About the Author
    Williams teaches electronic typography and has written some excellent books on digital design.

    Anyone who has witnessed the horrific use of type on many personal web sites knows how badly these books are needed. Clear explanations and good illustrations are the hallmarks of both volumes.

    Also author of The PC is not a typewriter.

    Book Description
    Each short chapter explores a different type secret including use of evocative typography, tailoring typeface to project, working with spacing, punctuation marks, special characters, fonts, justification, and much more. It is written in the lively, engaging style that has made Williams one of the most popular computer authors today.

    It uses numerous examples to illustrate the subtle details that make the difference between good and sophisticated use of type. The non-platform specific, non-software specific approach to the book makes this a must-have for any designer's bookshelf - from type novices to more experienced graphic designers and typesetters.


    Quote
    "Most packages also have a discretionary hyphen, affectionately called a "dischy." If you type Ctrl+- (Control Hypen on a PC), the word will hyphenate at that point, that hyphen will disappear when the word moves to another location.

    Also (and this is the point), if you type a discretionary hyphen in front of a hyphenated word, it will not hyphenate at all, ever."




    See all Topics

    Tuesday, May 16, 2017

    Sort Listboxes

    We must have order




    "A nice way to enhance your application is to give your users the ability to sort the contents of listboxes.

    If you have a listbox with many records, this feature could be much appreciated. It's easy to manipulate the listbox RowSource property to accomplish this.

    A command button could be used to add an "Order By" clause to the SQL statement, and once the RowSource property is updated, the list is automatically sorted."


    An example showing exactly how to do this is available for download as a Zip file here:
    Sortable Link Boxes

    from Peter's Software



    See all Topics

    Monday, May 15, 2017

    Calendar Control

    Click for Date



    Office is full of ActiveX controls that provide extra gadgets in applications. One of these devices is a functioning calendar selection tool.

    "Did you ever need to check a date before you typed it into a document?

    This tutorial shows you how to create a pop-up calendar using the Microsoft ActiveX Calendar Control that is installed with Office.

    You will be able to call up the calendar with a keyboard shortcut, from a toolbar button or menu, or from the right-click context menu.

    When you select a date, it is automatically entered into your document at the insertion point."


    A Pop-up Calendar for Word

    Martin Green



    See all Topics

    Sunday, May 14, 2017

    1040 on a Spreadsheet

    Free tax forms


    All right, we spend our waking hours SUMming with Excel and then when one of the more stressful times of the year shows up, we turn it all over to TurboTax.

    Here is a collection of IRS forms Glenn Reeves has done as interlocking spreadsheets.

    The formulas are already set up; ready for data entry.
    "No PASSWORD is needed!

    If a cell is protected, it is because it contains a calculated value.

    Many times, a manual override cell is provided if you need to override the calculated value.

    After a while, you will figure out that the spreadsheet is completely functional without needing to unprotect it."



    (Included on the site are forms back to 1996.)

    http://www.excel1040.com



    See all Topics

    Saturday, May 13, 2017

    Update the FUI Ribbon

    Let the add-ins begin


    It is said that the Office 2007 Graphical User Interface Ribbon cannot be as easily changed or modified like it has been in previous versions.

    This may be partially true, but not all is lost.

    Here is some information from the equine's mouth:


    Learn how to customize the Ribbon user interface (UI) in the 2007+ Microsoft Office release. Also learn how new features in Microsoft Visual Studio 2005 Tools for the 2007+ Microsoft Office System support RAD development of Ribbon customization. (40 printed pages)

    Customizing the Office Ribbon


    Monsieurs MS also have a downloadable spreadsheets with the Control IDs. There are files for 2003 as well.

    Lists of Control IDs


    2007 Office System Add-In: Icons Gallery

    2013 Icons Gallery




    See all Topics

    Friday, May 12, 2017

    More More Free Templates

    Clean, professional layouts


    Besides some intriguing enterprise PowerPoint solutions, PresentationPoint.com has some free designs that you can download and adapt to your own uses.

    One of the designs is a timer:



    PresentationPoint.com



    See all Topics

    Thursday, May 11, 2017

    Properties Report

    Record of Records



    If you would like a report that includes all of the properties, relationships and permissions of the objects in your database, go to Tools>Analyze and choose Documenter...

    Access will create a VERY detailed report.

    Access Documentation


    Ezy Documenter




    See all Topics

    Wednesday, May 10, 2017

    Myths

    Say it ain't so




    My seven favorite myths about Outlook
    Diane Poremsky

    1. Outlook is the reason we have so many email viruses

    2. Outlook is the "full version" of the free Outlook Express

    3. Outlook's HTML is bloated, especially if you use Word as the editor

    4. Outlook has a newsreader (pre 2007)

    5. The preview pane is unsafe

    6. Word is a slow, bloated email editor

    7. Attachments run automatically
    Outlook Power Magazine



    See all Topics

    Tuesday, May 09, 2017

    Look for Bullets

    Find lists


    Unless you have used a style to create a bulleted list, it is difficult to search for them.

    This macro locates any bulleted list (wdListBullet) in your document.


    Sub FindBullet()
    Dim rngTarget As Word.Range
    Dim oPara As Word.Paragraph
    
    Set rngTarget = Selection.Range
    With rngTarget
    Call .Collapse(wdCollapseEnd)
    .End = ActiveDocument.Range.End
    
    For Each oPara In .Paragraphs
    If oPara.Range.ListFormat.ListType = _
    WdListType.wdListBullet Then
    oPara.Range.Select
    Exit For
    End If
    Next
    End With
    End Sub

    Other choices might be:
    wdListListNumOnly
    ListNum fields that can be used in the body of a paragraph.

    wdListMixedNumbering
    Mixed numeric list.

    wdListNoNumbering
    List with no bullets, numbering, or outlining.

    wdListOutlineNumbering
    Outlined list.

    wdListPictureBullet
    Picture bulleted list.

    wdListSimpleNumbering
    Simple numeric list.




    See all Topics

    Monday, May 08, 2017

    Statistical Functions

    Definitions and list


    Excel contains a slew of functions relating to statistical analysis.

    That's a slew not a skew.

    SKEW(number1,number2,...)

    Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry of a distribution around its mean.

    Positive skewness indicates a distribution with an asymmetric tail extending toward more positive values.

    Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.


    Statistical Functions

    Training - Statistical



    See all Topics

    Sunday, May 07, 2017

    Speedy Net Test

    How fast is it?


    Your connection to the internet is based on a number of factors; your machines capability, connection mode, and sometimes even the weather.
    Here are some sites that let you test your up and down speed.

    Speakeasy.net

    BandWidthPlace.com

    CNET.com

    And here's a cool one from:
    SpeedTest.net:





    See all Topics

    Saturday, May 06, 2017

    Verbose Status


    The whole story


    If you have trouble with slow startup, shutdown, logon, or logoff, you might try this procedure.


    This setting allows you to configure Windows so that you receive verbose startup, shutdown, logon, and logoff status messages!




    1. Go to Run and enter Regedit

    2. Find or create the key in

      HKLM\SOFTWARE\Microsoft\CurrentVersion\Winlogon.

    3. To enable verbose status messages create a new DWORD value called "verbosestatus" and set it to "1".


    4. In order to see the messages, an additional value called "DisableStatusMessages" should be set to "0".


    5. Restart Windows.
    VerboseStatus



    See all Topics

    Friday, May 05, 2017

    Home School Computers Available

    Need PCs?



    "Our economy is at a crucial turning point. Jobs in America require technological skills and computer expertise. The CFL program places computers in our classrooms and prepares our children to contribute and compete in the 21st century.

    The CFL website connects the registered needs of schools and educational nonprofit organizations with available computer equipment. The program allows federal agencies and private sector entities to transfer unneeded computers and related equipment to schools and educational nonprofit organizations, while giving special consideration to those with the greatest need."

    Computers for Learning (CFL) FAQ


    "Schools and educational nonprofit organizations can participate in the CFL program.

    A school is eligible to participate if it is a public, private, parochial, or home school serving pre-kindergarten through grade 12 students. Day care centers must provide a state approved preschool curriculum in order to participate. "




    See all Topics

    Thursday, May 04, 2017

    Define Relationships by Keyboard

    It's not a drag


    If you've played with Access, you know that you can create relationships by dragging fields from one table to another.

    There is another way to do it using just the keyboard.

    I don't know why you would do it this way, but let's assume you lent your mouse to your brother-in-law for the week-end. (?)


    1. Close any open tables.

    2. Use F11 to switch to the Database window.

    3. Press ALT+T to select the Tools menu, and then press R to open the Relationships window.

    4. If the Show Table dialog box does not appear, press ALT+R to select the Relationships menu, and then press T to open the Show Table dialog box.

    5. In the Show Table dialog box, select the first table that you want to relate, and then press ENTER to add it to the Relationships window.

    6. Repeat step 5 for any other tables you want to relate, and then press ALT+C to close the Show Table dialog box.

    7. Press ALT+R to select the Relationships menu, and then press R to open the Edit Relationships dialog box.

    8. Press ALT+N to open the Create New dialog box.

    9. In the Left Table Name box, select the name of the table that contains the primary key.

    10. In the Right Table Name box, select the name of the table that contains the foreign key.

    11. In the Left Column Name box, select the primary key field, and in the Right Column Name box, select the foreign key field.

    12. Press ENTER.

    13. In the Edit Relationships dialog box, use the arrow keys to make sure that the two columns contain the field names you want.

    14. Press ALT+C to create the relationship.
    Support.Microsoft.com:
    Define relationships by using the keyboard  




    See all Topics

    Wednesday, May 03, 2017

    Font Properties Plus

    Everything you need to know


    To embed a font in a document or slide show so it can be displayed on any other machine, the font must support that action. The standard Windows properties statement does not show all the needed information.

    The bottom of this illustration shows the standard information shown when you right-click a font file, and choose properties. The two views at the top are what appear when the Microsoft Font properties extension is installed.


    Font Properties

    If you right click on a font file in Windows its basic properties are displayed. The Font properties extension adds several new property tabs to this properties dialog box. These include information relating to font origination and copyright, the type sizes to which hinting and smoothing are applied, and the code pages supported by extended character sets.

    It also will tell you if the font can be embedded and/or edited in a document.



    Protected
    The font may not be embedded, copied, or modified. If you use a protected font in a document and if the document is opened on a computer that does not have the font installed on it, a font substitution occurs. Word substitutes the closest font available on the computer for the missing protected font.
    Print/Preview
    The font is embedded and temporarily loaded on the target computer. Documents that contain print/preview fonts must be opened read-only, and no edits are stored in the document. Embedding a font of this nature has the least impact on file size increase.
    Editable
    The font behaves just like the print/preview fonts, except that you may also apply the font to other text in the same document.
    Installable
    The font is installed on the target computer permanently when you open the document. This allows you to use the new fonts as if you installed the fonts directly into Windows yourself. This type of embedded font has the greatest impact on file size because the entire font or fonts are included with the document.


    Versionand Features tabs
    The Version tab includes version and date information. The Features tab describes the font in terms of number of glyphs, number of kerning pairs, the possible existence of a euro symbol and the presence of embedded bitmaps within the font.

    Linkstab
    If a font doesn't include a Web site URL, but does include a 'vendor ID code' a link will be provided to Microsoft's font vendor database.

    Font properties extension, version 2.3
    (32-bit only)



    See all Topics

    Tuesday, May 02, 2017

    Result is a picture

    If 4, show kumquat


    Allen Wyatt has a cool procedure that will let you show a picture of an object on your spreadsheet depending on a value.

    Maybe a snow suit when it's 29 or, say, a pair of bloomers when the computed temperature is 70.

    The procedure does not use any VBA, just equations and bright thinking.

    ExcelRibbon.Tips.net

    Display Images based on a Result



    See all Topics

    Monday, May 01, 2017

    Send Large Files

    Surpass Attachments


    Some email services such as Hotmail and Yahoo mail only allow email attachments up to 10 MB in size.

    If you need to send larger files take a look at services such as YouSendIt.

    "The Services provide a user the ability to send a file to one or more recipients identified by a valid email address. The Services operate by storing the specified User File on a YouSendIt server and then sending to the recipient(s) an email that contains a link to the User File.
    The recipient(s) can then access and download the User File by clicking on the link."


    Hightail.com

    Also:

    DropSend.com

    Top 6 Services to Send Large Files



    See all Topics

    Sunday, April 30, 2017

    Back Me Up

    Tomorrow is too late



    There is a company called the Argentum Corporation. They produce some commercial products to help organize files and facilitate backups.

    They, also, provide a free Back up guide
    "This backup guide focuses on backing up in general, assists you in finding important data on your computer, explains you how to locate the proper paths, files and folders that may be recommended for regular backup.
    The following topics are covered in detail:
    • My Documents backup,
    • Outlook data backup,
    • E-mail backup (Outlook Express),
    • registry backup,
    • messenger backup (ICQ, MSN, Yahoo!, AOL),
    • system folders backup and more"




    See all Topics

    Friday, April 28, 2017

    Create Animation Schemes

    Roll your own



    When you click on Slide Show>Animation Schemes, the task pane will display pre-set animations.

    You can create your own Animation Schemes.

    Shyam Pillai from PowerPoint Skphub.com details the steps to take and a downloadable template.

    Animation Schemes in PowerPoint

    "The best part is that you can add/modify and distribute animation schemes of your own.
    All the schemes are present in a read-only file quikanim.ppt located in
    C:\Program Files\Microsoft Office\Office10\1033 

    (the path may vary depending on the drive and installation folder).
    This file is essentially a normal PowerPoint file. You can open the file in PowerPoint directly. However it is best to remove the read-only flag before opening it."




    See all Topics

    Thursday, April 27, 2017

    Tiny Trebuchet

    Pumpkin (seed) flinger


    Something there is that is fascinated by hurling things through the air. The medievals tossed oil and rocks.
    Today it's mostly Fall vegetables.

    Here's away to bring the machine down to desk level and make cubical living even more dangerous.



    Build your own 3" trebuchet out of paperclips

    Also:
    Build a Trebuchet in your backyard



    See all Topics

    Wednesday, April 26, 2017

    Search the Way You Want

    It's your choice


    Using Find in Access can be frustrating when you forget to change the search options.

    You can change the defaults to something closer to your personal search preferences.

    To do so, select Tools>Options from the menu bar (the Office Logo in 2007).

    Then, click on the Edit>Find tab (under Advanced in 2007) and select the option button you want from Default Find>Replace Behavior.


    • Fast Search is the default, and causes Access to search the current field for an exact match to your criteria.

    • General Search, searches all fields and matches any part of the field.

    • Start Of Field Search, searches the current field for matches between your search string and the beginning characters in the field.

    When you've made your selection, click OK.



    See all Topics