Friday, May 26, 2017

Be a Local Scoble

Photo Walk


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

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

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

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



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


Thursday, May 25, 2017

New Line in Memo

Labels and Text boxes


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

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

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

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



See all Topics

Wednesday, May 24, 2017

Did You Know

Nerd Conversation Nibblets



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

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



See all Topics

Tuesday, May 23, 2017

Can the Narration

Pre-Record



PowerPoint and Narration
By Geetesh Bajaj from Indezine

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

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

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




See all Topics

Monday, May 22, 2017

Progress bars

Don't go away



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

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

Here's a static example:

Progress display

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

also see:
Chip Pearson



See all Topics

Sunday, May 21, 2017

Color Blind

Be seen by all



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

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

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

Vischeck

Normal



Deuteranope color blindness

hats, deuteranope



Colorblind Web Page Filter


How do things look to Color Blind People


Web Colors



See all Topics

Friday, May 19, 2017

President's Day or Presidents' Day

Neither


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

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

Snopes.com





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

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

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

Wikipedia



See all Topics

Open 2007-2010 in 2000-2003

Not everyone is going to jump at once


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

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

Microsoft Office XP and 2003
Word, Excel, and PowerPoint

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

Compatibility Pack Download




See all Topics

Thursday, May 18, 2017

Wednesday, May 17, 2017

Non Designers Type Book, The

By Robin Williams


ISBN 0-201-35367-9
Peachpit Press 1998



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

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

Also author of The PC is not a typewriter.

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

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


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

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




See all Topics

Tuesday, May 16, 2017

Sort Listboxes

We must have order




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

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

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


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

from Peter's Software



See all Topics

Monday, May 15, 2017

Calendar Control

Click for Date



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

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

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

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

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


A Pop-up Calendar for Word

Martin Green



See all Topics

Sunday, May 14, 2017

1040 on a Spreadsheet

Free tax forms


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

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

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

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

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

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



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

http://www.excel1040.com



See all Topics

Saturday, May 13, 2017

Update the FUI Ribbon

Let the add-ins begin


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

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

Here is some information from the equine's mouth:


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

Customizing the Office Ribbon


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

Lists of Control IDs


2007 Office System Add-In: Icons Gallery

2013 Icons Gallery




See all Topics

Friday, May 12, 2017

More More Free Templates

Clean, professional layouts


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

One of the designs is a timer:



PresentationPoint.com



See all Topics

Thursday, May 11, 2017

Properties Report

Record of Records



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

Access will create a VERY detailed report.

Access Documentation


Ezy Documenter




See all Topics

Wednesday, May 10, 2017

Myths

Say it ain't so




My seven favorite myths about Outlook
Diane Poremsky

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

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

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

  4. Outlook has a newsreader (pre 2007)

  5. The preview pane is unsafe

  6. Word is a slow, bloated email editor

  7. Attachments run automatically
Outlook Power Magazine



See all Topics

Tuesday, May 09, 2017

Look for Bullets

Find lists


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

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


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

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

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

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

wdListMixedNumbering
Mixed numeric list.

wdListNoNumbering
List with no bullets, numbering, or outlining.

wdListOutlineNumbering
Outlined list.

wdListPictureBullet
Picture bulleted list.

wdListSimpleNumbering
Simple numeric list.




See all Topics

Monday, May 08, 2017

Statistical Functions

Definitions and list


Excel contains a slew of functions relating to statistical analysis.

That's a slew not a skew.

SKEW(number1,number2,...)

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

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

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


Statistical Functions

Training - Statistical



See all Topics

Sunday, May 07, 2017

Speedy Net Test

How fast is it?


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

Speakeasy.net

BandWidthPlace.com

CNET.com

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





See all Topics

Saturday, May 06, 2017

Verbose Status


The whole story


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


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




  1. Go to Run and enter Regedit

  2. Find or create the key in

    HKLM\SOFTWARE\Microsoft\CurrentVersion\Winlogon.

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


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


  5. Restart Windows.
VerboseStatus



See all Topics

Friday, May 05, 2017

Home School Computers Available

Need PCs?



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

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

Computers for Learning (CFL) FAQ


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

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




See all Topics

Thursday, May 04, 2017

Define Relationships by Keyboard

It's not a drag


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

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

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


  1. Close any open tables.

  2. Use F11 to switch to the Database window.

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

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

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

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

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

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

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

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

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

  12. Press ENTER.

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

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




See all Topics

Wednesday, May 03, 2017

Font Properties Plus

Everything you need to know


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

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


Font Properties

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

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



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


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

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

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



See all Topics

Tuesday, May 02, 2017

Result is a picture

If 4, show kumquat


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

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

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

ExcelRibbon.Tips.net

Display Images based on a Result



See all Topics

Monday, May 01, 2017

Send Large Files

Surpass Attachments


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

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

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


Hightail.com

Also:

DropSend.com

Top 6 Services to Send Large Files



See all Topics

Sunday, April 30, 2017

Back Me Up

Tomorrow is too late



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

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




See all Topics

Friday, April 28, 2017

Create Animation Schemes

Roll your own



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

You can create your own Animation Schemes.

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

Animation Schemes in PowerPoint

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

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




See all Topics

Thursday, April 27, 2017

Tiny Trebuchet

Pumpkin (seed) flinger


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

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



Build your own 3" trebuchet out of paperclips

Also:
Build a Trebuchet in your backyard



See all Topics

Wednesday, April 26, 2017

Search the Way You Want

It's your choice


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

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

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

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


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

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

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

When you've made your selection, click OK.



See all Topics

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

Thursday, April 20, 2017

Squeezin' out the Pixals

Slim PP Fast


When you insert pictures into a PowerPoint show, the size of the file begins to bloat. There is a built in tool that helps.
  1. Select the graphic.
  2. Right-click and pick "Format Picture".
  3. Click the "Picture" tab and click on the "Compress" button.
  4. Click "Selected pictures" to compress the currently picture. Choose "All pictures in document" to handle all images in the show.
  5. In the "Change resolution" section, choose how your show is going to be presented.
  6. In the "Options" section, check both "Compress pictures" and "Delete cropped areas of pictures."
  7. OK your way out.
In PowerPoint 2007+ select the picture and look at the Picture Tools >Format group.

 


The PowerPoint & Office Art Team Blog:
Compress Pictures



See all Topics

Wednesday, April 19, 2017

View Related Fields

The whole thing


When designing a query, you'll often find the need to temporarily view fields beyond the ones you want shown in the final result.

To do so, you probably drag the relevant fields to the design grid and then delete them when you're done. However, there's an easier way to view the data that you typically want excluded in the query.

To do so:
  1. Open the query in Design view.
  2. Display the query's Properties sheet
  3. Set the Output All Fields property setting to Yes
  4. Run the query
Data from all of the underlying tables' fields will be displayed in addition to the fields you specified in the QBE grid. To change the query so that it only displays the fields explicitly selected in the QBE grid, simply
reset the Output All Fields property to No.


 



See all Topics

Tuesday, April 18, 2017

Delete Fast

No waiting


Unfortunately, Outlook does not allow you to use CTRL or Shift to select multiple folders at a time to delete them. Also the process slows down as the contents are deleted and then the folder. A quick way to get rid of them is to drag them to the Deleted Items folder.

The same is true of emails destined for the garbage bin.

Outlook-Tips.net:
Delete Folders



See all Topics

Monday, April 17, 2017

CSS Links

Some of the Best


If you have an interest in Cascading Style sheets, look at a few of these tutorials and downloads.


"CSS Creator site is a place for you to learn about and create CSS, Cascading Style Sheets. The CSS Forum is a place where you can discuss CSS page layouts, positioning, bugs and just about anything related to cascading style sheets.
The forum is new, free and most of all needs people like you to create a community. Talk about CSS, ask questions, find solutions, and help each other learn at the CSS Forum."


CSS Creator.com has a collection of links to valuable Web design information.



See all Topics

Sunday, April 16, 2017

Work that Menu

List of project docs


A collection of tips including:

Word (pre-07) allows you to add a menu to the toolbar that can keep a list of papers you're working on:


  1. Go to Tools>Customize.
  2. Click the Commands tab.
  3. Under the list of Categories, click Built-in menus.
  4. Under the list of Commands, locate and drag the Work menu to your toolbar.
  5. Click Close

Work Menu

In Word 2007+, you can see a list of 50 recently used documents when you click the Office logo. If you don't want them to drop off the list, they can be pinned.



See all Topics

Saturday, April 15, 2017

Custom Lists

Your Way



At times, you will want to enter the same information repeatedly in a spreadsheet.
It could be employee names, products or State names.

Here is a way to produce the information when needed.

Make a list of the items.
Enter the data in, say, A1, B1, C1 etc.
Be sure to enter in the right order; maybe Supervisor and then team members in alphabetic order.

Select all of the cells.
Go to Tools>Options and choose the Custom lists tab.
Click Import.
OK your way out.

Now you can delete the entries on the spreadsheet.

Choose any cell and type one of the items that are on your Custom List.
Click and drag on the fill handle; the tiny square at the bottom right corner of the selected cell.
As you pull, Excel will duplicate your list.

(In Excel 2007+, go to the Office Logo. Choose Excel Options. Edit Custom Lists will be on the Popular page.)

Also see:

The First Shall Be Last
by Dick Kusleika

Sorting by Color
by Chip Pearson



See all Topics

Friday, April 14, 2017

PowerPoint Screed

WSJ on slide shows


Here is another article trying to rein in the PP overkill.
It is easier to put together a PowerPoint show than it is to write an intriguing speech; Six bullet points vs. 6 pages of text.

Why is it the that polite audience members congratulate even the worse presentations?
"But the civility has some self-interest. Larry Chung, a software developer, doesn't criticize fellow presenters, he says, "because I know the tables could be turned a few weeks later."
To him, PowerPoint presentations are like corporate karaoke. "For the most part, it's tough to listen to," he says. "We all applaud each other even though we know how bad it stinks."


Go Easy on the Text



See all Topics

Thursday, April 13, 2017

Calendar Templates

New days


Here are calendars that you can produce using Word, PowerPoint, or even Visio.

Calendars

Also see
Make a Calendar

"For each month of each year featured, there are a variety of printable calendar pages for you to choose from. You can print out calendar pages that include coloring pages, selected craft projects, and special days to celebrate. "




See all Topics

Wednesday, April 12, 2017

Progress bar on Forms

Show movement


You can display computer time by using the Microsoft Progress Bar Control. In earlier versions of Access, it can be found by using the "More Controls icon in the Toolbox. In Access 2007 it's under "Insert Active X Control".



Here are the instructions from FunctionX.com:
Progress Clock



See all Topics

Tuesday, April 11, 2017

Calendar Printing Assistant

Printing help for 2007+


Some of the things you can do:


  • You can print and compare calendars in a variety of views:
  • Personalize your calendars with notes, images, colors, and designs:
  • Adjust information to changing views
  • Display information the way you need it:
  • Forecast your activities. The Calendar Printing Assistant has tools to display and organize long-range calendar
Calendar Printing Assistant

Also see Slipstick.com:
Printing Tools



See all Topics

Monday, April 10, 2017

Shoelaces

What's to know?


Fun, fashion & science in this quirky site about shoelaces. Whether you want to learn to lace shoes, tie shoelaces, stop shoelaces from coming undone, calculate shoelace lengths or even repair aglets, Ian's Shoelace Site has the answer!
Fieggen.com



See all Topics

Sunday, April 09, 2017

Template Videos

See how it's done

Access 2013-16 template videos available.

"Access  ships with Web database templates, each of which does a great job of showing off the new features. We've created videos about how to use each template, as well as a video showing you how to modify a template by adding a field."

Support.Office.com



See all Topics

Saturday, April 08, 2017

Spell Checker Update

Word 2007+

A discussion of how Spell Checker works and how it has improved over the years.

Support.Office.com



See all Topics

Friday, April 07, 2017

Thursday, April 06, 2017

Montage in PPT

No need for Photoshop


Fill a picture with a gradient - or another picture in PowerPoint? Have you wanted to blend two pictures in PowerPoint to create a montage?

Transparent montages in PowerPoint



See all Topics

Wednesday, April 05, 2017

Open Calendar

First thing

"If you want Outlook to start in the Calendar folder, go to Tools, Options, Other tab, Advanced and select the calendar in the Start up in this folder field. If the folder you want to use isn’t listed you can create a shortcut using the /select switch: "
outlook /select "outlook:calendar\subcalendar"

Outlook-Tips.net



See all Topics

Tuesday, April 04, 2017

Video without sidebar

Avoid collateral references

Sometime the appropriate video has inappropriate links next to it. Here's how to embed just what you want

AskDaveTaylor.com



See all Topics

Monday, April 03, 2017

Control Sort

Your choice

You can determine how Excel sorts your data.

ExcelTips



See all Topics

Sunday, April 02, 2017

Find Commands

Ribbon seeker

MS has a download that can be used to search for those old toolbar commands on the new Ribbon.

OfficeLabs.com



See all Topics

Saturday, April 01, 2017

SS Zip Codes

Excel to Access

Social Security Numbers and ZIP Codes can present special challenges when importing them into Access from Excel. This tip explains how you can prepare the data for the smoothest transition possible.
ExcelRibbon.Tips.net



See all Topics

Friday, March 31, 2017

Command Line

Control Line

"The Windows command line is a mainstay for systems administrators and power users but is relatively unknown to many PC users. The purpose of this site is to make the power and utility of the command line more familiar to a wider community of computer users. Also under-appreciated are the related resources of batch files and scripts and these will be discussed as well."

CommandWindows.com



See all Topics

Thursday, March 30, 2017

Sound Throughout

Background

You can set up sound to run throughout your show, music or narration.
(Included on this link is a list of free music locations)

Indezine.com



See all Topics

Wednesday, March 29, 2017

Signature Tutorial

Sign it

"Create your own signatures using text, hyperlinks, pictures, or even an Electronic Business Card.
Use your signature in every message or just when you want to.
Create different signatures for your different roles or e-mail accounts and switch between them to suit your needs."

Office.Microsoft.com



See all Topics

Tuesday, March 28, 2017

CSS Basics

Tutorial

Cascading Style Sheets can help to unify site design.
Here are some tips:

HTMLGoodies.com



See all Topics

Monday, March 27, 2017

Stacked Columns

On on another

Instructions how to put one column on top of another in a chart.



People.stfx.ca



See all Topics

Sunday, March 26, 2017

Open with Google

And you want to do this why?


"Google has added the functionality to make its office apps (Docs and Spreadsheets) the default application to open word documents and spreadsheet files, either for files downloaded from the Internet or local files on your computer, or both."

GoogleTutor.com



See all Topics

Saturday, March 25, 2017

Animated Forms

Add action

"Publishing your Access forms on the Web? Add some fun with animated images! For example, say you want to publish a form that allows your users to enter a keyword that will search your software catalog for winter specials; to illustrate this, you’ve embedded an image of two boys hitting the a puck with their hockey sticks."

TechRepublic.com



See all Topics

Friday, March 24, 2017

Calculating Time

Using EditTime field

Word keeps track of the time you spend editing. You can use this to figure out how to bill your time.

Paul McFedries



See all Topics

Thursday, March 23, 2017

Hints and Tips

For Windows

A number of suggestions to use with Windows.

Ramesh Srinivasan
Microsoft MVP, Windows Desktop Experience


Ramesh's Site



See all Topics

Wednesday, March 22, 2017

Hints and Tips

more ideas


  • Customize the Ribbon
  • New Shape Tools
  • Media Triggered Animations
  • Video across slides
  • Where did the stretch animation go?
  • Animated text in circle (2007 / 2010)

PPTAlchemy.co.uk



See all Topics

Tuesday, March 21, 2017

Steps to Take

Keep it up

TechRepublic presents 10 things you can do to keep Outlook running.

10 Things to Do



See all Topics

Monday, March 20, 2017

Templates

Suggestions

If you have a task with an app that you find yourself repeating, make a template.
Here are some suggestions.
Bottom line: don't do it twice if you can template it once.
Jotform.com



See all Topics

Sunday, March 19, 2017

Dynamic Charts

Keep on changing

Instructions and examples of charts that change as the data changes.

Tushar-Mehta.com



See all Topics

Saturday, March 18, 2017

PPT from Access

Automation

"Create a PowerPoint slide presentation from scratch using Access data. In addition, display and control a slide show from within an Access form. Walk through the solution and explore ways to extend the sample for your own applications."
MSDN.Microsoft.com



See all Topics

Thursday, March 16, 2017

Speed up your Macro

Wha's a macro?

"The purpose of this column is simply to provide information to anyone interested in how to make their work life more efficient through the use of macros. When your average computer user finds out that macros are all about little bits of code, the fear in their hearts becomes palpable, all the way from here. And so today I want to ease those fears and invite those of you who've been curious about macros to take the plunge and finally learn about them."

Dummies.com



See all Topics

Countdown Timers

Please sit down


To get your audience to settle down before you start or for breaks, you can create a timer slide that counts down the seconds or minutes before you begin.
Here are step by step instructions and links to other timers.


EllenFinkelstein.com



See all Topics

Wednesday, March 15, 2017

Moving Day

Transfer Outlook

A new machine and old Outlook data; how to combine the two.

Step 1: Get Files from Old Computer
Step 2: Put Files on New Computer
Step 3: Create a Profile
Step 4: More Settings
Step 5: Add Old Data File (*.PST)
Step 6: Finishing Touches
Step 7: Signatures & Stationery (and custom dictionary)

Slipstick.com



See all Topics

Tuesday, March 14, 2017

Bullets and HTML

Some code


Bullets aren’t too difficult to create using HTML.

<ul>

<li>Apples</li>

<li>Pears</li>

<li>Bananas</li>

<li>Grapes</li>

</ul>

Here’s an article that goes into more detail:


Cryer.co.uk



See all Topics

Monday, March 13, 2017

Why Pie Charts

Why Pie?

"The popularity of pie charts is a bit of a mystery. The data visualization goals of a pie chart can easily and more effectively be shown with a bar chart or even a simple table. In the worst of cases, a whole pie chart is used to show a single number."

JuiceAnalytics.com



See all Topics

Sunday, March 12, 2017

Long Bets

Take a chance


The purpose of Long Bets is to improve long–term thinking. Long Bets is a public arena for enjoyably competitive predictions, of interest to society, with philanthropic money at stake. The Long Now Foundation furnishes the continuity to see even the longest bets through to public resolution. This website provides a forum for discussion about what may be learned from the bets and their eventual outcomes.
  • By 2060 the total population of humans on earth will be less than it is today.
  • By 2020, bio-terror or bio-error will lead to one million casualties in a single event.
  • By the year 2020 solar electricity will be as cheap or cheaper than that produced by fossil fuels.
LongBets.com


See all Topics

Saturday, March 11, 2017

Access Forum II

Answers and samples


"The premier Microsoft Access help forum with Visual Basic, SQL Server, Office and more! Members are able to post questions and help others with problem solutions. UtterAccess has been seen in over 160 countries, recording over 825,000,000 hits to date. Microsoft Access Tables, Queries, Forms, Reports, Pages, Macros, Modules...you'll find all the free samples and answers here!"
Utter Access



See all Topics

Friday, March 10, 2017

Click and Type

Custom fields


It’s often useful to create “click-and-type” text placeholders. The idea is that you click the placeholder, and then you type the required text.

WordRibbon.Tips.net



See all Topics

Thursday, March 09, 2017

Simple-Safe Passwords

Memorable and protective

A new approach does away with the need for long strings of letters and numbers.


TechnologyReview.com



See all Topics

Wednesday, March 08, 2017

How to Prepare

Steps to a show


Microsoft has provided a roadmap to building a PowerPoint presentation.

Office Microsoft



See all Topics

Tuesday, March 07, 2017

Find Features

Hidden, but not forgotten

Take a look here if you can’t find your favorite feature.

HowTo-Outlook.com



See all Topics

Monday, March 06, 2017

Low Down Footer

CSS code


How to create a CSS footer that remains at the bottom of the page, regardless of content.

CSSStickyFooter.com



See all Topics

Sunday, March 05, 2017

Saturday, March 04, 2017

Overbar

So far to go

Here's how to inset an overbar or macron, Ā, in Word.

Overbar



See all Topics

Friday, March 03, 2017

Getting Started with Access

2010, but still good

A new look and new features designed to help you get your work done more easily than ever. You'll see differences right away, starting with the Getting Started with Microsoft Office Access.

Office.Microsoft.com



See all Topics

Thursday, March 02, 2017

Limit MRU

choose a number

Click on the "Office" button (File in 2010).
Choose "PowerPoint Options".
Click the "Advanced" entry in the left column.
Under "Display" enter "0"
Click "OK"
The list will be erased. No entries will be displayed under MRU
documents.
If you go back you can re-enter a number and PP will start list files
from that point on.



See all Topics

Wednesday, March 01, 2017

Second Sort

Different criteria

Add a secondary sort column to an Outlook sort.

TechRepublic.com



See all Topics

Tuesday, February 28, 2017

Monday, February 27, 2017

Sunday, February 26, 2017

Snow Flakes

Cooling

Your online guide to snowflakes, snow crystals, and other ice phenomena ...

SnowCrystals



See all Topics

Saturday, February 25, 2017

Count Unique

Distinct entries

A common query is needed to determine the number of different items in a data base. Here is the code:

YouTube



See all Topics

Friday, February 24, 2017

Charts and Tables

Q&A

Word 2007-13 handles charts in a different manner than previously. The Excel Charting program is used instead of MSGraph.

Word Ribbon Tips



See all Topics

Thursday, February 23, 2017

Reliability Monitor

Track the behavior of your system

"This utility provides you with a canned set of preconfigured counters that you can easily use to monitor the reliability of your system over time. An overview of Windows Reliability Monitor and show you how to use its System Stability Chart to track the behavior of your system over its lifetime."
TechRepublic.com


Windows 10



See all Topics

Wednesday, February 22, 2017

Sliding Slide Show

Moving

  • The Push Left slide transition
  • A background with no vertical borders
  • One or two continuous horizontal lines
  • Other optional horizontal elements

EllenFinkelstine.com



See all Topics

Tuesday, February 21, 2017

Resolve Names

CC search

”When you have more than one Contacts folder or address list enabled as an address book Outlook will use the folder when it resolves names provided it's on the check names list.

When you type a name in the To, CC or BCC fields, Outlook begins searching in the address list at the top of this list and works its way down the folders on the list, until it finds a match. For example: if you type Bill in the To field and have Bill Smith in the first contacts folder and Bill Jones is in the second folder on the list, typing just Bill will resolve to Bill Smith. You'll need to type Bill J to resolve to Bill Jones, or reorder the list.

If names in the address book are not resolving, open the address book
(Ctrl+Shft+B) and look on its Tools, Options menu. If the contacts folder is not listed in the 'When sending mail, check names using these addresses in the following order:' dialog, you'll need to click Add to add it to the list.”
Diane Poremsky

Outlook-Tips.net



See all Topics

Monday, February 20, 2017

Sunday, February 19, 2017

Formatted Input Boxes

Use text boxes


"You can use a Data Validation Input Message to display a message when a cell is selected. However, the font can't be changed, nor can message box size be controlled.

To overcome these limitations, you can create a text box to display the message, and use programming to make it appear if cells that contain a data validation Input Message are selected."


Contextures.com



See all Topics

Saturday, February 18, 2017

First Aid

Do it yourself

Got a foreign object in your nose? The Mayo Clinic has some advice on First Aid.

MayoClinic.com



See all Topics

Friday, February 17, 2017

Grouping in Sections

Enhance grouping in your Access reports


Discover a quick way to put these groups in sections and then enhance these sections by providing summary details about the group.

TechRepublic.com



See all Topics

Thursday, February 16, 2017

Style Sets

Formatting collections

Here is a tutorial about Style sets. You can develop and reuse your own collection of font/attribute choices.

How to use:



See all Topics

Wednesday, February 15, 2017

Shuffle Windows Media Player

Sort repeat

You have control over how Media player shuffles, repeats, and sorts content.


YouTube



See all Topics

Tuesday, February 14, 2017

Reflections

How to even in earlier versions

Sandra Johnson demonstrates how to create reflections in PowerPoint. 2007-13, of course, but also in earlier versions.

Indezine.com



See all Topics

Monday, February 13, 2017

Calendars on line

Available to all

You can publish a calendar to Office Online. People that do not have Outlook can still view the team calendar using the Office Online web site.

Blogs.MSDN.com



See all Topics

Sunday, February 12, 2017

CSS Menus

For the coder

Alan Gresley from Australia has an interesting site that includes the CSS code to create menus. One of the styles is called "Sons of Ursidae Menus".

CSS-Class.com



See all Topics

Saturday, February 11, 2017

Friday, February 10, 2017

Color in Access

Not dull

You can now use more than 16 colors in your datasheets.
You can pick any colors you want for gridlines, background and alternate background.
New themes and more color control in 2007+.

MSDN.com



See all Topics

Thursday, February 09, 2017

Language Formatting

Spell Check

When you use another language in your document, the spell checker will find errors in the text.
To avoid that, format the words with a language style.

TechRepublic.com



See all Topics

Wednesday, February 08, 2017

Excel to PPT

And Access

This example shows how to place the VBA code in PowerPoint, retrieve data from Excel and or Access and display it in a PowerPoint table.

PPTFAQ.com



See all Topics

Tuesday, February 07, 2017

YouTube Time Link

To the second

You can link directly to a specific time in a YouTube video. All you have to do is add a #t= anchor to the end of the URL that indicates the time position in minutes and seconds.

Here are the instructions:

Cadenhead.org



See all Topics

Monday, February 06, 2017

Saturday, February 04, 2017

Cut the Shortcut Arrow

Clean icons

If little things bother you, try this suggestion to remove the arrow that appears on shortcut icons.

HowToGeek.com



See all Topics

Friday, February 03, 2017

YouTube on a Slide

Good trick

YouTube is a treasure chest of material. This link shows how to add a YouTube video to your PowerPoint presentation.

JakeLudington.com



See all Topics

Thursday, February 02, 2017

Storage Option

Alternate method

Sent mail can be stored with original message.

TechRepublic.com



See all Topics

Tuesday, January 31, 2017

Code Copy

Excel to Word

You can select, copy, and paste to put Excel data into a Word document, but this piece of VBA automates to process.


VBAExpress.com



See all Topics

Monday, January 30, 2017

Tag a Collection

Basic naming and tagging protocol

Here are some suggestions about indexing a collection. In this case pictures on Flickr.

Deciding on classifications and inputting the tags is the hard part. Once all of the tags are in place your collection is searchable, and you can make sets based on any of the criteria used.


EvilMadScientist.com



See all Topics

Sunday, January 29, 2017

Drag Query to Word

Drop in

Rather than duplicate the effort, an Access query can be dragged into a Word document.

TechRepublic.com



See all Topics

Saturday, January 28, 2017

Quick Parts

Reusable

Word 2007+ uses the term Quick Parts for Building Blocks.
You can use any kind of content, including pictures, tables, document properties, hyperlinks, and more to create a building block.

Blogs.MSDN.com



See all Topics

Friday, January 27, 2017

Autoshapes to Pictures

Convert


You can, sometimes, do more with AutoShapes if you change them into Pictures.
Scaling and formatting choices are different with pictures.

EllenFinklstein.com



See all Topics

Thursday, January 26, 2017

Exclude Words

Not every one

Outlook 2007+ uses Word as a Spell Checker. Here’s how to omit certain words from the process. One reason might be to exclude words that are spelled correctly, but are really typos. One example might be Public and Pubic.

WindowsITPro.com



See all Topics

Tuesday, January 24, 2017

Custom Functions

Write your own

Excel allows you to create your own functions. If =SUM() is not enough for you, look at this link:

Custom Functions - User Defined Functions



See all Topics

Monday, January 23, 2017

One Summer America, 1927

EVERYTHING happened in the Summer of 1927!

by Bill Bryson




"It’s amazing what a talented writer at the top of his game can do with a seemingly narrow topic. The title of Bill Bryson’s latest sums up the simplicity of his task: to document the “most extraordinary summer” of 1927, beginning with Charles Lindbergh’s successful flight across the Atlantic. 

Even though we know many of these stories--Lindbergh’s flight, Babe Ruth’s 60-homerun season, the Mississippi River flood, Al Capone’s bullet-ridden reign over Chicago--in Bryson’s hands, and in the context of one amazing summer of twentieth-century ingenuity and accomplishment, they feel fresh, lively, and just plain fun. The book is so jammed with “did you know it” nuggets and fascinating origin stories (the opening of the Holland Tunnel, the first Mickey Mouse prototype, the source of the term “hot dog”), the effect is like sitting beside a brilliant, slightly boozy barstool raconteur, who knows a little bit about everything

From a tabloid murder trial to a flagpole-sitting record to the secret origins of the looming Great Depression, One Summer offers a new look at a transitional period in history, re-introducing us to such characters as Capone, Jack Dempsey, Al Jolson, Charles Ponzi, and Herbert Hoover. Ultimately, this is a book about the moment when important things, for good or ill, began happening in the US. With a giddy narrative voice and keen eye for off-kilter details, Bryson has spun a clever tale of America’s coming of age." --Neal Thompson





See all Topics

Sunday, January 22, 2017

Healthy Computing

10 tips

Neck hurt? Wrists ache? Back pain?
Here are some suggestions.

TipTalk



See all Topics

Saturday, January 21, 2017

Access FAQ

What's to know

Some interesting questions answered. Links are included for more detail.

AccessJunkie.Com



See all Topics

Friday, January 20, 2017

Make Templates

How to

This link tells what you need to know to create templates for your own or organizational use.

Office.Microsoft.com



See all Topics

Thursday, January 19, 2017

Background Sound

All the way through

In some circumstances you may want music to play throughout the presentation.

Indezine.com



See all Topics

Wednesday, January 18, 2017

Lines next to response

Choose your mark

Don’t like those vertical lines next to an e mail response?

AskLeo.com



See all Topics

Tuesday, January 17, 2017

Blog Control

Scripts

Using CSS on Blogs is not difficult. Here is a site that shows how to do many things including using different background images for different times of day.

BloggerBuster.com



See all Topics

Monday, January 16, 2017

Need a Doctor?

Look up site



”Celebrating its 20th Anniversary in 2016, the AIM DocFinder was the only online physician directory of its kind when it was launched in 1996. The DocFinder is still recognized for its easy to use search engine. DocFinder remains the only combined database of all licensing jurisdictions that has its direct source of data from and controlled by state licensing boards and remains free of charge to the public.”


DocBoard.org



See all Topics

Sunday, January 15, 2017

Auto Space Controls

Even it out


Access' automatic control spacing feature easily adjusts the horizontal or vertical distance between controls. Learn more in this tip.

TechRepublic.com



See all Topics

Saturday, January 14, 2017

Line Numbers

Count them all


  1. In Word, click Page Layout (File > Page Setup).

  2. Click Line Numbers.

  3. Choose Line Numbering Options.

  4. Click Line Numbering . . . .

  5. Put a check in the box labeled "Add line numbering."

  6. Set "Start at" to 1, "From text" to "Auto," and "Count by" to 1.

  7. Under "Numbering" select "Restart each page."

  8. Click OK.

  9. Click OK.

  10. Make sure you're looking at Print Layout.





See all Topics

Friday, January 13, 2017

Edit Control Panel

Add items

”Have you ever wondered where the Display Settings icon or Network Connections folder went in the Control Panel’s Classic View? For that matter, why can’t you search for them using the start menu search? Because they are prohibited from loading in the registry - that’s why.”

HowToGeek.com



See all Topics