Wednesday, April 30, 2014

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

Tuesday, April 29, 2014

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:

From John Walkenbach:

BAHTTEXT?
If you use Excel 2002+, you may have discovered the new BAHTTEXT worksheet function. This function converts a number to Thai text, and adds a suffix of "Baht".
This is the only built in function that translates numbers to words and then only in Thai.

For Access see:
Access- Numbers to Words


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



See all Topics

Monday, April 28, 2014

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

Sunday, April 27, 2014

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 7 Without Headers or Footers



See all Topics

Saturday, April 26, 2014

How to 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

Friday, April 25, 2014

Color seems 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

Thursday, April 24, 2014

Old Magazines

Covers and ads


Remember the old magazines that caused young kids to drool over diesel engines?



ModernMechanics.com



See all Topics

Wednesday, April 23, 2014

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

Tuesday, April 22, 2014

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

Monday, April 21, 2014

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

Sunday, April 20, 2014

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

Saturday, April 19, 2014

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

Friday, April 18, 2014

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

Thursday, April 17, 2014

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

Wednesday, April 16, 2014

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

Tuesday, April 15, 2014

Word Calendar Template

Take control



You can print a copy of your calendar in Outlook, but you don't have much control over its formatting.

Here's a solution:
Calendar Printing Assistant for Outlook 2007

Also:

"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 2010 (except 64bit)



See more at Slipstick.com




See all Topics

Monday, April 14, 2014

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

Sunday, April 13, 2014

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

Saturday, April 12, 2014

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

Friday, April 11, 2014

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

Thursday, April 10, 2014

Data Scrutiny 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

Wednesday, April 09, 2014

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

Tuesday, April 08, 2014

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

Monday, April 07, 2014

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

Sunday, April 06, 2014

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

Saturday, April 05, 2014

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

Friday, April 04, 2014

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

Thursday, April 03, 2014

Menus vie 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

Wednesday, April 02, 2014

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

Tuesday, April 01, 2014

Clippy, the April Fool

An unwelcome visitor


"Clippy is a simulated office assistant that, when ran, will hide in the background for 1 minute then popup in the lower right hand corner of the screen and say something useless. Every minute, Clippy pops up spouting useless nonsense about your computer.

That is not all! Clippy comes with a dozen or so default messages, but Clippy can be customized to fit your needs. You can create a clippy.txt file within the same directory as Clippy and when loaded, it will read this file to figure out which hints to blurt to the screen.

Move your mouse pointer to the TOP LEFT corner of your screen. This will stop the program from running in memory. If you have successfully moved your mouse in the correct position, the program will close and display an About Box Screen. Once you close this screen, the program will exit. Exiting the software will allow Windows to delete the file."
RJLPranks





See all Topics