Thursday, November 23, 2017

Zoom Box Fonts

Customize



Change the appearance of text in Access' Zoom box

Access' Zoom box, allows you to display the contents of a text box in a dialog box for easier editing and viewing. Although viewing long expressions is more convenient in the Zoom box, it is still sometimes difficult to follow what is displayed due to the font Access uses by default.

Access 20xx allows you to change the font that the Zoom box uses. To display the Zoom box, select the text box you want to expand and press Shift+F2. Then, just click the Font button, set the options you want, and click OK. The settings you select are used whenever you display the Zoom box during your current instance of Access. However, the next time you start Access the Zoom box font settings will revert to their defaults



Zoom Box Font



See all Topics

Wednesday, November 22, 2017

IE Shortcuts

Finger flicks


A selection of keyboard shortcuts for IE.

Here are a few:


  • F11 Toggle between full-screen and regular views of the browser window in Internet Explorer

  • ALT + HOME Go to your home page

  • ALT + RIGHT ARROW Go to the next page

  • ALT + LEFT ARROW or BACKSPACE Go to the previous page

  • CTRL+ F Find on this page

  • CTRL + TAB or CTRL + SHFT + TAB Switch between tabs
More:

Browser shortcuts



See all Topics

Tuesday, November 21, 2017

Clippy's Revenge

Roll your own OA



The Office Assistant has taken a lot of hits, but it is missing in 2007, but still around in earlier versions.
If you want to play with it, see John Walkenbach's:

Create A Fake Clippy



Here is a creature you could use to replace Clippy:

Nerd Bird

There are other articles in the MS library about Agents and Assistants:

Animating Office Applications with Microsoft Agent



See all Topics

Monday, November 20, 2017

Numbers in Perspective

Visual concepts


"This new series looks at contemporary American culture through the austere lens of statistics. Each image portrays a specific quantity of something: fifteen million sheets of office paper (five minutes of paper use); 106,000 aluminum cans (thirty seconds of can consumption) and so on.

This project visually examines these vast and bizarre measures of our society, in large intricately detailed prints assembled from thousands of smaller photographs.

As with any large artwork, their scale carries a vital part of their substance which is lost in these little web images. Hopefully the JPEGs displayed here might be enough to arouse your curiosity to attend an exhibition, or to arrange one if you are in a position to do so.

The series is a work in progress, and new images will be posted as they are completed, so please stay tuned."






Building Blocks, 2007
16 feet tall x 32 feet wide in eighteen square panels, each sized 62x62".

Depicts nine million wooden ABC blocks, equal to the number of American children with no health insurance coverage in 2007.

chris jordan, Seattle



See all Topics

Sunday, November 19, 2017

Runtime and PDF

Add-in's complete


Great news, you can now redistribute and use the PDF and XPS add-in with your Runtime solution.
The Runtime's code has not been changed. Your existing runtime solutions can now officially be distributed with the PDF and XPS add-in by chaining the .msi for PDF and XPS into your install process for your app (after the Runtime).

You may copy and distribute the object code form of the add-in listed below together and for use only with the Microsoft Office Access Runtime software, subject to the license terms accompanying the Microsoft Office Access 2007 Runtime software download:
2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS (located at PDF add-in download)

Runtime for Access



See all Topics

Saturday, November 18, 2017

Task Panes

VBA at your own risk



From the MVPS.org site:

Word's Task Panes VBA Reference
The Mother of All Task Pane articles
By Steve Hudson

"Task Panes display within a Work Pane's area. A Work Pane is created by the combination of two objects. These objects are shrouded in misery and thwart most attempts to play with them. The whole area is hidden away from the Kill Cursor invoked with CTRL+ALT+-, which changes to a hand when waved over a Work Pane.
Functions are hidden away from the macro recorder. To make it easier, if it is not in this reference, it is hidden. It is like when a spy is caught and the government disavows all knowledge of their actions.
The Task Panes are spies from Microsoft that are known to only a few objects, in these versions of Office anyway.

Warning
The author gleefully notes at this point that the human race has enough intelligence to get itself into cauldrons of boiling water that it cannot climb out of and that means you and me both!
If you like to be ultra-safe, stay away from this reference and wait for MS to hand over full functionality. You will end up crashing Word many times and you can really damage your user interface."

(Ctrl+Alt+-, can be used to remove an item from a menu. Type the shortcut and then click on a menu item)



See all Topics

Friday, November 17, 2017

W3C Validation

Standards



Web pages are written in a language called Hyper Text Markup Language; HTML
The latest version of HTML is 4.01.

There is a move to upgrade the code to Extensible Hyper Text Markup Language.

XHTML is compatible with XML (EXtensible Markup Language) allowing applications to more easily exchange data.

In preparation for making the change, edit your web pages so that element and attribute names are in lower case. XHTML is case-sensitive.

Use <p> rather than <P>.

Also end tags are required. Make sure that <p> is followed by </p>.

<br> should be written <br /> and <hr> as <hr />.

For more information see:

The W3C validation site



See all Topics

Thursday, November 16, 2017

Annoying Hypertext Warnings

How to disable hyperlink warning messages in 2007+ Office programs


When you include links in PowerPoint, or other '07 applications, you may get this admonition:

Opening "path/filename".
Hyperlinks can be harmful to your computer and data. To protect your computer, click only those hyperlinks from trusted sources.
Do you want to continue?


To disable the hyperlink warnings in 2007+ Office programs when an http:// address or an ftp:// address is used, you must create a new registry subkey.

To do this, follow these steps:

  1. Click Start, and then click Run.

  2. In the Open dialog box, type regedit, and then click OK.

  3. In Registry Editor, locate one of the following registry subkeys:

    HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common 

    HKEY_CURRENT_USER\Software\Policies\Microsoft\Office\12.0\Common

    Note You only have to modify one of these registry subkeys. You do not have to modify both of them.

  4. Click the registry subkey, point to New on the Edit menu, and then click Key.

  5. Type Security, and then press ENTER to name the key.

  6. On the Edit menu, point to New, and then click DWORD Value.

  7. Type DisableHyperlinkWarning, and then press ENTER to name the entry.

  8. In the right pane, right-click DisableHyperlinkWarning, and then click Modify.

  9. In the Edit DWORD Value dialog box, click Decimal, and then type 1 under Value data.

    Note A value of 0 enables the hyperlink warning message. A value of 1 disables the hyperlink warning message.

  10. Click OK.

  11. Exit Registry Editor.
  12. 
    
How to disable hyperlink warning messages
Security warning message  



See all Topics

Wednesday, November 15, 2017

Scrub DVD Scratches

Methods tested


Which is better toothpaste or Brasso when it comes to cleaning that DVD?

Or



Paul Michael has done the testing for you and provides videos of the results.


Removing scratches



See all Topics

Tuesday, November 14, 2017

Some Issues in Word

A collection of hows


Here are a few:





See all Topics

Monday, November 13, 2017

Prevent Users from Copying Field Text

Copy or select


As you know, you can set a form field's Locked property to Yes to prevent users from changing the underlying data. However, users are still able to select and copy data from the field, and you may not always want this to be the case. The solution is to also set the field's Enabled property to No.

Ordinarily, setting the Enabled property this way causes the field and its associated label to be difficult to read. However, when you set the Enabled property to No and the Locked property to Yes, the fields and labels look exactly as they do when they're enabled for normal entry. The difference is that users will be unable to select or copy any of the displayed data.



See all Topics

Sunday, November 12, 2017

Instant Search

Search all your mail


"If you're buried in e-mail (and who isn't?), Instant Search in Outlook 2007+ can save the day for you - every day.
The new Instant Search helps you quickly find e-mail messages, appointments, contacts, or any Outlook item. You don't even need to know which folder the item is in.
Watch the demo to see how to use this fast search feature, and start finding what you want instantly."


Instant Search Demo

More Instant Search



See all Topics

Saturday, November 11, 2017

New Line

Shift Enter



When you hit the Enter key, the FrontPage/Expression Web editor inserts an HTML <p> (paragraph) tag. This appears as a double line space in a Web browser.

To insert a single line space (or line break) via an HTML <br> tag, just hold down the Shift key and hit Enter.

This happens when you use the

Enter key

Here's what happens with
Shift +Enter

You could also use Insert>Break... Normal Line Break, but that takes too long.

By the way, if you want your code to be XHTML compliant, use lower case for the elements and pair every <p> with a closing </p>

Differences with HTML

Single elements can be used with a built in closer such as:
<hr /> or <br />



See all Topics

Friday, November 10, 2017

Noodling for Flatheads

By Burkhard Bilger


ISBN 0-684-85010-9
Scribner 2000



About the Author

Has written for all the usual suspects: The New Yorker, The Atlantic Monthly, Harper's, and the New York Times.



Book Description
"Bilger kicks off the tour from his hometown in Oklahoma, where he 'noodles'--thrashes a limb around in catfish-thick waters--hoping to land a fabled 80-pound monster with his bare hands. In Louisiana, he challenges the misgivings any nonenthusiast might have about cockfighting.
Even though it's illegal in most of the country, the bloodsport is thriving in the Bayou State, replete with trade magazines, well-produced venues, and American Kennel Club-worthy breeding strategies. The same passion for efficiency goes into the moonshining business, where Bilger is taken under the wing of one of the few shiners willing to lead him through his sourmash operation. A few nights later, however, Bilger is on the other side, on a raid with the local sheriff.
Squirrel-brain consumption is still popular in hamlets throughout Kentucky, even after a report published in the New England Journal of Medicine blamed a neurological disease on the dish. Bilger treats each eccentric character with a distant respect and hints at the melancholy of losing tradition, no matter how bizarre."



Quote
"tick tick tick

I'm nostril-deep in murky water, sunk to the calves in gelatinous muck.

Noodling, I know, is the fishing equivalent of a shot in the dark. For his master's thesis at Mississippi State University, a fisheries biologist named Jay Francis spent three years noodling two rivers.

All told, he caught 35 fish in 1,362 tries: 1 fish for every 39 noodles."

To "noodle" is to dangle your arm in the water until a catfish swallows your hand. The fish record catch includes one at 111 pounds.
"When clamped on your arm, catfish also have an unfortunate tendency to bear down and spin , like a sharpener on a pencil."

... "once that thing gets to flouncin' and that sandpaper gets to rubbin', it can peel your hide plumb off."

Here's the trailer for the movie
Okie Noodling



See all Topics

Thursday, November 09, 2017

Compare — Combine

Changes in '07


For a number of reasons, including collaboration, documents need to be reconciled. A resultant or master document must be distilled from different versions.

Here are some directions:

Compare - Combine

Comparing and Combining Documents

Back in the old days of 2003, you could save "versions" of documents. That's gone:
Bye-Bye Versions



See all Topics

Tuesday, November 07, 2017

World Countdown or Up

Time to die


Here's a clock that shows what is happening second by second.

How many are being born and how many are dying and by what means.


PoodWaddle.com:

World Clock

See all Topics

Monday, November 06, 2017

VVe have a few Phakes

VVorrisome URLs


If there weren't enough things to look out for, Paul Ferguson warns us of the use of a double "V" in web addresses:

VVINDOWS.COM NS NS1.MYDOMAIN.COM
VVINDOWS.COM NS NS2.MYDOMAIN.COM
VVINDOWS.COM NS NS3.MYDOMAIN.COM
VVINDOWSVISTA.COM NS DNS1.MALKM.COM
VVINDOWSVISTA.COM NS DNS2.MALKM.COM

Here are a few of the domains that have been registered:

VVindows



See all Topics

Sunday, November 05, 2017

Enlarge and Shrink Picture

Get a close up


"Often when doing a presentation, you may want to enlarge an image using Emphasis: Grow.

You probably want to show a clearer view of a photograph. But enlarging with the Grow effect often ends up getting the image blurry/jagged.

Now it looks ugly, you wouldn't want to show others an enlarged but poor quality picture, do you?


PPTHeaven.mvps.org:
Enlarge Image



See all Topics

Saturday, November 04, 2017

Euro to Lira

Pint's a pound



This application allows you to complete many different types of conversions; it includes all the mathematical functions offered in Microsoft Calculator.

It will also do currency conversions.

Microsoft Calculator Plus

Exchange rates are downloaded from the European Central Bank.
You can enter non-European rates by hand.

A more extensive currency conversion tool can be found at:
The Full Universal Currency Converter®



None of them verify that a pint's a pound the world around.
How much does a gallon weigh?



See all Topics

Friday, November 03, 2017

Total Footer

Sum() it up



If you would like to show a total in the footer or each page of a report, you may have a problem. Access does not allow the SUM() function in the footer.

The way around this is to put a SUM() function in an unbound text box in another part of the report.

Choose Properties and set the visible property of the control to No.

In the footer, create another control using the "calculation" text box as the ControlSource.

The Sum() function, as well as the other aggregate (totals) functions can reference only a field and not a control.

From the Microsoft Knowledge base:

How to Sum a Calculation in a Report

How to Display and Total Subtotals from Subreports




See all Topics

Wednesday, November 01, 2017

Task Manager-Big Boy Style

In depth system examination



Here's a free gadget from Microsoft:


"Ever wondered which program has a particular file or directory open? Now you can find out. Process Explorer shows you information about which handles and DLLs processes have opened or loaded.

The unique capabilities of Process Explorer make it useful for tracking down DLL-version problems or handle leaks, and provide insight into the way Windows and applications work. "



"Process Explorer works on Windows XP +, Server 2003, and 64-bit versions of Windows for x64 and IA64 processors"


Process Explorer



See all Topics

Tuesday, October 31, 2017

Calculate Running Total

Using the OFFSET function


Adding up a running balance can be frustrating when new data is added or old transactions are removed.
"How to create a data list to manage transactions, add and delete rows from the list, and accurately calculate a running balance using the OFFSET function."
Cash flow using OFFSET.PDF

Office.Microsoft.com:
Calculate a running total



See all Topics

Monday, October 30, 2017

Define URL Parts

More than dot com


Google engineer and blogger Matt Cutts has defined the pieces that make up a Uniform Resource Locator.

At least as Google refers to them when they're sitting around in their backrooms
Domain

Dynamic URL
Fragment or a Named anchor



The Googlers I've talked to are split right down the middle on which way to refer it. Disputes on what to call it can be settled with arm wrestling, dance-offs, or drinking contests. Typically the fragment is used to refer to an internal section within a web document. In this case, the named anchor means "skip to 2 minutes and 30 seconds into the video."






Host





Parameters





Path





Port





Protocol





Second-level domain





Static url





Subdomain





Top-level domain



Parts of a URL



See all Topics

Sunday, October 29, 2017

Annotation Preservation

Hold that note



Remember the old days. You did your John Madden thing. You've scribbled notes all over the slide and would like to keep them. That old-fashioned 2002 version of PowerPoint couldn't help, but 2003+ will!

Not only can you save your highlights and underscores, but you can turn them on and off when you re-run the show.

Carefully mark up the slide and then at presentation time make it look like you do this sort of thing all the time on ESPN.

When you close the presentation you are asked if you want to save the changes.
You can't highlight text in PowerPoint like you can in Word, but you can do it with screen annotations




See all Topics

Saturday, October 28, 2017

Full Moon Stuff

50 things about the moon


The an article on moon detritus:

3 -Lunar eclipses - caused by the passage of the earth's shadow across the illuminated hemisphere - only occur during a full moon. However, because of the angle of tilt of both bodies the moon normally passes either north or south of the earth's shadow.

4 -The chances of being bitten by a dog are twice as high during a full moon, according to a study at Bradford Royal Infirmary, which reviewed 1,621 cases of dog bite between 1997 and 1999. However, a study at the University of Sydney in Australia concluded there was no identifiable relationship between the state of the moon and dog bites.

16 -In October 1939 in Springfield, Missouri, the full moon appeared to fall from the sky. The event was reported in the local newspaper but was later revealed to be a plunging weather balloon.

26 -The full moon may appear round, but is actually shaped like an egg with the pointed end facing earth.

33 -The full moon is the brightest object in the night sky. It has an apparent magnitude of -12.6 compared with the Sun's of -26.8.

50 -In a study of 1,000 tonsillectomy operations, 82 per cent of post-operative bleeding crises occurred nearer the full moon than the new moon, according to the Journal of the Florida Medical Association.

The sky at night



See all Topics

Friday, October 27, 2017

Google Guide

Get a Job



There are a number of templates installed in Word that will help in creating a good looking resume.
Get started on your job hunt with Word templates

Here are some suggestions about what a resume should look like:

About.com
Resume and Cover Letter Guide

The Riley Guide:
Prepare Your Resume for Emailing or Posting on the Internet


Want to work for Microsoft?

Microsoft's Zoe Goldring and Gretchen Ledgard:
What is it like to interview at Microsoft?

Chris Sells:
Interviewing at Microsoft

Blog:
Technical Careers@Microsoft



See all Topics

Resume Writing

Get a Job



There are a number of templates installed in Word that will help in creating a good looking resume.
Get started on your job hunt with Word templates

Here are some suggestions about what a resume should look like:

About.com
Resume and Cover Letter Guide

The Riley Guide:
Prepare Your Resume for Emailing or Posting on the Internet


Want to work for Microsoft?

Microsoft's Zoe Goldring and Gretchen Ledgard:
What is it like to interview at Microsoft?

Chris Sells:
Interviewing at Microsoft

Blog:
Technical Careers@Microsoft



See all Topics

Thursday, October 26, 2017

Insert Line Breaks With Code

Label Captions


If you've ever needed to insert line breaks in a message box prompt, you most likely built a string that incorporated a line feed or carriage return character. Unfortunately, label objects aren't as forgiving when it comes to using these characters.

If you're setting a label's Caption property with code, you'll find that the special control characters are interpreted as squares, since they're otherwise un-displayable.
To successfully insert a line break in a label caption, you need to include both a line feed character and a carriage return character, entered consecutively.

To do so, you can use the Chr() function, such as:

Me.Label1.Caption = "Line 1" & _
Chr(13) & Chr(10) & "Line 2"

However, you can also simplify your code using an built-in constant:
Me.Label1.Caption = "Line 1" & vbCrLf & "Line 2"




See all Topics

Wednesday, October 25, 2017

Zoom Box

Better view


Access does not provide much room to enter long expressions in queries, forms, or reports.
You can drag the column wider, but there is a neater, quicker method.

With the insertion point in the field, hit: SHIFT+F2.
A Zoom box opens. Enter the formula and hit OK.

New Folders


BTW: If you enter Field names in the Zoom box without square brackets, if the fields are recognized, Access will add the brackets.



See all Topics

Tuesday, October 24, 2017

Print Calendars

Good looking printouts


The standard calendar print out is dull:



The new free Calendar Assistant makes it more fun.



The Calendar Printing Assistant for Office Outlook 2007-13



See all Topics

Monday, October 23, 2017

Office Art

2007+ choices


Office 2007+ uses OfficeArt to format text boxes, graphics and pictures.

It's available in Word, Excel , and PowerPoint, but it is most active in PowerPoint and Excel.

Here's a description:

Office PPT Art




See all Topics

Sunday, October 22, 2017

Bad Typography

Ugly when you look close


"From the company that popularized Arial, here are three examples of bad typography in Microsoft Word.
Bad typesetting in Word finds its way into résumés, business plans, research papers, government documents, even published books.
These small inconsistencies and imperfections may be un-noticeable in small doses, but paragraph-after-paragraph they stack up-resulting in ugly, visually in-cohesive documents.
Word isn’t for professional typography work, but that's no excuse for these typography sins.

Arial:



Garamond



Here's one that shows it can be done right:

BatangChe





Examples of Bad Typography



See all Topics

Saturday, October 21, 2017

Google Guide

How to do dat


Why Take The Google Guide Tutorial?

Google Guide

"Google is so easy to use, why take this online tutorial? If you're like many people, you use only a fraction of Google's features and services. The more you know about how Google works, its features and capabilities, the better it can serve your needs.

Just as the best way to learn how to sail is to sail, the best way to learn how to search with Google is to search with Google. Consequently, this Google tutorial contains many examples and exercises designed to give you practice with the material presented and to inspire you to find amusing or useful information."

Using Search Operators:
Advanced Operators

Google Guide TOC:
Table of Contents

Also:
GoogleTutor.com

and
Googling for XML



See all Topics

Friday, October 20, 2017

CSS

Cascading Style Sheets



As a web page is formatted in Expression Web/FrontPage, the style choices are applied to each element.
To format the body of the page, the HTML code might be:

<body background="blue" color="white" font-family="times, serif" font-size=10pt>

Every page on the site would need to be coded this way in order to have a consistent look.
Cascading Style Sheets will simplify the problem. On an external page the elements can be defined like this:

body {
background: blue;
color: white;
font-family: times, serif;
font-size: 10pt


Each page would contain a reference to the CSS definitions:

<head>
<link rel="stylesheet" type="text/css" href="mystyle.css">
</head>


When the element "body" is used it will now use the CSS references.

For more information see:

Using Cascading Style Sheets on Your Web Site - David Berry
and
Eric Meyer's Site

In this Blog:
CSS Links
and:
More Cascading Style Sheet Help



See all Topics

Thursday, October 19, 2017

Place Controls Where You Want

Works with other apps as well


The Snap To Grid feature is an invaluable tool for aligning controls when you're designing forms and reports. However, when you fine-tune the placement of some controls, you'll probably want to move some of them to positions that aren't exactly aligned with the design grid.

You can temporarily disable the Snap To Grid feature by holding down the [Ctrl] key. Then, you can use your mouse or the cursor arrows to place the controls exactly where you want them.



See all Topics

Wednesday, October 18, 2017

Create a Template

More of a good thing


After putting together the ultimate proposal, or dunning notice, you can save the document as a template so that you don't have to re-invent the whole thing.

Here's how to do it in Word 2007-13.
(Earlier versions also use "Save As")


  1. Click the Microsoft Office Button , and then click Open.

  2. Open the document that you want.
    Make the changes that you want to appear in all new documents that you base on the template.

  3. Click the Microsoft Office Button , and then click Save As.

  4. In the Save As dialog box, click Templates if your computer is running Windows or Vista, or click Trusted Templates if your computer is running Windows XP.

  5. Give the new template a file name, select Word Template in the Save As type list, and then click Save.
Note You can also save the template as a Word Macro-Enabled Template (.dotm file) or a Word 97-2003 Template (.dot file).

Create a new template

Also:
Templates are digital stencils  



See all Topics

Tuesday, October 17, 2017

Read All About IT

Excel reading


Bastien Mensink, from the Netherlands, runs ASAP-Utilities.com.

He has aggregated the headlines from a number of Excel Blogs.

If you don't have them as part of your RSS list, you should.

Weblog Headines



See all Topics

Monday, October 16, 2017

Synch Time

Time Server


Things I've forgotten or never knew.

  1. Double click on the date and time on the taskbar to open the time applet.

  2. Click on the Internet Time tab.

  3. Choose a time server, and click on the Update Now button.

As long as you are connected to the internet, Windows will attempt to synchronize the time once per week.
You can type the name of a time server if you want to use one that is not listed. Only time servers that use the Simple Network Time Protocol (SNTP) will work. Inserting an Internet address that uses the Hypertext Transfer Protocol (HTTP) will not work. The time server time.windows.com is operated by Microsoft. The time server time.nist.gov is operated by the U.S. government. Other time servers provided by your computer's manufacturer might also be listed.



Also:
Time Flies Like an Arrow



See all Topics

Sunday, October 15, 2017

Foley Sounds

Clip Clop


Here's a subject you have heard about:

A Foley Artist 'recreates' sound effects for film, television and radio productions on a Foley Stage in a Post Production Sound Studio.
Using many different kinds of shoes and lots of props - car fenders, plates, glasses, chairs, and just about anything found at the side of the road - the Foley Artist can replace original sound completely or augment existing sounds to create a richer smoother track.
Almost every motion picture and television show you have ever seen and heard contains a Foley track!


NPR presented this story:
Jack Foley: Feet to the Stars

Also:
Art of Foley

Film Sound Q&A



See all Topics

Saturday, October 14, 2017

Hardcopy Relationships

Document database


When you're documenting your database applications, you may want to include the same visual diagram of your table relationships that's available through the Relationships window.
In Access 2000 thru 2003, this is easy. Simply display the Relationships window as usual and then choose File>Print Relationships from the menu bar. Doing so displays a report preview that you can then print or save.

In 2007-13, to just print out a report, find Database tools on the Ribbon and click on Database Documenter.

Relationships are at the bottom of the All Object Types tab





See all Topics

Friday, October 13, 2017

Life with PowerPoint

Cruel tips


" Don McMillan is "Technically Funny". Before he became a nationally known stand-up comedian, Don spent 10 years as an engineer at IBM, AT&T, and VLSI Technology. He knows what corporate life is all about. His show is funny, smart, clean, AND he is the ONLY comedian working in PowerPoint.


Life After Death by PowerPoint



Don McMillan



See all Topics

Thursday, October 12, 2017

Specifications for Excel 2007-2016

More flexibility


Lots of limits have been changed with 2007. The size of a worksheet is now 1,048,576 rows by 16,384 columns. The number of undo levels has gone up to 100.

Here are some more changes:

  • Worksheet and workbook specifications and limits

  • Calculation specifications and limits

  • Charting specifications and limits

  • PivotTable and PivotChart report specifications and limits

  • Shared workbook specifications and limits

Excel 2007-2016 Specifications



See all Topics

Wednesday, October 11, 2017

Piggyback on Gmail

An added tool


Google's Gmail is free and offers some features you can use in conjunction with your email program.


  • Send email to Gmail

  • Forwarding

  • Gmail spam control

  • Centralized Email

  • Additional email storage
"As well as a backup, it means you can easily access your messages via Internet terminal or mobile phone. Gmail is easily searched online or indexed offline using Google Desktop Search."
Here's a YouTube:
Gmail as your spam filter

Here's GMail's Fetch gadget:
How to set up Mail Fetcher



See all Topics

Tuesday, October 10, 2017

Use the Ruler

Measure by Measure


Here is an article that explores the use of Word's Rulers.

About the only thing I don't see is that you can bring up the Page Setup dialog box by double clicking in the dark area of the ruler that indicates the margin.

Once again this tip comes from the Microsoft Word MVP site:

Ruler of all you survey:
How to make the best use of Word's rulers

Here's the spot to click to show rulers in Word 2007-13:





See all Topics

Monday, October 09, 2017

Clippy and Friends

Office Assistants


They were in the background, waiting to pounce.

Chris Pratley was there in the beginning:
Clippy and User Experiences


Stanford University:
Bob and the assistants
Social science research influences computer product design
..."They have found that to a very considerable extent people treat their computers and other computer-driven technology in the same ways that they treat people - as if the computer possessed reason, feelings, etc. People also treat pictures on screens as real objects, rather than as representations of real objects. This is relevant to anyone who wants to design technology or content that is as effective as it can be ..."


Also see:
Microsoft Bob
Clippy's Revenge



See all Topics

Sunday, October 08, 2017

Undo Excel

Level talk


In Excel 2007+. the number of levels of the "undo stack" was increased from 16 levels to 100.

Setting AutoFilters, showing/hiding detail in PivotTables, and grouping/ungrouping in PivotTables are now reversible.

And the undo stack is not cleared when Excel saves, be it an AutoSave or a Save by the user.

If you think the number of undos should be changed, here's how:


  1. Close any programs that are running.

  2. Click Start, click Run, type regedit in the Open box, and then click OK.

  3. In Registry Editor, expand one of the following registry subkeys, as appropriate for the version of Excel that you are running:

    Microsoft Office Excel 2010
    HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options

    Microsoft Office Excel 2007 uses Office\12.0\
    Microsoft Office Excel 2003 uses Office\11.0\
    Microsoft Excel 2002 uses Office\10.0\
    Microsoft Excel 2000 uses Office\9.0\


  4. On the Edit menu, point to New, and then click DWORD Value. Select New Value #1, type UndoHistory, and then press ENTER.

  5. On the Edit menu, click Modify.

  6. In the Edit DWORD Value dialog box, click Decimal under Base. Type a value between 0 and 100 in the Value box, click OK, and then exit Registry Editor.

  7. Start Excel. Excel stores an undo history for the number of actions that you specified in step 6.


Modify the number of undo levels
 

If you want to clear the undo stack, just run a macro such as:


Sub ClearUndo()
Range("A1").Copy Range("A1")
End Sub

Allen Wyatt:
Clearing the Undo stack



See all Topics

Saturday, October 07, 2017

Leaf Automation

Animation tip


This tutorial will walk you through the steps you can use to display a leaf as it floats and swirls across the screen.

There is also a file that you can download to see how its done.

PowerPoint Heaven:

Leaf Motion



See all Topics

Friday, October 06, 2017

Startup Switches for Access

Your choice


"This article shows you how to customize the way that Microsoft Office Access 2007+ starts by adding switches and parameters to the startup command. For example, you can have Office Access 2007+ open a specific file or run a specific macro when it starts."


Office.Microsoft.com

Also:

Support.Microsoft.com

and

VB123.com



See all Topics

Thursday, October 05, 2017

Screen Capture Gear

Better than PrtScn


You can add graphics to instructions using the built in PrtScn button, but there's not much versatility.

WritersUA by WinWriters, Inc has a discussion on some available apps that can help.



"Almost all of us need to include screen captures in our user assistance from time to time.

Of course, it's possible to do almost all of this by pressing + to copy the active window to the clipboard, and then pasting it into your favorite image-editing application.
However, for each screen capture this requires you to go through the same set of actions in order to crop, set the color depth, add borders or edge effects, and finally save it.
If you only take the occasional screen capture, then this is fine. But it can become extremely tedious and time-consuming if you have a large number of screens to capture."


Capture Tools



See all Topics

Wednesday, October 04, 2017

Non Stop Show

Stop the breakout


If a PowerPoint show is running, it can be stopped by using the escape key. Here's a way to prevent that from happening.

A User can exit out of a show accidentally/intentionally by pressing the ESC key. This add-in disables the functionality of the ESC key.

Note: If the show is set to run in Kiosk mode, disabling the ESC key will provide no way of getting out of a slide show, hence please ensure that you have provided an escape route (e.g an invisible shape set to End show) to exit the show.


No ESCape Add-in
by Shyam Pillai



See all Topics

Tuesday, October 03, 2017

Continued

More to come



You can place the word "More" or "Continued" at the bottom of every page except the last one.
The field, for those of you who know how to use them is:

{ IF { PAGE } = { NUMPAGES } "" "more" }

You can't just type in the brackets, you must use Insert>Field or Ctrl+F9.

Here is a more sophisticated formula:

{ IF { PAGE } < { NUMPAGES } "Continued on page {={PAGE} + 1}" "Last Page"}

Also see the Word MVP site:

How to control the page numbering in a Word document



See all Topics

Monday, October 02, 2017

Cmabrigde

Crorcet Sllipneg



"Aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht the frist and lsat ltteer be at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae the huamn mnid deos not raed ervey lteter by istlef, but the wrod as a wlohe."


Spanish:
"Sgeun un etsduio de una uivenrsdiad ignlsea, no ipmotra el odren en el que las ltears etsan ersciats, la uicna csoa ipormtnate es que la pmrirea y la utlima ltera esten ecsritas en la psiocion cocrrtea. El rsteo peuden estar ttaolmntee mal y aun pordas lerelo sin pobrleams. Etso es pquore no lemeos cada ltera por si msima preo la paalbra es un tdoo."

Russian:



See: Matt Davis - Cmabrigde, for a full discussion.

True or fsale?

TheSpellingBlog



See all Topics

Sunday, October 01, 2017

Use a Table Alias

to change names in a query


When you need to change the table name referenced in an existing Access query, it can be a pain. This is especially true if the query contains a large number of fields.

You typically might use an alias when you need to relate a table to itself or tables have long or unwieldy names.

If you make a practice of always using aliases in your queries, you can easily change which table is used by changing the one occurrence of the original table name in the query's FROM clause.
  1. To set a table alias in the query's Design view,
  2. Right-click on the table field list and choose Properties.
  3. Then, enter the alias name you want to use in the Alias text box.





See all Topics

Saturday, September 30, 2017

Google Shows

Presentation alternative


Google Docs now has a presentation element.

You can create documents, spreadsheets and presentations online.

They're a bit restricted and simplex at this point, but you can also import files and convert them for sharing or publication.

Google Docs

Review of Google presentation



See all Topics

Friday, September 29, 2017

And then there was Word

Remember the past



As one writer put it:
"Before the development of personal computers and word processing software, documents were produced on typewriters."

Chris Pratley, a Microsoft Program Manager, started with the Excel team in 1994 and then worked with the Word team. He has written about the early days:
Let's talk about Word


Also see:
WordStar Resource Site
(Includes a WordStar emulator for Word)


And:
In Search of Stupidity



See all Topics

Thursday, September 28, 2017

How to Start a Blog

Step-by-step tutorials

"If you’re like most people, you may not know where to get started. Starting a blog can be intimidating if you don’t have the required technological skills. Not to mention that the number of options available for starting a blog can be just plain confusing. The good news is that the free step-by-step guide on this site removes any confusion from the process, and requires only the most basic computer skills. So whether you’re 8 or 88, you can have your blog ready to go in less than 20 minutes."

Theblogstarter.com

See all Topics



See all Topics

Wednesday, September 27, 2017

Horrific Stories

What did your Grandparents do?


"Unsuspecting visitors in crime-infested Port Townsend, victims of shanghaiing, are sold to the highest bidder
Bunco Kelly, Spider Johnson and fourteen dead men on the deck of the Flying Price.
Urban East Hicks surrounded by Indians in 1886.
Earthquakes, riots, robberies, murders and a host of other terrifying events which created panic in the streets of communities throughout the Pacific Northwest.
Selected from the Clippings File of the Tacoma Public Library's Northwest Room /Special Collections, these true-life tales chillingly capture the dark side of our state's history."

Unsettling Events!



See all Topics

Tuesday, September 26, 2017

IE Spells

Missing feature found



For years, I've filled out forms on the net and then had to copy and paste into Word to check doubtful spelling.

Now there is a tool that should have been included in the first place.

"ieSpell is a free Internet Explorer browser extension that spell checks text input boxes on a webpage. It should come in particularly handy for users who do a lot of web-based text entry (e.g. web mails, forums, blogs, diaries).

Even if your web application already includes spell checking functionality, you might still want to install this utility because it is definitely much faster than a server-side solution. Plus you get to store and use your personal word list across all your applications, instead of maintaining separate ones on each application."


ieSpell



See all Topics

Monday, September 25, 2017

Access Tutorials

Learning Sites



Microsoft has created a web site for Office. Part of the site is devoted to tutorials touching on:

Word, Access, Publisher , Outlook, PowerPoint, InfoPath , Excel, Visio, OneNote, Expression, and Project.

The Access lessons are located here:

2013 Access Tutorials

Here's another site:

FunctionX Access tutorials




See all Topics

Sunday, September 24, 2017

Put IE Back on the Desktop

Regedit ahead


  1. Click Start, Run.

  2. Type "regedit.exe" (Without quotes).

  3. Navigate to the following registry key
    HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\HideDesktopIcons\NewStartPanel

  4. In the right hand pane, double-click {871C5380-42A0-1069-A2EA-08002B30309D} key.

  5. Enter dword value as 0 to enable the Internet Explorer icon on the Desktop.





Internet Explorer Desktop icon missing



See all Topics

Saturday, September 23, 2017

Wrist Time

Ding dong bling


Face it, you're never going to wear these watches. Some of them are just concepts, others are just too.

They are fun to look at.


Wrist Fashion is a Weblog that publishes the latest news, trends and products from the Wristwatch Industry in bite size morsels.


Brand: Venexx
Movement: Swiss Ronda Calibre 1063.1.90 quartz movement
Perfume: Approximately 60 sprays
Water Resistant: 30 metres


Perfume Watch

WristFashion.com



See all Topics

Friday, September 22, 2017

Flag Access Controls

Tag Property


The TAG property allows you to associate up to 2,084 characters of text with any form, report, section, or control. This is especially helpful when you want to single out a specific subset of controls.

For instance, say that you want to hide certain controls on a form when a user clicks a button.
You can flag which controls will be hidden by entering the word "Hide" (or any other consistent word) in each control's Tag property. Then, attach the following code to the command button's Click event procedure:

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "Hide" Then
ctl.Visible = False
End If
Next





See all Topics

Thursday, September 21, 2017

Convert Anything

Four pecks to a bushel



Convert
"Convert is an easy to use unit conversion program that will convert the most popular units of distance, temperature, volume, time, speed, mass, power, density, pressure, energy and many others, including the ability to create custom conversions!"

Convert



OnlineConversion.com does more conversions online.
(A Hogshead is 63 Gallons)


Also:
Convert between bits/bytes/kilobits/kilobytes/megabits/megabytes/gigabits/gigabytes



See all Topics

Wednesday, September 20, 2017

Vidler Video Storage

Player and free video storage

"You can upload many videos at once, and in various formats, too.(mov .avi .wmv .mpeg).

You also won't have to worry about file size - just keep any video you upload under 500 Mb.

Timed Tags
Moments on the timeline of your video are taggable, so you can classify and share instances in time. Timed tags are searchable, too - a great way to explore the content on viddler.com

Timed Comments
Your position in the timeline of a video determines where your comment will be posted to, which brings the discussion to a whole new level!

Use Your Webcam
Got a web camera? You can use Viddler to record footage directly from the camera to the website. There's no third-party software



"Viddler is very different from other video-delivery based websites, because we stream our videos instead of having the user download it.

That means you get to watch videos without having to wait for the entire video to load.

This is especially useful when you want to view the last few minutes of a very long video.

It's a secure system and prevents other people from watching the video (in ways they're not supposed to) or ripping the video off the site.

Video that you host with Viddler cannot be stolen, or used in any fashion, unless you set your sharing options to allow it."


Vidler.com



See all Topics

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