Office Tips and Hints Blog

↑

Home Page

Host your Web site with PureHost!

Thursday, April 30, 2009 – Permalink –

Google from the Help Menu

Search with Excel, Word, PowerPoint

Where better to search the Internet for support on an Excel, PowerPoint, or Word problem than through the Help menu?

Would you like to add Google to that menu?

Ron de Bruin at rondebruin.nl has developed free add-ins that does just that.

"Google Search 6.0/7.0 places a new sub-menu item under the Help menu of whatever program you call it from. When that item is selected, up pops a user-friendly interface. This allows a largely intuitive completion and execution of a Google Search.

On clicking the Search button a lot goes on behind the scenes.

Your default (i.e. your usual) web browser is loaded and, without further instructions,

It's off to the Google Advanced Search Page.

It then fills in an Advanced Query to your specifications

Executes that query.

Once results are found (or not found) you are shown those results just as if you had carried out all of the steps of the process."

[Edited entry from 3/5/2006] See all Topics

Labels: Excel

<Doug Klippert@ 3:41 AM

Comments: Post a Comment

Wednesday, April 29, 2009 – Permalink –

Kahanamoku Keyboard

Surfboard - Keyboard

People ask you how to increase the font size in Internet Explorer?

"Oh, well, go to View>Text size and pick one between Largest and Smallest."

Here's another way:

Resize Text Size IE: Hold down CTRL key and move the wheel on the mouse.
The page text will enlarge or shrink.

Here are some others from Penn State University

Browser Tricks

Quick jump to Web Site IE: Type just the Internet domain name in the URL Address field and hold down CTRL+ENTER keys.
This will fill in www as the machine name and add .com
Presentation Mode IE: Select the F11 function key to enter Presentation mode (full screen).
Select the F11 function key to toggle back.
Page forward and back IE: Hold down SHIFT key and move the wheel on the mouse.
This will page forward or backward through the pages selected.
Page scroll using mouse wheel button IE: Push down on the mouse wheel button and slide the whole mouse up and down.
This will page up and down the screen.
Open a New IE Window with One Click: Hold down SHIFT and click on the link.
A new IE browser window will appear.
Page forward and back using arrow keys IE: Hold ALT button and use the arrow keys to page forward and back.
Get to Your Favorites with Keyboard Shortcut IE: Enter CTRL+I will bring up your left pane favorites.
Enter CTRL+I will make it disappear
Enter CTRL+B to organize your favorites

Duke Paoa Kahanamoku (1890-1968) is called the Father of Modern Surfing. There were others before him, such as George Freeth, who died in 1919, but Duke is the most widely known.

[Edited entry from 3/4/2006]

See all Topics

Labels: Internet

<Doug Klippert@ 3:08 AM

Comments: Post a Comment

Tuesday, April 28, 2009 – Permalink –

Quote Me All You Want

What the other guy says has weight

There are sites that give you Bartleby Quotations.

Gar Reynold has put together a list of some other sites that can help bolster any argument, no mater how specious.

"In my presentations, I may have several slides which feature a quote from a famous (sometimes not so famous) individual in the field. The quote may be a springboard into the topic or serve as support or reinforcement for the particular point I'm making. A typical Tom Peters presentation at one of his seminars, for example, may include dozens of slides with quotes. "I say that my conclusions are much more credible when I back them up with great sources," Tom says."

PresentationZen.blogs.com:
Where to get quotations

"Computers are useless. They can only give you answers.
Pablo Picasso"

[Edited entry from 3/3/2006]

See all Topics

Labels: Addendum, PowerPoint, Word

<Doug Klippert@ 3:53 AM

Comments: Post a Comment

Monday, April 27, 2009 – Permalink –

Change Your Name

Change your company

Ever work at a computer that had been assigned to someone else in the past and be bothered by seeing their name pop up all the time?

You can take charge of your own life!

Go to the Start button and open up the Control Panel
Select User Accounts and click on the account that you wish to Change
Click the "Change my name" option

Another way is to:

Go to Start>Run
Type: regedit
Find:
HKEY_Local_Machine\Software\Microsoft\WindowsNT\Current Version
On the right pane, look for 'RegisteredOwner'
Right click the RegisteredOwner key to edit it
Right click the entry and select Modify
You could also change the RegisteredOrganization.

[Edited entry from 3/2/2006]

See all Topics

Labels: Vista, Windows

<Doug Klippert@ 3:33 AM

Comments: Post a Comment

Sunday, April 26, 2009 – Permalink –

Composite Keys

Multi-Field Keys

To quickly create a multi-field primary key, while in the table's Design View:

Hold the Ctrl key and click each field that you want to make up the primary key.
Choose Edit>Primary Key from the menu bar, or click the Primary Key button on the toolbar

Access creates the composite primary key for you.

University of Texas at Austin:
Primary and Foreign Keys

[Edited entry from 2/28/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:03 AM

Comments: Post a Comment

Saturday, April 25, 2009 – Permalink –

Change Categories

Fit people into the right peg hole

Go to View>Arrange by>Current View and select by Category.
(View>Customize Curent View)

You can create a new Category and then just select Contacts and drag them into the right slot.

This technique works with any Outlook item for many Outlook fields, including Private and Company but won't work on fields that aren't editable. You can use it to add Categories but not remove them.

Make sure at least one item has the new field value.

Create a new view or edit one of the existing group by views to group by the field you want to change

Apply the view.

Select one or more items from the other groups and drag them to the new group and drop.

Slipstick.com:
Group By

[Edited entry from 2/27/2006]

See all Topics

Labels: Outlook

<Doug Klippert@ 3:44 AM

Comments: Post a Comment

Friday, April 24, 2009 – Permalink –

Baaad PowerPoint

How to make truly horrendous PowerPoint Slides

Incase you needed any help, here are some suggestions about how to develop really bad presentations.

"Of course, there comes a time when the PowerPoint amateur discovers two very dangerous tools indeed. Custom animations and slide transitions have recently been classified by the UN as 'weapons of mass destruction' and cited at the War Crimes tribunal in The Hague on more than one occasion. As far as both of these tools are concerned, my advice is the same: pick a style and stick to it.

Potentially there is boredom if every slide element skates in from the right or fades in from the background. It might be tiring for each slide to segue into the next using a diagonal wipe. But if the alternative is a dizzying combination of mismatched zooms, shrinks, checkerboard wipes and pirouettes then boredom is a very small price to pay."

Slides From Hell
by Ray Blake

From a fascinating "e-zine" called Indezine published by Geetesh Bajaj.

[Edited entry from 2/26/2006]

See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:48 AM

Comments: Post a Comment

Thursday, April 23, 2009 – Permalink –

Lookup, Down, and Sideways

A very useful Excel feature

Excel does not have "relational" tables like database applications such as Access.

You, however, can make use of database functions including the ability to look up values in a table based on a value.

You could, for instance look up a salesperson's records based on an employee ID.

All 'Bout Computers has an article describing "Lookups".

Using VLOOKUP, HLOOKUP, INDEX, and MATCH in Excel to interrogate data tables

John Walkenbach has a book "Excel 2003 Formulas" with a 24-page chapter on Lookup functions and other database/list tricks.

Chip Pearson talks about lookups on his site as well.

Aaron Blood's site offers download files explaining lookup. See numbers 36, 37, and 44.

One of the zipped Workbooks (number 35) Lookup.zip, is a study in lookup methodology.

Daily Dose of Excel:
VLookup on Two Comumns

[Edited entry from 2/25/2006]

See all Topics

Labels: Excel

<Doug Klippert@ 3:58 AM

Comments: Post a Comment

Wednesday, April 22, 2009 – Permalink –

Survey On Line

Test the wind electronically

Surveys can be used to appraise the sentiments of your audience, or just to gather data.

Here is a tutorial about how to use the FrontPage tools.

"Designing surveys is an art unto itself, requiring careful analysis, skill, and an absolute attention to detail. On the other hand, coding or developing a Web page that contains an electronic form that collects the data from a willing participant is often just as arduous.

FrontPage makes developing and publishing a Web form or survey a breeze. Moreover, it doesn't require that you know any programming or scripting languages that interactively collect and dynamically display results from a database as you will see in this tutorial."

Creating Online Surveys Using Microsoft FrontPage

by William C. Jeansonne

Also:

Survey Forms

[Edited entry from 2/24/2006]

See all Topics

Labels: FrontPage

<Doug Klippert@ 3:54 AM

Comments: Post a Comment

Tuesday, April 21, 2009 – Permalink –

Stop That Ballon!

Turn off pop-ups

There's a hard way and an easy way.

Sort of hard:

Balloon pop-ups typically appear when new programs and hardware are installed, when disk space becomes limited. If you do not want balloon pop-ups to appear, you can prevent them by setting values in the registry.

Go to Start>Run, type Regedit

In the Root list, select HKEY_CURRENT_USER

Find Software\Microsoft\Windows\CurrentVersion\Explorer\Advanced

For EnableBalloonTips, the value 2 enables balloon pop-ups and the value 0 disables them.
For Start_NotifyNewApps, the value 1 enables balloon pop-ups and the value 0 disables them.

Click OK

Note When EnableBalloonTips is disabled, enabling Start_NotifyNewApps has no effect.

Microsoft Developers Network:
MSDN.Microsoft.com/

And, sort of easy:

Right-click the Start button
Choose Properties
Choose the tab Start Menu and then the Customize button
Select the Advanced tab
Remove the check by "Highlight newly installed programs"
Then OK your way out

[Edited entry from 2/23/2005]

See all Topics

Labels: Windows

<Doug Klippert@ 3:26 AM

Comments: Post a Comment

Monday, April 20, 2009 – Permalink –

Make Your Own Templates

Fit any need

You are not dependent on microsoft for PowerPoint templates. You can create your own for use on special occasions or to share with others.

What is in a Custom Template?

Slide background

Slide Layout- which placeholders appear and their positions

Color Scheme

Formatting of placeholders

Formatting of text and bullets

Slide transition

Placeholder animations

Jan's Web Work & Experiments:
Custom Templates

Indezine.com:
Creating PowerPoint Templates

[Edited entry from 2/22/2006]

See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:21 AM

Comments: Post a Comment

Sunday, April 19, 2009 – Permalink –

Half Staff

When and how

A Proclamation by the President: Death of Coretta Scott King

A Proclamation by the President of the United States of America

As a mark of respect for the memory of Coretta Scott King, I hereby order, by the authority vested in me by the Constitution and laws of the United States of America, that on February 7, 2006, the day of her interment, the flag of the United States shall be flown at half staff at the White House and upon all public buildings and grounds, at all military posts and naval stations, and on all naval vessels of the Federal Government in the District of Columbia and throughout the United States and its Territories and possessions until sunset on such day. I also direct that the flag shall be flown at half-staff for the same period at all United States embassies, legations, consular offices, and other facilities abroad, including all military facilities and naval vessels and stations.

IN WITNESS WHEREOF, I have hereunto set my hand this sixth day of February, in the year of our Lord two thousand six, and of the Independence of the United States of America the two hundred and thirtieth.

GEORGE W. BUSH

Issued 2/6/06

Free notification of Official orders to fly the flag at half staff. Contact FlagsExpress.com.

You will be notified when orders are released.

HALF-STAFF INFORMATION

Also:

Veterans Administration:
Guidelines for Display of the Flag
and:

Flag Etiquette

Washington State flag

[Edited entry 2/21/2006]

See all Topics

Labels: Addendum

<Doug Klippert@ 3:13 AM

Comments: Post a Comment

Saturday, April 18, 2009 – Permalink –

Duplicate Table Structures

No need to reinvent

When setting up a database, you may find that there is a table structure in another database that would be appropriate. You could Import the table, but then you have to clear out the useless records.

Here's an easier way to do it:

Choose File>Get External Data>Import from the menu bar
(External Data tab in 2007, then select Access in the Import group)
Select the database that contains the tables you want to copy and click the Import button.
Select the appropriate tables on the Tables sheet
click the Options button, select the Definition Only option and click OK

To export a table definition from your current database to another:

Select the appropriate table in the Database window.
In Access 2000 and above, choose File>Export.
(If you're using Access 2007, choose More in the Export group)
Click OK.
Now, regardless of version, select the target database and press Enter

When the Export dialog box appears, select the Definition Only option button and click OK. See all

[Edited entry from 2/20/2006]

Topics

Labels: Access

<Doug Klippert@ 3:35 AM

Comments: Post a Comment

Friday, April 17, 2009 – Permalink –

Where Do You Store Your Spam?

It's Your Mess, Clean It Up

Previous versions of Outlook can handle PST files just this side of 2 GB (1.82) and Outlook 2003+ can go up to about 20-30 gigs with the new MSUPST format. However, very few administrators are going to allow users to save anywhere near that amount of information.

Outlook does have a tool to managing the size of the mailbox from within Outlook:

Go to the Tools menu
Select "Mailbox Cleanup"

This dialog includes quick links to find large items of a chosen size and items older than a selected number of days. You can view the size of folders, fine tune AutoArchive and empty the deleted items folder. [Edited entry from 2/1219/2006] See all Topics

Labels: Outlook

<Doug Klippert@ 3:04 AM

Comments: Post a Comment

Thursday, April 16, 2009 – Permalink –

SpWebSheet

No Excel needed

Here's a site that lets you design and post spreadsheets on the web.

"Keep your records, lists and spreadsheets in one place online. Easily slice, dice and share with others.

With a free account, you can...

Access your spreadsheets from anywhere

Share your spreadsheets easily - just email the URL

Add spreadsheets to your weblog

FREE storage

NumSum.com

[Edited entry from 2/16/2006]

See all Topics

Labels: Excel, Internet

<Doug Klippert@ 3:14 AM

Comments: Post a Comment

Wednesday, April 15, 2009 – Permalink –

Date an Octothorpe

Some more of those things I'm sure I used to know

The keyboard combination of Alt+Shift+D inserts the current date in MS Word and PowerPoint. Ctrl+; (semicolon) does it in Excel and Access.

If you do not like the date's format, select a different one with Insert>Date and Time and, if you would like to make that permanent, click on the Default button in the lower left corner of the dialog box (in PowerPoint it's in the lower right corner).

In Excel, Ctrl+Shift +# formats the entry as day-month-year. Ctrl+1 will display the "Format cells" dialog box.

BTW, the "hash, pound or number" sign # is also called an "octothorpe".

The person who named it combined Octo for the eight points and Thorpe for James Thorpe.

"Bell Labs engineer, Don Macpherson, went to instruct their first client, the Mayo Clinic, in the use of the new (touch tone phone system). He felt the need for a fresh and unambiguous name for the # symbol. His reasoning that led to the new word was roughly that it had eight points, so ought to start with octo-. He was apparently at that time active in a group that was trying to get the Olympic medals of the athlete Jim Thorpe returned from Sweden, so he decided to add thorpe to the end."

While we're at it, the "backwards P, Enter mark" ¶ is actually named a "pilcrow".

The pilcrow was used in medieval times to mark a new train of thought, before the convention of using paragraphs was commonplace.

Also see:
Geek-speak names for punctuation marks

Wikipedia:
Punctuation

[Edited entry from 2/18/2006]

See all Topics

Labels: Word

<Doug Klippert@ 3:27 AM

Comments: Post a Comment

Tuesday, April 14, 2009 – Permalink –

Border Magic with CSS

Consistent formatting

Cascading Style Sheets can be helpful in applying dependable format characteristics to web sites. Like Styles, CSS provides a reference point when a certain look is called for.

Stu Nicholls provides directions for "Fluid" borders:

"If you resize your browser window you will see that these borders are fluid and stay in shape. Resize the text and they will also stay in shape."

Even in this static shot, you can see some nice possibilities.

Fluid Borders to with CSS

[Edited entry from2/16/2006]

See all Topics

Labels: Expression Web, FrontPage, HTML

<Doug Klippert@ 3:01 AM

Comments: Post a Comment

Monday, April 13, 2009 – Permalink –

Windows Keyboard Tricks

Mouse-less motions

Here is a collection of shortcuts for Windows:
Keyboard shortcuts for Windows

One of the shortcuts is a way to minimize all Windows from the keyboard.

+M

Also see:

Kürzungen für jeder

[Edited entry from 2/15/2006]

See all Topics

Labels: Vista, Windows

<Doug Klippert@ 3:05 AM

Comments: Post a Comment

Sunday, April 12, 2009 – Permalink –

How to Flash in a PPT Show

Embed directly

Flash shows, in general, are remarkably easy to create.

Rather than try to duplicate complex animation in PowerPoint, you can add a Shockwave Flash Object to your show.

Brainy Betty has a video tutorial show the way:

How to insert Flash into PowerPoint

[Edited entry from 2/14/2006]

See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:18 AM

Comments: Post a Comment

Saturday, April 11, 2009 – Permalink –

That's the Way I Beleive it's Spelled

Wrong list

Spelling feels more like art than science. Here's a site that shows 100 (actually 250) words that are often misspelled.

It also gives you reasons and memory tricks to get it right.

Not all pens and pencils come with spellcheckers.

The "i-before-e" rule has more exceptions than words it applies to.

Dr. Language has provided a one-stop cure for all your spelling ills. Here are the 100 words most often misspelled ("misspell" is one of them). Each word has a mnemonic pill with it and, if you swallow it, it will help you to remember how to spell the word. Master the orthography of the words on this page and reduce the time you spend searching dictionaries by 50%.

100 Most Misspelled
Also:
Most Mispronounced
(You mean it's not "pronounciation"?
That's what happens when you have Old-timer's disease.)

[Edited entery from 2/13/2006]

See all Topics

Labels: Addendum

<Doug Klippert@ 3:16 AM

Comments: Post a Comment

Friday, April 10, 2009 – Permalink –

Business Rules!!! ... Rules

Bean Counting Models

Data modeling can be an exhausting, time consuming process. Here are some samples that may establish a starting point.

The website has close to 100 database models for experimentation, practice and examples.

"My intention is to provide a wide range of 'Kick Start' Models that anyone can use as a starting-point, and could extend cleanly and logically, with appropriate reference to the Business Rules.

It is not my intention to provide Models that can be used off-the-shelf to meet the requirements of a large commercial organization.

After all, that is one of the things I do for a living !!!

None of the Models is the complete and final solution in its area, but any of them can be added to easily and quickly to meet a specific requirement. The logic in each Model is intended to be correct and to contain the minimum Entities for the area being modeled."

Database Answers

Barry Williams - Founder and Principal Consultant.

If you're attempting a "Big Year" list of blogs, you can add Viewpoint of a Database Analyst: A Database Design Principles Blog

[Edited entry from 2/12/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:47 AM

Comments: Post a Comment

Thursday, April 09, 2009 – Permalink –

Excel-lent E-Mail

Outlook, Excel, and VBA

Ron de Bruin, Microsoft MVP - Excel, has put together a collection of VBA routines to make Excel e-mail friendly.

See if these topics tempt you:

Example Code for sending mail from Excel

Mail Workbook
Mail one Sheet
Mail more than one Sheet
Mail the Selection or range
Mail Every Worksheet with Address in cell A1
Mail sheet or sheets to one or more people
Mail range or sheet in the body of the mail (Send personalized email)
Mail a message to each person in a range with Outlook
Mail a message to each person in a range with CDO (no security warnings)
Sending a different file to each person in a range with Outlook
Zip the ActiveWorkbook and mail it with Outlook
Security (Prevent displaying the dialog to Send or not Send)

Also Download Addins for Excel e-mail information

Also see:

John Walkenbach:
Sending Personalized Email from Excel

[Edited entry from 2/10/2006]

See all Topics

Labels: Excel, Outlook

<Doug Klippert@ 3:23 AM

Comments: Post a Comment

Wednesday, April 08, 2009 – Permalink –

Booklets

Sized and numbered

Word has the built-in ability to print booklets with automatically numbered pages.

"If you don't want to spend money on an add-in, or use VBA; and are willing to do a bit more work yourself, here is the method I use. I've produced booklets up to 100 pages long this way, and it works quite satisfactorily for me."

Word.MVPS.org:
Booklet printing

Microsoft.com/Education:
Create Booklet

RickySpears.com:
Microsoft Word Booklet Templates

"The WordBookletTemplates.zip file contains Microsoft Word templates for 4, 8, 12, 16, 20, 24, 28, and 32 page booklets, with and without page numbers (16 templates in all). I think I developed these with Microsoft Word 97 and I've never made any changes to them. They use a series of text boxes that flow from one to the other to get the text where it is supposed to be in the booklet."

[Edited entry from 2/10/2006]

See all Topics

Labels: Word

<Doug Klippert@ 3:48 AM

Comments: Post a Comment

Tuesday, April 07, 2009 – Permalink –

Multiple Page Forms

When you need more than one

You've seen them before; web forms that accept input and then take you to another page for more data entry.

Here is a step by step tutorial:

This article describes how to create a multipage form in Microsoft Office FrontPage 2003. Each page of the form contains navigation buttons to move to the previous page or the next page. Additionally, the last page of the form contains a Submit button and a Reset button.

Support.Microsoft.com:
How to create a multipage form in FrontPage

[Edited entry from 2/9/2006]

See all Topics

Labels: Expression Web, FrontPage

<Doug Klippert@ 3:19 AM

Comments: Post a Comment

Monday, April 06, 2009 – Permalink –

Logon Welcome Warning

Opening notice

You can write and display your own warning notice (up to 256 characters).

It takes just a little trip into the bowels of the Registry editor.

Go to the Start button.

Choose Run and type Regedit

Hit Enter:

Registry Key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon

Modify or Create the Value Name
[LegalNoticeCaption]

Data Type:
REG_SZ [String Value]

Value Name:
LegalNoticeCaption

Value Data for LegalNoticeCaption:
[Type the Caption for the Dialog Box]

Modify or Create the Value Name
[LegalNoticeText]

Data Type:
REG_SZ [String Value]

Value Name:
LegalNoticeText

Value Data for LegalNoticeText:
[Type the Data for the Legal Notice]

Exit Registry Reboot

Support.microsoft.com:
How to Enable a Warning Logon Welcome

TheElderGeek.com:
Create Legal Notice Logon Dialog Box

Winguides.com:
Legal Notice Dialog Box

[Edited entry from 2/8/2006]

See all Topics

Labels: Vista, Windows

<Doug Klippert@ 3:14 AM

Comments: Post a Comment

Sunday, April 05, 2009 – Permalink –

Photo Mélange

Colorize without Adobe

Photoshop is a great program, but sometimes you just want to add a little pizzazz without the hassle.

Geetesh Bajaj has once again come up with a "Why didn't I think of that!" technique.

" Have you ever wanted to 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

[Edited entry from 2/7/2006]

See all Topics

Labels: PowerPoint

<Doug Klippert@ 3:21 AM

Comments: Post a Comment

Saturday, April 04, 2009 – Permalink –

Indoor-Backyard Battles

ADDENDUM

Indoor/Backyard Battles

Testosterone relief

Wet, rainy, cold weather activity, or just because.

"Always follow the rules! If you got hit in the head by a band but you don't want to take the 2-minute penalty (for instance), don't sit there fighting it out. Just suck it up and do the time. No one's going to have fun if all you guys end up doing is yelling at each other about rules and regulations. Take your time out, and keep in mind that, in the long run, you're going to have a much better time.

Clean up afterwards. Nobody's wife (or husband) likes to see rubber bands sitting in the chicken soup she had left simmering on the stove while she went out to buy some more carrots. ("Interesting flavor, honey...")

Ultimate Guide to Shooting Rubber Bands
Also,

Now you can build your own rubber band machine gun!

"This beauty is a fully functional machine gun with TWELVE rotating barrels and a live action trigger. Loads 12 bands per barrel for a whopping 144 rubber bands that shoot off as fast as you can turn the handle!"

Rubberband Machine Gun PLANS

[Edited entry from 2/6/2006]

See all Topics

Labels: Addendum

<Doug Klippert@ 3:40 AM

Comments: Post a Comment

Friday, April 03, 2009 – Permalink –

Where Have All the Bytes Gone?

Folder size list

You can create a list in Excel of all the folders on a drive and their sizes.
(The credit goes to Peter Beach, an Excel MVP.)

Get Folder Size code

Copy the code and open Excel.
Press Alt+F11 and, if necessary, on the Visual Basic Editor menu, Insert>Module
Paste the code.
You could use Alt+Tab to bring the worksheet forward.
Go to Tools>Macros and run the Macro named "GetFolderListing".

It may take a little time to complete. BTW, if you feel geeky enough, here is a picture of some of the year 2005 MVPs from John Walkenbach's site. [Edited entry from 2/5/2006] See all Topics

Labels: Excel

<Doug Klippert@ 3:54 AM

Comments: Post a Comment

Thursday, April 02, 2009 – Permalink –

Relationships

How it all ties together

"Find out how to reap the benefits of data normalization in Access while ensuring that your system provides users with all the information they need. Learn to relate your application's tables to each other, so that your users can view the data in the system as a single entity. After you define relationships between tables, you can build queries, forms, reports, and data access pages that combine information from multiple tables."

Relationships: Your Key to Data Integrity in Access 2003

An article from Informit.com and Alison Balter.

Alison is the founder of InfoTechnology Partners, Inc., a computer consulting firm in California. She is a highly experienced trainer and consultant, specializing in Windows applications.

[Edited entry from 2/4/2006]

See all Topics

Labels: Access

<Doug Klippert@ 3:24 AM

Comments: Post a Comment

Wednesday, April 01, 2009 – Permalink –

Flag That Play

Dog ear your email

With RSS entries, I average 500 or more messages a day. Here's a suggestion about how to tame the problem.

"You clear up one problem and delete the e-mail message -- and meanwhile six others pop up in your Inbox. Microsoft Office Outlook can flag messages with priorities, set reminders, and flag messages for follow-up, so that you can glance quickly at Outlook and know immediately what needs to get done first."

Office.Microsoft.com:
Demo: Organize your e-mail more easily than ever

[Edited entry from 2/3/2006]

See all Topics

Labels: Outlook

<Doug Klippert@ 3:23 AM

Comments: Post a Comment