Monday, May 22, 2017

Progress bars

Don't go away



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

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

Here's a static example:

Progress display

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

also see:
Chip Pearson



See all Topics

Sunday, May 21, 2017

Color Blind

Be seen by all



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

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

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

Vischeck

Normal



Deuteranope color blindness

hats, deuteranope



Colorblind Web Page Filter


How do things look to Color Blind People


Web Colors



See all Topics

Friday, May 19, 2017

President's Day or Presidents' Day

Neither


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

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

Snopes.com





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

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

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

Wikipedia



See all Topics

Open 2007-2010 in 2000-2003

Not everyone is going to jump at once


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

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

Microsoft Office XP and 2003
Word, Excel, and PowerPoint

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

Compatibility Pack Download




See all Topics

Thursday, May 18, 2017

Wednesday, May 17, 2017

Non Designers Type Book, The

By Robin Williams


ISBN 0-201-35367-9
Peachpit Press 1998



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

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

Also author of The PC is not a typewriter.

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

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


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

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




See all Topics

Tuesday, May 16, 2017

Sort Listboxes

We must have order




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

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

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


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

from Peter's Software



See all Topics

Monday, May 15, 2017

Calendar Control

Click for Date



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

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

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

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

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


A Pop-up Calendar for Word

Martin Green



See all Topics

Sunday, May 14, 2017

1040 on a Spreadsheet

Free tax forms


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

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

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

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

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

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



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

http://www.excel1040.com



See all Topics

Saturday, May 13, 2017

Update the FUI Ribbon

Let the add-ins begin


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

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

Here is some information from the equine's mouth:


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

Customizing the Office Ribbon


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

Lists of Control IDs


2007 Office System Add-In: Icons Gallery

2013 Icons Gallery




See all Topics

Friday, May 12, 2017

More More Free Templates

Clean, professional layouts


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

One of the designs is a timer:



PresentationPoint.com



See all Topics

Thursday, May 11, 2017

Properties Report

Record of Records



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

Access will create a VERY detailed report.

Access Documentation


Ezy Documenter




See all Topics

Wednesday, May 10, 2017

Myths

Say it ain't so




My seven favorite myths about Outlook
Diane Poremsky

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

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

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

  4. Outlook has a newsreader (pre 2007)

  5. The preview pane is unsafe

  6. Word is a slow, bloated email editor

  7. Attachments run automatically
Outlook Power Magazine



See all Topics

Tuesday, May 09, 2017

Look for Bullets

Find lists


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

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


Sub FindBullet()
Dim rngTarget As Word.Range
Dim oPara As Word.Paragraph

Set rngTarget = Selection.Range
With rngTarget
Call .Collapse(wdCollapseEnd)
.End = ActiveDocument.Range.End

For Each oPara In .Paragraphs
If oPara.Range.ListFormat.ListType = _
WdListType.wdListBullet Then
oPara.Range.Select
Exit For
End If
Next
End With
End Sub

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

wdListMixedNumbering
Mixed numeric list.

wdListNoNumbering
List with no bullets, numbering, or outlining.

wdListOutlineNumbering
Outlined list.

wdListPictureBullet
Picture bulleted list.

wdListSimpleNumbering
Simple numeric list.




See all Topics

Monday, May 08, 2017

Statistical Functions

Definitions and list


Excel contains a slew of functions relating to statistical analysis.

That's a slew not a skew.

SKEW(number1,number2,...)

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

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

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


Statistical Functions

Training - Statistical



See all Topics

Sunday, May 07, 2017

Speedy Net Test

How fast is it?


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

Speakeasy.net

BandWidthPlace.com

CNET.com

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





See all Topics

Saturday, May 06, 2017

Verbose Status


The whole story


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


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




  1. Go to Run and enter Regedit

  2. Find or create the key in

    HKLM\SOFTWARE\Microsoft\CurrentVersion\Winlogon.

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


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


  5. Restart Windows.
VerboseStatus



See all Topics

Friday, May 05, 2017

Home School Computers Available

Need PCs?



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

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

Computers for Learning (CFL) FAQ


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

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




See all Topics

Thursday, May 04, 2017

Define Relationships by Keyboard

It's not a drag


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

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

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


  1. Close any open tables.

  2. Use F11 to switch to the Database window.

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

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

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

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

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

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

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

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

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

  12. Press ENTER.

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

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




See all Topics

Wednesday, May 03, 2017

Font Properties Plus

Everything you need to know


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

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


Font Properties

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

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



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


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

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

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



See all Topics

Tuesday, May 02, 2017

Result is a picture

If 4, show kumquat


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

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

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

ExcelRibbon.Tips.net

Display Images based on a Result



See all Topics

Monday, May 01, 2017

Send Large Files

Surpass Attachments


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

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

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


Hightail.com

Also:

DropSend.com

Top 6 Services to Send Large Files



See all Topics

Sunday, April 30, 2017

Back Me Up

Tomorrow is too late



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

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




See all Topics

Friday, April 28, 2017

Create Animation Schemes

Roll your own



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

You can create your own Animation Schemes.

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

Animation Schemes in PowerPoint

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

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




See all Topics

Thursday, April 27, 2017

Tiny Trebuchet

Pumpkin (seed) flinger


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

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



Build your own 3" trebuchet out of paperclips

Also:
Build a Trebuchet in your backyard



See all Topics

Wednesday, April 26, 2017

Search the Way You Want

It's your choice


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

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

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

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


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

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

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

When you've made your selection, click OK.



See all Topics

Tuesday, April 25, 2017

Make Senders Safe

Vouch for your friends


Add names to your Safe Senders List.

If the Junk E-mail Filter mistakenly marks an e-mail message as junk, you can add the sender of that message to the Safe Senders List. E-mail addresses and domain names that appear in the Safe Senders List are never treated as junk.

  1. On the Tools menu, click Options.

  2. On the Preferences tab, under E-mail, click Junk E-mail.

  3. Click the Safe Senders tab.

  4. Click Add.

    In the Enter an e-mail address or Internet domain name to be added to the list box, enter the name or address that you want to add. For example, you can add the following types of addresses:

    All@Once.com
    @Once.com
    Once.com

  5. Click OK. .



Information About the Safe Senders Option



See all Topics

Monday, April 24, 2017

Large Documents

Plan ahead


Jack M. Lyon has prepared a list of steps to be considered when working with large documents:
"I can't leave the topic of typesetting without explaining some of the things I learned on the last book I typeset--in Microsoft Word. The book had more than 400 pages and several hundred footnotes, and Word would have handled it better if I'd been more particular about the following:"

Typesetting Tips for Word



See all Topics

Sunday, April 23, 2017

Worksheet Name

Formula construction


There may come a time when you need to display the name of a worksheet.

This formula will do the job:
=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,31)

=CELL("filename",$A$1) 
returns the path, the Workbook name and the Worksheet name. (C:\Documents\[April.xls]\Costs)
=MID(text,start_num,num_chars) 
selects the text that starts at a certain point and goes on for a certain number of characters.

The formula, as written, looks at the full path and selects the first time a closing bracket (]) is found.

It then moves 1 character to the right and displays the results up to 31 characters.
(A worksheet name cannot be more that 31 characters long.)

You could include a reference to that cell on other worksheets.



See all Topics

Saturday, April 22, 2017

Hosts File

I've got your number


"...the Hosts file is like an address book. When you type an address like www.yahoo.com into your browser, the Hosts file is consulted to see if you have the IP address, or "telephone number," for that site. If you do, then your computer will "call it" and the site will open. If not, your computer will ask your ISP's (internet service provider) computer for the phone number before it can "call" that site.
Most of the time, you do not have addresses in your "address book," because you have not put any there. Therefore, most of the time your computer asks for the IP address from your ISP to find sites."

What is a Hosts file?

MVPS.org has a Hosts file that you can download and install. It includes a BAT file that renames the old file before it saves the new one.
Hosts



See all Topics

Friday, April 21, 2017

Busted Links

Verify


With the Expression Web Designer go to Site>Reports>Problems>Hyperlinks.
You will able to check if any links have failed and need to be fixed.

There are a few third-party shareware programs that do the same thing.

One of them is:

Xenu's Link Sleuth

It's free and will create a report that can be saved for reference.



See all Topics