Sunday, August 31, 2014

Prevent Users From Coping 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

Saturday, August 30, 2014

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

Friday, August 29, 2014

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

Thursday, August 28, 2014

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

Wednesday, August 27, 2014

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, August 26, 2014

Windows Check Boxes

Select checks


Add check boxes to file views to make it easier to select several files at once, which can be useful if it is difficult for you to hold the CTRL key while clicking to select multiple files.

Step 1: Go to Control Panel>Appearance and Personalization>Click Folder Options.

Step 2: Click View tab and under Advanced Settings, Select Use Check boxes to select items






Change folder views and behavior



See all Topics

Monday, August 25, 2014

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.


PoodleWaddle.com:

World Clock



See all Topics

Sunday, August 24, 2014

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

Saturday, August 23, 2014

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

Friday, August 22, 2014

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

Thursday, August 21, 2014

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

How to Print a Group Footer at a Specific Location



See all Topics

Wednesday, August 20, 2014

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, August 19, 2014

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, August 18, 2014

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, August 17, 2014

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, August 16, 2014

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, August 15, 2014

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, August 14, 2014

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, August 13, 2014

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, August 12, 2014

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

Sunday, August 10, 2014

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

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, August 09, 2014

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

also:


Logoogle



See all Topics

Friday, August 08, 2014

CSS

Cascading Style Sheets



As a web page is formatted in 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, August 07, 2014

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

Tuesday, August 05, 2014

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

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, August 04, 2014

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, August 03, 2014

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, August 02, 2014

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, August 01, 2014

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