[abcomputers] ABC~All 'Bout Computers, Vol.8: Vic's COOL Colored DOS Windows and More

  • From: Linda Johnson <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
  • To: ABCfreelists <abcomputers@xxxxxxxxxxxxx>
  • Date: Fri, 03 May 2002 22:03:15 -0400

ABC ~ All 'Bout Computers
Volume 8; January, 2002 - mailed to 1702 subscribers

If you would prefer to read the online Web-azine, which includes
pictures and screenshots and is, basically, more user-friendly, follow
either of these links: http://personal-computer-tutor.com/ABC.htm
(frames) http://personal-computer-tutor.com/vol8.htm (no frames)

or, scroll down to the Contents where you can click on over to any
individual article

For definitions of any terms you do not understand, visit the GeekSpeak
Translator: http://personal-computer-tutor.com/capn3.htm
This is not spam.  You are receiving this newsletter because you (or
someone using your email address) subscribed to it voluntarily.   If you
would like to remove yourself from ABC, please see SUBSCRIPTION
MANAGEMENT at the bottom of this newsletter. Using the "Reply" function
will not unsubscribe you!

My subscriber list is NOT made available to other companies or
individuals. I value every subscriber and respect your privacy.
These will have to be copied and pasted into your web browser's Address
Bar as one line in order for you to access them.
To view this text newsletter best, maximize your email window to FULL
(all links below these items take you to the non-frames Online versions)
(items with *** behind them include pictures and are viewed better

1.  Important How-To Message From Linda

2.  Linda's Thought of the Month
A joke from Frank G. (and animated GIF)

3.  Linda's Soapbox ~ THE FLEET NEEDS YOUR INPUT
~ PLEASE READ THIS! http://personal-computer-tutor.com/linda8.htm

4.  What's New at Linda's Computer Stop ~

5.  Subscribers' Exclusive Tip ~ Removing Items From the
Most Recently Used Files List in MS Word

6.  GeekSpeak Translation from the Cap'n


Vic's Registry RoundUp & DOS Den ~=A0

8.  Parker's Mailbox ~=A0

9.  James's Database=A0

10. Chas' Word World ~ HEADER/FOOTER TOOLBAR ~
Buttons and AutoText *** http://personal-computer-tutor.com/chas8.htm

11. Tina's FrontPage News ~=A0FAVOURITE THINGS TO DO ***

12. Hal's Hardware Haven ~=A0
APOLOGIES FROM HAL:  Too many clients with emergencies
at ABC's deadline time, so Hal couldn't make it this month.
He sends his regards and will be back with us next month. Please,
everyone, send him an email telling him how much he is missed! Send it
to abcomputers@xxxxxxxxxxxx

13. The Internet Connection by David Coons ~

14. Chad's Macro Mania ~=A0TABLE OF CONTENTS IN EXCEL,
Part II

15. Corey's Network Corner ~=A0INTERNET SHARING ~
Installing & Configuring the Software ***

16. Fred's Safety Belt ~ MICROSOFT & VIRUSES

17. Kathleen's Spider Web ~=A0DOCTYPE DISCUSSION
(and Bobby Update)

18. Steve's Ravin' Reviews ~ 2XEXPLORER,  PHOTOCOPIER,

19. GuitarMan's Outlook Express Tips ~=A0

20. NightSneak's Snoop Scoop ~=A0
CYBERCRIME AND SPAM REPORTING http://personal-computer-tutor.com/ns8.htm

19. The Dream Pusher, Michael Werner ~
COOL CAREER FIND ~ Finding Job Salaries in Different Geographical
Locations http://personal-computer-tutor.com/mike8.htm

20. Subscription Management

21. Contact Information

*** includes pictures in the online version
******************STATION BREAK***********************
If you find this newsletter and/or my website at all helpful and would
like to give me a hand here, I am now accepting donations through
PayPal.  To make a donation, go to Linda's Computer Stop and look for
the PayPal link in the left sidebar.
Thanks in advance to all who do this!!
(NOTE: no one receiving this should feel obligated in any way to do
this.....this is a FREE newsletter!) Linda, editor

If you decide to go to the Online "Web-azine" version, go here first for
navigation instructions:

If you are reading this plain text issue, maximize your email window for
These will have to be copied and pasted into your web browser's Address
Bar as one line in order for you to access them.

This month, my thought and animated gif come from
my buddy, Frank G.:

Thought:  This is a joke Frank sent me which I just loved and wanted to
share with you all.  Boy, can I relate to this:

A Geek is someone who ...

     1. has more e-mail addresses than coins in their pocket

     2. has a faint 'monitor tan', but only on their face

     3. uses three or more acronyms (URL, CD-RW, MSIE,
etc.) in 90+% of their sentences

     4. knows the complete version number of each program
they use, but can't remember their spouse's birthday

     5. remembers to run SCANDISK and DEFRAG each day,
but forgets to put on their shoes

     6. becomes spellbound at a connectivity problems lecture but can't
stay awake at supper

     7. knows the names of all robots in movies produced
since they were 5 but doesn't have a clue about Aunt
Jane's kids' names

     8. can code an HTML page quicker than they can compose
a short letter a friend

     9. can recite the specs on any hardware they use but can't tell you
their car's engine size

     10. refers to buying groceries as 'upgrading the pantry'

(just rightclick on the gif and choose "Save Picture As...")
~~Linda F. Johnson, Editor

The Fleet NEEDS Your Input!!

OK all you readers....why aren't you writing to us?  I know you probably
think writing to Internet sites or ezines doesn't get you anywhere.
Well, I'm here to tell you that is NOT the case with ABC!

As I edited our articles this month, I repeatedly saw requests from the
Fleet, begging you for your input.  Heck, Chad Welch even offered to PAY
YOU FOR IT (check it out!)

What more do we have to do to hear from you?

The subscribership of this newsletter/ezine continues to grow rapidly,
so I KNOW you are reading it.  I am on my knees now groveling and
KNOW.  (And me groveling ain't a pretty picture, I assure you.)

There MUST be something you would like to know more about
and can't find the info.  Computer terms?  Let me know and Cap'n Patt
will be more than happy to tell you like it is. Questions on any version
of Windows or Microsoft Office? We got that covered, for sure.  Just
write to me and I will pass your questions onto the Fleet so they can
base their articles on the content YOU want.  Hardware?  The Registry?
DOS? The Internet? Outlook Express? Web Design? Viruses? Security?
Software programs? It's ALL covered here and you MUST have at least one
suggestion for an article?

And, if you don't have ANY questions or don't want to learn ANY more (is
this possible??), at least send me an email and tell me how you feel
about what the Fleet is doing for you for FREE so far.  These people are
VERY busy and take the time to do this for you.  Please let them know
you appreciate this.  And, if they have a website, please visit it at
least once and let them know you found it because of ABC.

Yes, this newsletter is completely FREE.  And, yes, I will continue to
scour the Internet searching for the best, most knowledgeable writers I
can find. (And I think I have done a VERY good job at this so far.
These writers are truly amazing, in my opinion.)

You all have seen websites and newsletters come and go.  Why? Becuz, for
some reason (and it's not always financial), the writers begin to wonder
if it's really worth their efforts. PLEASE PLEASE PLEASE let us know how
we are doing and how we can better serve your needs!

OK....my knees are getting sore now, so I will cease the groveling.
Write to me RIGHT NOW before I have to have knee replacements.

Remember that this is YOUR newsletter.  If the content is not what you
want, then it's no fault but your own.

Dang.  I can be harsh sometimes, eh?

A lot of the Fleet members include their email address in their articles
or their bio.  Write to them directly and tell them what you want or
write to me at ABComputers-owner@xxxxxxxxxxxxxxx and I will pass it on
to them.

Linda Johnson is a college instructor of all of the Microsoft
Office=A0Programs, as well as Adobe PhotoShop and Windows. She also
teaches online distance learning classes in Access, Excel, PowerPoint,
Publisher, and Word at Eclectic Academy.

She has=A0worked helpdesk and teaches and lectures at many
local businesses and tech schools in her area. Support
this newsletter by checking out Linda's website

and her ebook series, MS Word MAGIC!
Part I: Fonts, Fun & Formats http://newbieclub.com/wordmagic/?buntah
Part II: Table Wizardry http://newbieclub.com/wordmagic2/?buntah

How To Get Started As a Software Trainer
******************STATION BREAK***********************

Yes, LINDA JOHNSON has published another eBook and
this one is called HOW TO GET STARTED AS A
SOFTWARE TRAINER http://dreamjobstogo.com/titles/djtg0036.html?10456


That's just how Linda started out and this book she tells you exactly
how she did it and how YOU CAN DO IT TOO.

No need for a college education!
No need for professional certifications!
No need for expensive classes!

PROMOTE YOURSELF. http://dreamjobstogo.com/titles/djtg0036.html?10456


By Richard S. Harris http://dreamjobstogo.com/titles/djtg0019.html?10456

Or if you have ANY DREAM JOB in mind, check out

All eBooks are  written by been-there/done-that authors
and sell for only $9.95, with a full money back guarantee.

******************STATION BREAK***********************
Free Tutorials, Free eBooks, Free Courses, Free Guestbooks, Free
Autoresponders,  Free Newsletter, Free Affiliate program and FREE
MEMBERSHIP. Wow! Did I mention it was Free? Newbies and Oldbies alike
are buzzing about the NEW Newbie Club. It's the most exciting Newbie
Site ever to hit the Web.

Join now - it's FREE!

editor's recommendation:
They also have an online PC Clinic now where you can receive Computer
and Internet Technical problem solving advice 24/7 for only $29.80 a
year!  I tested the service for them with some pretty tough questions
and they found the answers every time.....some took 3 or 4 emails back
and forth, but they DID solve it and they DID respond to each of my
mails within 6 hours.

I recommend this one!
(4.)  WHAT'S NEW at Linda's Computer Stop

First, let me introduce our newest Fleet member.  Steve Mills has joined
us to offer you his reviews of some great shareware/freeware (and
perhaps an occasional retail program if he really feels it's worth it).
Please check out Steve's Ravin' Reviews
and his bio.

And, join me in welcoming him to The Fleet.  I know you are going to
LOVE what he has to offer!

And, for those of you who have a favorite Fleet member, I have created
an archive of all the articles, organized by Fleet member, so you can go
to one place and read all the articles written by your favorite author.
Check it out. http://personal-computer-tutor.com/ByAuthor.htm

And, bookmark it so you won't forget where it is, tho you can always
access it from ABC's homepage, where there is a link to it in the left

Also, some up-to-date counts on the stuff I offer:

My Homepage just went over the 100,000 VISITORS mark in December, and my
Windows page is getting hit even harder than that.  This makes me VERY
happy and I am glad to see that my site is popular.  Also, ABC now has
over 1700 subscribers and my Microsoft Office email support group has
over 620 members.

Welcome to all of you who are new to any
of my services.  Please drop by my guest book and say Hi.

Next, I just wanted to mention that I have once again changed the look
of my website and ABC.  I finally listened to those who felt my
background made it tough to read, so I changed it. Also, if you are
using IE, version 5.5 or later, you will see I've added colored scroll
bars, which I think are so cool. What do you think of my new look?

Also, I added a couple new links to my favorite Internet sites, so go
here and look for the revolving N's.

....and one other thing:  There seems to be a new craze going around.
Everyone is concerned about "Web Bugs" which are tiny graphics inserted
in web pages to gather information about those that visit the pages.
The stats for my pages are monitored by HitBox (WebSideStory) and
therefore show up as "Web Bugs" with certain software.  I assure you I
am not monitoring your surfing habits and HitBox does NOT collect IPs.
Click here for full details.

The reason I use HitBox is so I can get a count of how many people visit
each of my pages, how long they stay, and how they navigate thru my
site.  I gather this information, NOT to spy on you, but, instead, to
see which of my pages are the most used, so I can continue to offer
information that is relevant to your needs.

If you have any suggestions for stuff you would like to see included at
my site or in ABC, drop me a line at linda@xxxxxxxxxxxxxxxxxxxxxxxxxxxx

All suggestions are welcome!
******************STATION BREAK***********************

It's the latest rage and it's called Distance Learning.  Most colleges
now offer Distance Learning classes because they know some people work
hard and just can't fit a classroom into their busy lives.  But,
sometimes you don't want to enroll in a full program; you just want to
take one class.


Eclectic Academy offers a large range of classes to suit
many needs.  Go there now and check out their curriculum and roster.
Classes are only $20 for 6 weeks. HOW CAN YOU BEAT THAT?

Here's a sampling of what they offer:

*Art Courses, both digital and traditional
*Business Courses, including most of the MS Office Programs
     (many taught by none other than Linda Johnson herself) *Graphics
Courses - Flash, PhotoShop, Paint Shop Pro & more *Website Development
Courses - FrontPage, Dreamweaver,
     ASP, DHTML, Website Promotion, and on and on and on *Eclectic
Classes - Computer Maintenance, Writing Workshops,
     Feng Shui, Eating Safely - just about anything you can think of

Go to Eclectic Academy now and sign up to be notified when classes are
added or ENROLL NOW in the class of your choice. January Enrollment is
closed, but go there now to enroll in the next set of classes beginning

(5.)  And HERE'S AN MS WORD TIP, From My Office Tips at
The Newbie Club  (It seems my Newbie Club tips may be a thing of the
past.  More info on that, as I know more.)

Did you notice, in any of the Office programs, that at the bottom of
your File menu you have a list of the Most Recently Used files?  Did you
know you can control how many you put there?  Just go into the Tools
menu in any of the programs and select "Options".  In the Options dialog
box, click on the tab at the top that says "General".  In there you will
see where you can tell Word or Excel or PowerPoint how many of these
recently used files you want displayed, or you can uncheck it and turn
this feature off all together.

But, what if you don't want to turn it off altogether, but you just want
to remove one entry from the list?  Either  because you deleted the file
and it's still showing up there or you don't want the next person using
this program to see THAT file.

Here's a very slick tip, but, unfortunately, it only works in Word:

With MS Word open, hold down your Ctrl and Alt keys and
press the hyphen key (above the P, not the minus sign on the number
pad).  You will see your cursor now looks like a minus sign.  Click on
the File menu and click on the file you want to remove.

And....BINGO....it disappears!

How's that for cool?
~~Cap'n Patt Meara

Visit the Cap'n's Official GeekSpeak Database at

If the word you need defined is not there, just write to me at
ABComputers-owner@xxxxxxxxxxxxxxx and I will pass it on to the Cap'n.
******************STATION BREAK***********************

Hands down, I think the one I use is the very best (Hal Cardona's been
using them for over 3 years and he turned me onto them over a year ago).

*My site has NEVER been down for more than 3 minutes!
(except once late on a Saturday nite when it was being
worked on and they warned we well in advance).

*Their tech support are the greatest and I have never had
to wait more than an hour for a good answer to any question
or problem I had!

*If you use FrontPage for your webcrafting, they are excellent with
those pesky FP extensions!

*And, the email server is non-failing!

Obviously, I am a big fan of theirs.

Their name is HOSTWAY and I believe if you try them, you will never
regret it. http://hostway.onweb.cx/

And, if you sign up, tell them you were referred by

That will help fund this newsletter because they give me a free month of
service for everyone I send to them :-)

~~ Vic Ferri, Windows Tips & Tricks

This month I will show you how you can create your own color files and
then use them to change the boring black color  and drab white text of
your Windows DOS screen. There are probably programs that can do this
and more for you but the idea here is to show you how you can do it
yourself without needing any programs.

You'll actually be creating your own color .com files.

This will work in most Windows versions as it doesn't require native
dos.  However, it does require that you have debug.exe on your system.
Check your Command folder if you're not sure you have it.  That's the
default location of it in Windows 9x. Debug is what you'll be using to
create the .com files. Don't worry if you've never used it before.  I'm
going to make this easy for even a beginner to do.

In this example, we'll create a .com file that can be used to give your
DOS screen a cyan background with bright white text, but you can easily
create other colors as well, if you wish.

1. Start by creating a new Notepad document (right click your desktop
and choose New > Text Document) and copy and paste the following debug
lines into it:

n cyan.com
e 0100 B4 12 B3 10 CD 10 B8 40 00 8E D8 B8 00 06 B7 3F
e 0110 29 C9 B6 18 80 FB 10 74 04 8A 36 84 00 8A 16 4A
e 0120 00 FE CA CD 10 B4 02 8A 3E 62 00 29 D2 CD 10 C3

Make sure you copy the text exactly as is - no spaces after the end of
the lines and make sure to do a carriage return after the quit command -
which is the last command (q).  In other words, if the cursor is at the
end of q ( q| ) press Enter to bring  it to the beginning of the next
blank line.

2.  Save the file on your desktop. It will have a .txt extension.
Now, right click it and rename it CYAN.SCR   Ignore the
warning about changing the file extension and click YES - you are sure.

3. Go to the Windows DOS prompt - click Start>Programs>
MS-DOS Prompt and at the Windows prompt type cd desktop

C:\WINDOWS>cd desktop

Press Enter - the prompt should now be:

Now at the new desktop prompt type DEBUG<CYAN.SCR


and press Enter.

That's it - you just created CYAN.COM on your desktop.
Exit DOS, go to your desktop and double click your new com file. It
should open up as a blank cyan colored screen.

Next, we want to use your new file to change the background color of
your Windows DOS screen.

1. Move CYAN.COM from your desktop  to your Windows folder.

An easy DOS way to move it -  Click Start>Run and type this:

move cyan.com \windows

2. Go to your Windows folder (this time just type \windows
in the Run box), right click an empty area and choose
New>Text Document.  Open the new document and copy and
paste the following two lines into it:

@echo off

Save the file and then rename it G.BAT
Again, ignore the warning about changing file extensions.   So
you should now have two new files in your Windows directory:

cyan.com and g.bat.

3.  Right click your Start button and choose Open. Double click on the
Programs folder to open it.  Find the "MS-DOS Prompt" shortcut icon,
right click it and go to Properties. Then click the Program Tab.

4. In the box labeled Batch File, enter:  G.BAT  and click OK. Exit and
that's it.

To test your new creation, go to the Windows DOS prompt your regular

Click Start>Programs>MS-DOS Prompt. Your Windows DOS
screen should now be cyan colored and any text you type white.

You may also want to change the font to make it more friendly. The color
will be lost if you clear the screen by typing cls but you can easily
bring it back by entering the letter G at the prompt and pressing Enter
(that was the purpose of naming the bat file G.bat - to make it easy to
get the color back if you clear the screen).  Note that you don't have
to enter the .bat extension to execute it.

To create other colors - repeat the above steps to create a com file but
substitute 3F at the end of the first line:

e 0100 B4 12 B3 10 CD 10 B8 40 00 8E D8 B8 00 06 B7 3F

With any of these other combinations - choose one Screen
color number and one Text color number.

For example, the cyan.com file you made was 3F

3 for the cyan screen
F for bright white text

Colors (background)

1 =3D blue
2 =3D green
3 =3D cyan
4 =3D red
5 =3D magenta

Text Colors (foreground)

1 =3D blue
2 =3D green
3 =3D cyan
4 =3D red
6 =3D magenta
9 =3D Bright Blue
A =3D Bright Green
B =3D Bright Cyan
C =3D Bright Red
D =3D Bright Magenta
E =3D Yellow
F =3D Bright White
Vic Ferri owns the very popular
WinTips and Tricks email group
and his website which accompanies it.
He is also in charge of the Printing Tips page at
Linda's Computer Stop.
ans also the Registry Tips page.
******************STATION BREAK********************
Are you into Video Computing?

VIDEOMAKER is the world's most popular monthly consumer video production
publication and covers the use of digital video editing, camcorders,
cameras, and desktop video and audio production for novice and expert
enthusiasts alike. Its articles  teach production techniques, survey and
review the latest equipment, and explain the newest technological

Published monthly, and is available on select newsstands and to

In addition, you receive a password giving you full access to Club VId,
Videomaker's vast online resource of information about making video.

And the best part is, it's CHEAP!  Only $14.97 for 13 issues!
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and might make this
clearer for you. http://www.personal-computer-tutor.com/parker8.htm
~~Parker Renaud, IT Manager, Colliers Keenan, Inc.


What happens to your Outlook information if you are using a portable
computer outside the office or if your Exchange Server is down? Well, if
you are like most Outlook users in an Exchange Environment, your data is
totally inaccessible.

However, there is a way to make your information accessible, whatever
your circumstances. To take advantage of the benefits of working with an
exchange server, you can set up and configure Offline Folders. Offline
Folders are similar to Personal Folders in that they are used to store
Outlook items on your hard drive, but Personal Folders are independent
of Exchange Server or any other Outlook folders.

Your Offline Folders file contains a copy of your data in the Exchange
Store. (The Exchange Store is where Exchange Server keeps your Outlook
information.) When you are connected to your network you can synchronize
the data in your Offline Folders file with the Exchange Store. You can
then disconnect from the network and work with Outlook while off the
network. When you next connect to the network and synchronize, any
changes you made while offline are copied to the Exchange Store.

In order to do this you must first create a profile for offline use.

To create a new profile:

1.     Click Start>Settings>Control Panel, then double click the
Mail (or Mail and Fax) icon to display the Properties dialog box.

2.      Click on Show Profiles to display the Mail dialog box.

3.     Click on Add to add an offline profile and the Inbox Setup
Wizard will appear.

4.     Check Microsoft Exchange Server and click next.

5.     The wizard will then suggest the name MS Exchange
Settings for your new profile. Change the name to something meaningful,
such as your initials and Offline. Click next.

6.     The next window asks the name of your Exchange Server
and your user name. If you don=92t know the name of your Exchange =
you can view the properties of your current profile or ask your
administrator. Enter the information and click next.

7.     The next window asks whether you travel with this computer.
If you are setting up an Offline profile, click Yes, even if the profile
is for a desktop that you don=92t plan to take anywhere.

8.     The final window says you are done and shows the services
that you have set up. Click finish and the Mail dialog box will reappear
with the new profile in addition to any other profiles set up

9.     Now that you have created an offline profile, you need to
create an Offline Folders File. Highlight the new profile, click
Properties and the Properties dialog box will open.

10.  Highlight Microsoft Exchange Server, and click Properties.

11.  When the Microsoft Exchange Server window opens click
on the Advanced tab, then on the Offline Folder File Settings button.

12.   Again, Microsoft suggests a meaningless name for the
Offline Folder File. Rename it something meaningful to you
such as your initials or user name and offline. Do not change the .ost
extension, however.

13.  If you want to change the encryption setting, do so now, then click
OK until you return to the Outlook desktop.

14.  Now you need to synchronize your offline folder file to copy your
current Outlook information into it.

15.  Click on Tools>Synchronize>All Folders. The first time you
synchronize can take anywhere from 5 to 30 minutes, depending on how
much information you have in your information store. Subsequent
synchronizations should take less than a minute.

16.  To keep your offline folder synchronized, go to Tools>
Options>Mail Services, and check the box =93When Online,
synchronize all folders upon exiting.=94 If you never turn off your PC,
however, this will not do you much good. If that is the case, check the
box =93When online, automatically synchronize all offline folders every =
minutes.=94 You can change the interval to whatever you wish.

Now that you have set up your offline folders and synchronized your
folders, you need to test it. In order to test it, simply sign off your
network and open Outlook using your offline profile. If Outlook opens
and you can still access your data, you did it correctly. Now you can
work in Outlook whether or not you are connected to the network.
Parker Renaud is the one-man IT department at Colliers Keenan where he
manages 90 PCs on 5 servers.
~~James La Borde


As I have mentioned in a previous articles, planning your database
before you begin is highly important. This month we will be looking at a
very key piece of that puzzle, normalization. Normalization is the
process that makes a relational database relational. If you are
following the advice from earlier articles you are already practicing
normalization and don=92t even know it. It is removing redundant data =
moving it into a unique, related table of its own.

The Normal Forms

There are three forms (or degrees) of normalization. The First Normal
Form basically says that there can not be any repeating groups and that
the data in each field can not be divided. This is the stage at which
you create a primary key. Second Normal Form states that all fields
within the table should refer to the primary key. Third Normal Form
requires that all the criteria of First and Second Normal Forms be met
and that you remove all fields that describe a non-key value.

What does all of that mean in English? Let=92s tackle First Normal Form
first. Basically, First Normal Form is the breaking up of your data into
the smallest fields possible and then moving duplicate information into
another table, where it will appear only once. In short, this would mean
splitting up an Address field into Street Address, City, State, and ZIP.
Second Normal Form ensures that all fields in a table support only the
primary key in the table. This means that if your primary key is
Shipping Address ID, only information pertaining to the Shipping Address
is included in the table. Items that refer to, for example, a billing
address, would be located in another table. Third Normal Form goes
further in that it requires any field containing data that can be
derived from information in another field in the same table must be
removed. This is a difficult concept to grasp. The best example I have
seen is using an address. In an address, the only data that truly refer
to the primary key are the street address and the ZIP code; the city and
state can be derived from the ZIP code. In this instance, a separate
table would be required to store the ZIP code information.

How Far is Far Enough?

As you may have noticed, going all the way to Third Normal
Form does seem quite tedious and over the top for most
database applications. Normalization is actually a concept that was
borrowed from mathematics and therefore does not always fully apply.
Let=92s look at an example of what happens when you take this concept to
the fullest extent, such as a table containing the names and addresses
of your customers. Just to meet the First Normal Form completely we
would have to do quite a bit. First, the name would have to be divided
into first and last names. The address would have to be divided as well,
further than you may realize. In order to be truly atomic (the smallest
division possible) the street address itself would be divided into a
minimum of two and possibly three fields. The first would be the number,
next the street name, and last (if you wanted to go this far), would be
street suffix. Then we would do the usual division of the city, state
and ZIP, of course, the ZIP code would be divided into ZIP and ZIP+4
extension. Ah, we finally meet the First Normal Form right? No, remember
there can be no repeating groups or redundant data. Names would have to
be separated into at least two fields: we could have many =91John=92s =
instance; and of course, the potential exists for common last names as
well. The streets could repeat too as well as the street suffix. Now we
have our Address table, first names, last names, streets, and street
suffixes in supporting tables. We finally meet the First Normal Form.
Wonderful news, we also meet the Second Normal form since we have
included relatively little information. To meet the Third Normal Form,
we now have to remove any fields that are not dependent upon the primary
key. This means that we have to move all of the information regarding
the city and state to a ZIP code information table as the city and state
are dependant upon that and not upon the primary key. As you can see,
this is entirely too far. Most developers find their own style and stick
with it. The primary thing to worry about is consistency.

Consistency is the key to successfully developing your database in
regards to the normalization process. Be consistent not only within your
tables but also throughout the entire database. If you use first and
last names separately in one table, then do it throughout your database.
Your clients=92 needs will determine just how far you take the
normalization process. When you are done with your database, the end
result will show whether or not you did your preliminary work up front.

Coming Next Month:  Naming Conventions

As for after that I am open to suggestions from everyone.
I was thinking a question and answer article would be good so feel free
to send in your Access questions.
James La Borde works in the computer department at a Credit Union, where
he uses Access, SQL Server, VBA, and ODBC daily.
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and tables and might make
this clearer for you. http://www.personal-computer-tutor.com/chas8.htm
(10.) Chas' Word World
~~Charles Kyle Kenyon, J.D.


(Headers and Footers and Letterhead Part III)

This article continues from Headers and Footers and
Letterhead Part I and Part II. Although it is not required to understand
this article, you may benefit from reading those articles first.

This month we'll look at the Header and Footer Toolbar and
its buttons. I'll point out some things wrong with it and how to fix
them. Finally, we'll examine the AutoText entries on the toolbar and
think about improving on them.

First, don't think you have to memorize the buttons on the toolbar. When
you are using the toolbar (if you have Word set to display tooltips, the
default setting) Word will give you a name for any button when you put
your mouse pointer over the button for a few seconds.

Insert AutoText

This isn't really a button (or even a menu) but rather a drop-down list.
We'll get into its contents when we get to AutoText.

Insert Page Number

 Inserts a { PAGE } field which displays the number of the current page.
If inserted using the button, this will be inserted in the Page Number
character style - which may be different from your footer style and a
bit disconcerting. You may prefer to press Ctrl-F9, type "Page," and
then press F9 to display the page number. This avoids the character

Number of Pages

 Inserts a { NumPages } field which displays the number of pages in the
document.  If inserted using the button, this will be inserted in the
Page Number character style - which may be different from your footer
style and a bit disconcerting. You may prefer to press Ctrl-F9, type
"NumPages," and then press F9 to display the number of pages. This
avoids the character style.

Format Page Numbers

 Opens the Page Number Format dialog box so that you can use Roman
numerals, start on a different page, etc.

Insert Date

 Inserts a { DATE \@ "M/d/yy" } field, which is probably not what you
want. It will give you the current date (at the time of printing or
opening the document - whichever is later) in the format 12/31/01. A
better option for this is to insert a { CREATEDATE \@ "MMMM d, yyyy" }
field - or whatever your preferred format is. Other options would be the
{ SAVEDATE } and { PRINTDATE } fields. See How Do I Insert a Date in
Word? http://www.personal-computer-tutor.com/chas5.htm
for more on date fields and formats. If the date is typed in the body of
the document anywhere, my preference is to use a { STYLEREF } or { REF }
field to pick up that date for the header/footer. That way you don't end
up with one date in the body of the document and a different date in the
header/footer. See Styles in Letterhead and Headers and Footers for
details. http://www.personal-computer-tutor.com/chas7.htm

Insert Time

 Inserts a { Time \@ "h:mm AM/PM" } field, which is probably not what
you want. This will give you the current time (at the time of printing
or opening the document - whichever is later) in the format 9:30 AM.
Again, you might want to use one of the other date fields with your
preferred format for this instead.

Page Layout

 Opens the Page Setup dialog box (just as if you had gone to File =3D>
Page Setup =3D> Layout). This lets you change things that alter the
header/footer such as "Different first page" or "Different odd and

Show/Hide (non-header/footer) Text

 The default status is to show dimmed text when viewing the headers and
footers. If you find this distracting, you can click this button and the
dimmed text will disappear from view until you either click on the
button again or close the header/footer view.

Same as Previous (Section)

 The default setting for this is depressed so you will likely see it
clicked . If it is not enabled (you can't click it) you are in the first
(only?) section in your document. Each section in a document can have up
to three sets of headers and footers: a general set, a first-page set,
and an odd-page set. See Headers and Footers, Sections and Section
Breaks for more information on this.

If there is a section following the one in which you want to make a
change you have to do it in that section as well unless you want your
change to carry into that section. Moreover, Same as Previous is
independent for each header and each footer you have (so you have to
change it up to six times in each section where you want it changed).

Switch between Header and Footer

 This switches between the header and footer of the same type in the
same section (the header and footer that would appear on the same page.
If it is depressed, you are in the footer.

Show Previous  / Show Next Header (Footer)

 These two buttons will take you to the next header or footer for your
document, assuming that header or footer is active. By "active" I mean
that it is displayed on a page. As was stated previously, each section
of a document can have up to three different sets of headers and
footers. If a section has all three types but only has one page, only
the first-page header and footer will be available for editing. If you
have multiple sections, this will move you to the next or previous
section if there are no more headers/footers in the current section.


 You may not have noticed, but the Header and Footer toolbar doesn't
have the regular close box found on other toolbars (and windows).
Instead, it has a Close button on the toolbar. Earlier versions of Word
(prior to Word 97) had both, which caused all sorts of problems. The
Close button not only closes the toolbar, but also the header/footer
view. When you click on the Close button, you will be returned to the
view you were in before you selected "Headers and Footers" from the View

Miscellaneous notes that don't fit well with the narrative

 See Letterhead Textboxes and Styles Tutorial - two-page template

that demonstrates use of

*Textboxes in headers and footers to reserve space for preprinted

*Styles that are based on each other and use the style for following
paragraph feature

*Use of the StyleRef field to insert information from the
body of a letter into the continuation page headers automatically

*Insertion of a date automatically that will not change when you open
the document at a later date

*The AutoText list restricted by styles for the salutation
and closing.

*Insertion of the typist's name as signer automatically by accessing the
Author document property.

 If you need a header that begins on the second page of a section, use
"Different first page" then omit the text in the First Page Header.

 Fields in headers and footers get updated on a different schedule than
do fields in the regular document. See the Microsoft Knowledge Base
article Q89953 for more on this.

 The styles in headers and footers are named (coincidentally) "Header"
and "Footer." If you want to change the formatting of your headers and
footers, start by modifying these styles. Since I usually use the same
fonts and margins in the footer as in the header, I generally have a
"Header" style based on [ no style ] that has a negative indent of .5
left and right and is in a font that is two points smaller than body
text. The different indents and font size help readers distinguish the
header/footer material from the body. I then modify the "Footer" style
to be based on the "Header" style. By modifying the styles rather than
applying direct formatting I can change the formatting of all headers
and all footers in the document.

AutoText and the Header and Footer Toolbar

This button is a special AutoTextList field and works the same way. It
picks up any AutoText entries that were saved while in the Header or
Footer styles. The built-in entries include a number of fields useful in
headers and footers such as:

(see online version for table which might make this clearer)

- PAGE -
 [tab]- {Page} -

Author, Page #, Date
 { AUTHOR }[tab] Page {Page} [tab] {DATE}**

Confidential, Page #, Date
 Confidential [tab] Page {Page} [tab] {DATE}**

Created by
 Created by { AUTHOR }

Created on
 Created on { CREATEDATE }


Filename and path
 { FILENAME \p }

Last printed
 Last printed { PRINTDATE }

Last saved
 Last saved { SAVEDATE }

Last saved by
 Last saved by { LASTSAVEDBY }

Page X of Y
 Page { PAGE } of { NUMPAGES }

 If you want to add AutoText entries to this list, add the entries while
you are in the Header style. A few that you might want to it would be
for the Template and Template with path, and section number and number
of pages in the section. Those fields are { TEMPLATE }, { TEMPLATE \p },
{ SECTION } and { SECTIONPAGES } respectively. These could be used show
the template attached to the document and section (chapter?) number.

 If the AutoText bar on your Header / Footer toolbar doesn't have any
contents (or doesn't have the entries that you are expecting), the first
thing to look at is the style of your paragraph. If it isn't "Header" or
"Footer" your expected entries won't be there (or you may have an
overwhelming number of non-relevant entries) because this control is set
to work with these styles.

 For more about the AutoTextList field and AutoText, follow
my AutoText links.

Page X of Y doesn't Work!

* Page X of Y (using the PAGE and NUMPAGES fields) has been buggy
(although improving) through the various versions of Word. The extent to
which these fields work (don't work) as well as workarounds available
differs depending on your version of Word including which patches you've

See Page X of Y doesn't work! http://addbalance.com/word/pagexofy.htm

or "Page X of Y" displays or prints as "Page 1 of 1," "Page 2 of 2," or
"Page 2 of 1" http://www.mvps.org/word/FAQs/AppErrors/PageXofY.htm

if these fields aren't working for you.

** See Using Date Fields in Microsoft Word for more on different date
fields and formatting them.

Once you have the field you want, you can add your own
AutoText entries. Again, add them in the Header style if you want them
to show up on your AutoText button in your headers and footers.

Customizing / fixing the Header and Footer Toolbar

You can change the header/footer toolbar so that it works better for
you. You would want to do this in a global template other than
normal.dot so that your changes would be portable. See Customizing Word
- Part III for more information on changing toolbars and creating global
templates. http://www.personal-computer-tutor.com/chas4.htm

What follows assumes that you have absorbed the material in that article
and looks at special problems / opportunities when working with the
header/footer toolbar.

First, before you start messing with the toolbar create any AutoText
entries you'll want. I would suggest ones for your page number and
number of pages buttons that do not carry the "Page Number" character
style. These will be the fields suggested above. You could also create
an AutoText entry for your preferred date field (or even the StyleRef
field). Save these AutoText entries in your global template. The page
number fields don't need to be in the Header style since we'll be using
them with buttons rather than from the AutoText list. You may want to
give the AutoText entries names, though, that won't pop up in your
ordinary typing so that you aren't inadvertently inserting page numbers
in your documents.

Second,  I recommend creating a new toolbar named "Header
and Footer Toolbar Changes" for your use in preparing buttons for the
built-in toolbar. This will make it much easier for you to move your
changes to a different template in the future.

Third, you need to be in the Header and Footer view to access the
toolbar. If you try to make any changes to the toolbar from any other
view, you won't be able to find it! While in the Header and Footer view,
open the Customize dialog box (Tools =3D>
Customize...) and display your custom "Header and Footer Toolbar
Changes" toolbar (that doesn't have anything on it yet).

Fourth, with the commands tab on top and showing that you are saving
these customizations in your global template, Find the AutoText category
on the left side. Then find your AutoText entries in the right window
and drag them to your custom toolbar. Right-click on the Header and
Footer toolbar button for page number and copy that button image. Paste
it on the AutoText entry on your custom toolbar. Do the same thing for
the Number of Pages and the Date buttons. Right-click on each of your
buttons and rename them if you want so that the names are more
meaningful. Don't worry about the names being too long for your toolbar
right now; type what you want.

Fifth, in the Customize dialog box, go to the bottom of the left window
to find the "New Menu" category and drag a new menu from the right
window onto your custom toolbar. Right-click on this and rename it
"Pulled from Built-In." Next, holding down the Ctrl key, drag your
AutoText entries from your custom toolbar to the Header and Footer
Toolbar and put them next to the buttons they are replacing. Then drag
the buttons being replaced and put them on your "Pulled from Built-In"

Sixth, right-click on each of your AutoText commands on the Header and
Footer toolbar and check "Default style" for the display. Your names
will disappear and you'll be left with functioning buttons. You can
close the Customize dialog box now.

Seventh, you don't really want to be using your custom toolbar, only the
changes you made to the built-in one. You can close it and close the
header and footer view in your template. Save your global template. You
can add three macros to your global template to keep this custom toolbar
out of your way if you want. They are as follows:

Sub AutoExec()

    ' Disable custom toolbar upon loading global template

    CommandBars("Header and Footer Toolbar Changes").Visible =3D False

    CommandBars("Header and Footer Toolbar Changes").Enabled =3D False

End Sub

Sub AutoOpen()

    ' Enable custom toolbar when editing global template

    CommandBars("Header and Footer Toolbar Changes").Enabled =3D True

End Sub

Sub AutoClose()

    ' Disable and hide custom toolbar when done editing global

    CommandBars("Header and Footer Toolbar Changes").Visible =3D False

    CommandBars("Header and Footer Toolbar Changes").Enabled =3D False

End Sub

Well, that concludes our work with Headers and Footers and letterhead,
at least for now! Please let me know if it has been useful to you.

Keyboard Shortcuts of the Month for Word
Chas Kenyon is a trial lawyer concentrating in criminal defense with a
long interest (obsession?) with making word processing work well in the
law office. His websites are: http://www.addbalance.com/index.htm
******************STATION BREAK***********************
Discover How To Create Stunning Letters, Presentations, Greetings Cards,
Promotional Materials, Memos, Reports And More - Just Like The

Imagine using the Famous Newbie Club Easy Learning
System to create Newbie-Speak Tutorials of the World's
No. 1 Favorite Word Processing Program. What do you get?

eBooklet Series
by Linda F. Johnson

Book I teaches all about the formatting of text, words, and paragraphs.

Book II is all about Tables and how to use
them to get the most out of your Word documents.

And both ebooklets come with the famous Newbie Club unconditional

"If, within 12 months of purchase and for any reason whatsoever, you
decide that MS Word MAGIC! is not for you, simply let us know and we'll
refund your purchase price immediately. No Questions Asked! No ifs, buts
or maybes. No hidden clauses and no small print. With us, unconditional
means unconditional!"

So...what have you got to lose?  Check out this series:

Book 1:  Fonts, Formats and Fun http://newbieclub.com/wordmagic/?buntah

Book 2:  Table Wizardry http://newbieclub.com/wordmagic2/?buntah
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and might make this
clearer for you. http://www.personal-computer-tutor.com/tina8.htm
~~Tina Clarke,  AccessFP Resource Centre


Fancy having your IE Favourites or Netscape Bookmarks
available on your own site? In that case do the following:

Open your Browser window and go to File | Import/Export
and press to bring up the Import/Export Wizard.

In the Import/Export Wizard Dialog box that pops up, click
the button marked Next and choose Export Favourites (or bookmarks if you
are in Netscape).

Your Favourites are then listed. Choose the root folder and click the
Next button. Now you will be presented with the address line, which
should read C:\My Documents\bookmark.htm, by default.

However you can save your exported file anywhere using the browse

I suggest saving the file directly to the FrontPage web you want it in.

The first time just browse to your web and insert _bookmark.htm for the
end of the address. Next time all you have to do is browse to the same

Why you should use the underscore will become apparent later.

NOTE: You do not have to make a page beforehand.  In FrontPage this will
be done automatically.

Click next and it will ask you to click the Finish button. Next time you
come to do this it will ask if you wish to replace the file say =
=91Yes=92 as
you are just updating your file with new bookmarks you have gathered.

You may not want your bookmark page to be available to search engines or
to show up in your TOC (Table of Contents) or FrontPage search bots.  So
just insert the following meta tag into the html between the Head tags.
You can do this directly in the html view by inserting

<meta name=3D"robots" CONTENT=3D"noindex,nofollow">

OR Right click the page concerned, choose 'Page Properties' from the pop
up menu under user variables click 'Add'. Under 'Name' insert robots and
under 'Value' insert noindex,nofollow press ok twice and they will be
inserted for you by FrontPage.

So that the page won't show up in your TOC (table of contents) or
FrontPage Search Bots, I suggested above naming the file with an
underscore ( _ ). FrontPage will not let files with underscores show up
in the TOC and Search results.

If you have a large amount of favourites or bookmarks you may wish to
use a free FrontPage host in which case check out the listing at

Best of all you can check out your favourites collection for dead links
using the FrontPage Reports feature. Merely select the 'In Page' column
to sort the files into alphabetical order and then select all the
_bookmark.htm files. You can do this by selecting the first file holding
down the shift key and then selecting the last file. Or to select
individual files hold down the control key and click on those files you
want selected.

You can update your favourites by deleting dead links through the
browser Favourites feature. Do this once a week and your Bookmarks will
always be up-to-date and fresh, thanks to FrontPage.
Tina Clarke is the Webmaster of AccessFP - FrontPage Resource Centre
http://accessfp.net/ and an editor of "AnyFrontPage Bytes Ezine".
Subscribe to the FrontPage ezine and get FREE FrontPage E-Books upon
joining. http://groups.yahoo.com/group/AnyFrontPageBytes
******************STATION BREAK***********************
Do you want to know the latest on FrontPage?  Do you want Tips, news,
articles, links and ebooks on FrontPage?  Well the AnyFrontPage Bytes
Ezine is the best place for your FrontPage and web crafting needs, join
up at: http://groups.yahoo.com/group/AnyFrontPageBytes

Are you looking for  resources for FrontPage?  Want to know where all
the best FP links are?  The hosts, the lists, the forums? Use AccessFP -
FrontPage Resources Centre as the start site for your FrontPage
Information facts. http://accessfp.net/
~~Hal Cardon, PC Sleuth

No article this month.  You can e-mail me at abcomputers@xxxxxxxxxxxxx
Hal Cardona, PC Sleuth, serves as tech support and/or offsite Sys Admin
for over 200 clients around the US. He designs, builds, and
troubleshoots networks and builds custom computer systems.
~~by David Coons


Last month in "Parker's Mailbox", we learned about viruses and virus
hoaxes. http://www.personal-computer-tutor.com/parker7.htm

This month, in the Internet Connection, I wanted to delve a little more
into the psychosis that is behind the phenomenon that is...E-mail Hoaxes
of the non-viral kind.

It never fails to amaze me how often e-mails come into my
inbox offering something for nothing. In all honesty, over 90% of all
such emails are indeed hoaxes. Personally, I despise these little facets
of our existence, which is why I have decided to write about them this
month. I hope that, after reading this article, you are able to join the
resistance movement against SPOAX (That is short for for SPAM-HOAX).


The easiest one, by far, are the 'Forward this and you will get a big
surprise' messages. If you are on the net, you have probably received at
least one of these in your lifetime. The most common are the EMAIL
TRACKING messages. The concept is simple: a major corporation [or two]
have decided to give valuable prizes to everyone who forwards a special
message to their friends. The email, then, is being tracked to see how
many people to whom it will be forwarded. One of the first and most
recurring iterations of this hoax involves Microsoft, Disney and BETA
(The Beta Email Tracking Application). "

"Forward the email...and when it goes to X number of people everyone
will receive a trip to Disney World and a free copy of Windows 98."

The thing that I find most humorous about this is that Bill Gates
denounced this hoax in his book, The Road Ahead.

Even after this official announcement as a hoax, the email continues to
be sent along by people who refuse to take the time to check on its

Another version of this abomination says that after your forward the
message to 10 people, a coupon or a surprise or something will appear on
your screen. Apparently, the application is so tied in to your computer
system and your email application that it will magically know when you
have forwarded the email to exactly 10 people.

Now, I don't want you to confuse these 'forwarding' SPAM
HOAXES with the less devious sentimental emails that people
ask you to forward. Generally, they will go something like this:
--- "A friend is a friend indeed, more important than all of the marbles
in the world combined. You are a special friend." Now, forward this to
10 people or you will single-handedly be responsible for the disturbance
of peace in this world. --- Although sometimes annoying, these emails
are not meant to deceive, but rather to encourage.


A not-so-distant cousin of the above hoaxes are the chain letters. These
chain letters can have any content imaginable, from poetry to simple
well-wishes. Generally, the 'authentic' chain letters will supply a list
of the poor souls who broke the chain. Generally, they will read
something like this:

Thomas McElravy, from Spokane, Washington, broke the chain
back in 1999 and was immediately captured by aliens and given an
intensive, painful anal probe for three days. In addition, his library
card became invalid.

I hope that I don't even need to comment on the validity, stupidity and
other goofy nature of these kinds of emails.


Another example of how people have two much time on their
hands are the breaking news stories that generally make you cringe. If
you are active on the net, then you have probably heard one or more of
the following stories:

 Rattlesnakes in the playballs at McDonalds

 AIDs infected needles in the coin returns on payphones

 Someone waking up in a tub of ice and their liver surgically removed

 "Welcome to the wordful world of AIDS" written on the hotel mirror

 The problem of rat poop on softdrink cans

 Flashing your car lights and getting shot as part of a gang-thing

 The <cringe> toothbrushes in hotel rooms story

 The Modem Tax being passed by congress

...and the list goes on.

Three Different Types....The Same Ignorance

These are probably the three easiest and most prevalent
classes of SPOAX on the web (behind the virus warnings of course). There
is an easy way to not get caught up in the web, however. Simply, ask
yourself three basic questions:

1. Is this something that realistically would be announced in email? The
truth is usually NO. If there is a fatalistic computer virus or
rattlesnakes in the playballs at McDonalds, there would generally be
news coverage or some other way for people to alert the American public
through forwarded emails. The odds of any drastically serious
announcements being brought to the world over the Internet via forwarded
emails is practically nil.

2. Would an intelligent person blindly pass this email on?
Ha Ha Ha. I joke in a way, but in a way I am speaking truthfully. Some
of these emails are so silly that I find it incredibly hard to believe
that people fall for them. "Forward this email and we will send you
$1000" usually doesn't pass the test when you consider that it is
$10,000 for each 10 people to which the email is forwarded. Who would be
stupid enough to pay that kind of money? Simply try to talk things
through with yourself.

3. Is there a way for me to quickly check this out? The answer is almost
always YES. 99% of email hoaxes have been discussed and berated on the
Internet. Simply log into GOOGLE or YAHOO and type the general subject
of the email and then type hoax.


 microsoft disney beta hoax
 snow white virus hoax
 outback steakhouse coupons hoax

Another easy way is to go to the source of the email. Whether it is
Microsoft, Outback Steakhouse or the CIA, most companies who are targets
of SPOAX will set the record straight on their websites, such as listed
below. http://www.outback.com/pressroom/

"If you are contacting us about a chain e-mail you have received please
note that the e-mail is not in any way affiliated with Outback
Steakhouse. As with Gap, Bath and Body Works, etc. many large companies
are targeted with such fraudulent problems. We apologize for any
inconvenience and appreciate you coming directly to us for the answer to
your question."

My UP-ON-A-SOAPBOX Conclusion

Basically, what it all comes down to is responsibility and laziness. It
is easier for a person to FORWARD an email to their entire mailing list
than it is to check out the validity of it first. 9 times out of 10,
these emails are bogus hoaxes and not only can it frustrate your
recipients, it can also make you look very naive and gullible. Your
heart may be in the right place when you warn your friends about the
Satanic messages that are in store bar codes, but you are doing more
harm than good when you forward these without checking them out first.

And finally, remember this:

If you mistakenly FORWARD a bogus email and then realize
the error of your ways, please send a follow-up email to the same group
and apologize and promise to check your stories out more closely in the
future. Recently, I received an email about a virus-infected file that
you need to delete off your system. I quickly researched it and found
that it was a hoax. Before I could reply to the list, however, someone
else replied to the list, thanking the sender and saying that the file
was indeed on her system and she immediately deleted it per the
instructions. In actuality, the file was a part of her regular operating
system. This hoax came in the form of getting someone to act against a
fake hoax. Make sense?

The moral of the story is this: Before you act on an email, please know
the source, verify the story and for goodness sake, BLINDCOPY (bcc:)
your mailing list. :)

Until next time,
David Coons is a freelance writer and web designer from the suburbs of
Atlanta, Georgia.  When not spending time with his wife and three
daughters, he maintains several websites, including his current
missions-related shopping site, MyFutureMall.com. =A0
Table of Contents in Excel
Part II

Thanks to those of you who responded with ideas about
creating the Table of Contents with page numbers.  Many of
you had great thoughts and techniques.  James near Lafayette Louisiana
was on the right track and the closest of any to getting a working
solution.  Thanks James!

Before we can begin, we need to find a way to count the printed pages in
Excel.  Unfortunately, there isn=92t a property or method
like: ActiveWorkbook.Pages().Count or
ActiveWorkbook.PageNum.  We need to come up with our own
method of counting pages.  Existing methods that we will use are:



As I=92m sure you can guess the methods count the number of
page breaks.  Consider the following grid representing a worksheet.
Each box of the grid is a different page:

In this case the worksheet will print on 12 pages.  Counting the page
breaks there are two vertical and three horizontal. Note that none of
the borders count as page breaks.

So, if we add one to both the horizontal page breaks and the vertical
page breaks and then multiply the two together we can determine how many
pages will print.

(HPB + 1) * (VPB + 1) =3D

(3 + 1) * (2 + 1) =3D 12 pages

Now we=92ve just got to incorporate it into the code.  When pasting this
code into your own application, remember to delete the line numbers.
I=92ve just added them for reference.

1. Sub TableOfContents()

2.     Dim ws As Worksheet, wsTOC As Worksheet

3.     Dim r As Long


5.     Application.ScreenUpdating =3D False


7.     Application.DisplayAlerts =3D False

8.     On Error Resume Next

9.     Sheets("Table of Contents").Delete

10.    On Error GoTo 0

11.    Application.DisplayAlerts =3D True


13.    Set wsTOC =3D ActiveWorkbook.Worksheets.Add _

14.        (before:=3DActiveWorkbook.Sheets(1))

15.    wsTOC.Name =3D "Table of Contents"


17.    wsTOC.Range("A1") =3D "Table of Contents"

18.    wsTOC.Range("A1").Font.Size =3D 18

19.    wsTOC.Range("A1:D1").MergeCells =3D True

20.    wsTOC.Range("A3") =3D "Sheet Name"

21.    wsTOC.Range("B3") =3D "Page"


23.    r =3D 4   'If you change this number, you must

24.            ' change it on line 42 as well

25.    For Each ws In ActiveWorkbook.Worksheets

26.        If ws.Name <> wsTOC.Name And _

27.            ws.Visible =3D xlSheetVisible Then

28.            wsTOC.Hyperlinks.Add _

29.                anchor:=3DwsTOC.Cells(r, 1), _

30.                Address:=3D"", _

31.                SubAddress:=3Dws.Name & "!A1", _

32.                TextToDisplay:=3Dws.Name

33.            r =3D r + 1

34.        End If

35.    Next


37.    'Now we're ready to insert page numbers!


39.    Dim PageCount As Integer, PageNum As Integer


41.    PageNum =3D 1     'Initialize the starting page.

42.    r =3D 4           'reset our starting row.

43.    For Each ws In ActiveWorkbook.Worksheets

44.        If ws.Visible =3D xlSheetVisible Then

45.            If ws.Name <> wsTOC.Name Then

46.                wsTOC.Cells(r, 2) =3D PageNum

47.                r =3D r + 1

48.            End If


50.            PageCount =3D (ws.HPageBreaks().Count + 1) * _

51.                (ws.VPageBreaks().Count + 1)

52.            PageNum =3D PageNum + PageCount

53.        End If

54.    Next


56.    wsTOC.Cells.Columns.AutoFit


58.    Application.ScreenUpdating =3D True


60. End Sub

Some of the code shown above has already been discussed 2 issues ago.
Please refer to it if you have any questions.

The first part to discuss is found on lines 7 to 11

7.     Application.DisplayAlerts =3D False

8.     On Error Resume Next

9.     Sheets("Table of Contents").Delete

10.    On Error GoTo 0

11.    Application.DisplayAlerts =3D True

If you have created a TOC and try to rerun the code, you will get an
error because the page already exists.  This segment of code will delete
the Table of Contents if it exists (assuming the sheet is called =
of Contents=94).  Line 7 and 11 turn the alerts on and off respectively.
Whenever you delete a sheet a warning is displayed asking if you are
sure.  We don=92t want that to occur here so the alerts are turned off
temporarily. Lines 8 and 10 deal with error handling which will be
discussed in a future issue.  For now just understand that if there is
not a sheet called Table of Contents and our macro tried to delete it an
error would occur.  Line 8 tells the macro to ignore any errors
occurring after that point and line 10 tells it to once again check and
stop on errors.  Line 9 is pretty straight forward; it deletes the sheet
named =93Table of Contents.=94

Line 39 declares more variables used to count pages.  Some programmers
will argue that it is poor coding to declare any variables except at the
top of the procedure.  However, as you can see, it can be done nearly
anywhere and for sake of clarity.  I=92ve declared them near the code =
will be using the variables.

39.    Dim PageCount As Integer, PageNum As Integer

Line 41 initializes PageNum to 1.  If you don=92t want to count the TOC =
your page numbering then set it equal to zero. Line 42 resets the
starting row.  This number should be the same number as is found on line

41.    PageNum =3D 1     'Initialize the starting page.

42.    r =3D 4           'reset our starting row.

Line 46 places the PageNum into column B for the appropriate worksheet.

46.                wsTOC.Cells(r, 2) =3D PageNum

Line 50 and 51 is where we=92ve inserted the formula from above. It =
the horizontal and vertical page breaks, adds one to both of them and
then multiplies them together, giving us the number of pages on that
worksheet.  Line 52 adds the PageCount for the current worksheet to the
total PageNum for the workbook.

50.        PageCount =3D (ws.HPageBreaks().Count + 1) * _

51.            (ws.VPageBreaks().Count + 1)

52.        PageNum =3D PageNum + PageCount

After running the macro you will have a Table of Contents with
hyperlinks to each worksheet plus an accurate Table of Contents for the
printed version of your workbook.

What would you like to see in Chad's section of ABC?  Email your request
to Chad at chad@xxxxxxxxxxxxx with the subject =93Idea for ABC.=94  If =
are the first person to submit the idea and he uses it, he will pay you
$5.00.  (Okay, I know it isn=92t much, but hey, I=92m no millionaire, =
and I
have no sponsor.  The money comes from my wallet, meager as it is).
Remember, the idea should be about VBA or automating tasks in Microsoft
Office programs. $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

Chad K. Welch works as a technician/enabler in Utah.  He is available
for consulting or application programming with Microsoft Office and VBA.
Contact him directly for more information at chad@xxxxxxxxxxxxx
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and might make this
clearer for you. http://www.personal-computer-tutor.com/corey8.htm
~~Corey Seaton


Choosing the Internet Sharing Software

Again, it's time to make a choice. There are many different ways of
doing this, and they all have their pros and cons. Luckily every way can
be tested (with free downloadable demos and so on) so you can find a
solution that=92s right for you.

The first thing to do is choose whether you want your server
to be a proxy server or a NAT router. If you've ever configured your web
browser to use a proxy you'll have an idea what a proxy server is -
basically the server computer sets up a "pretend" web server, email
server etc which the client computers connect to, and thus they
indirectly connect to the internet. On the other hand a NAT (network
address translation) router forwards network packets to and from
clients, creating the illusion that each client is connected directly to
the internet. This simplifies configuration for the clients - as far as
they're concerned they're connected directly to the net! To be honest I
can't think of any advantage of a proxy server over a NAT router, but I
can think of many disadvantages - it's harder to set up on the server,
it's harder to set up on the clients, less internet applications will
work on the clients Therefore I unreservedly recommend you choose a NAT
router over a proxy server.

There are 4 NAT routers that you should consider, each with their good
and bad points. The only free one is Microsoft's Internet Connection
Sharing, which comes with Windows 98 Second Edition and above. The most
popular program is probably  Sygate, http://www.sygate.com/#Sygate

but other good ones are NAT32 (a little harder to set up but the
cheapest I know of) http://www.nat32.com/#NAT32

and Win Route (excellent because it has built-in firewall capabilities,
but more expensive). http://www.tinysoftware.com/#WinRoute

You should probably try each one to find what's right for you - they can
all be trialed for free, so there's not really any reason not to try
them all before deciding what to stick with. Be sure you only have one
installed at a time!

Setting up a NAT router has 2 components -

(1) installing the NAT routing software on the server,
(2) configuring the internet applications on the client computers.

Installing the NAT Routing Software

Microsoft Internet Connection Sharing for Windows 98SE
and Windows ME

This software is good because it is free and very easy to install. Its
disadvantages are that it's not very powerful (e.g. it doesn't allow
port mapping, which all of the other programs do - port mapping is
something that you'll probably want to do later on when you get the hang
of networking) and that it's said to be technically inferior in terms of
speed, reliability and so on. A lot of people can't get Internet
Connection Sharing to work with a USB Ethernet adaptor. Overall, it's
great for beginners, but if you have a USB Ethernet adaptor you might
need to use another program - or buy yourself another PCI network card.

Microsoft Internet Connection Sharing is very simple to install. On the
server, go into the Windows Control Panel and open "Add/Remove
Programs". Click on the "Windows Setup" tab, double click on "Internet
Tools" and tick the box labeled "Internet Connection Sharing".

Click OK then OK again to exit out of the "Add/Remove Programs" control
panel. You'll need your Windows CD. The Internet Connection Sharing
Wizard will now take you through a couple of simple steps to set up
sharing. Don't worry about the floppy disk the Wizard asks you for - put
one in just to keep it happy, but you won't need it. When the Wizard is
finished you will be prompted to restart your computer.

Now all you need to do is configure the software on the client machines
(see below) and you're done!

Microsoft Internet Connection Sharing for Windows 2000/XP

This is very easy to set up - even easier than Internet Connection
Sharing for Windows 98! As with ICS for Windows 98, it is not very
powerful, and is thus most suited to beginners or those with a tight

To set up Internet Connection Sharing for Windows 2000, open the Control
Panel on the server computer and choose "Network and Dial-up
connections". Right-click on the network card that's connected to the
cable modem and choose "Properties". Click on the "Sharing" tab and tick
"Enable Internet Connection Sharing for this connection". Now click "OK"
and *drum roll* that's it!!

 Sygate Home Network

This software is very popular because it's easy to use, powerful and
reasonably priced.

Installation is easy. Download the software from here.

Install Sygate on the server computer by running sygate.exe. When the
installer asks you which mode to install as, choose server mode and
click "OK". For now, just click "I am a trial user" when prompted. The
"trial key" was displayed at the Sygate website when you downloaded the
demo; if you can't remember it you can go back to the link (it doesn't
change very often). You don't need to enter a user name; just enter the
trial key and click "OK". Restart the computer when prompted.

That's it! Once your server's restarted, your client machines should be
able to access the internet!

TIP: You'll probably want to go into the Sygate Manager (which loads at
startup) and tell it NOT to load at startup, since it's quite annoying.
You do this by clicking on the "Tools" menu and un-ticking Load Manager
at startup. Note that the Manager and the Engine are 2 different things
- it is the Engine that actually does the NAT routing; the Manager is
only for configuring things. So you probably want the Engine to start
when Windows does, but not the Manager


NAT32 is quite powerful, yet it's the cheapest of the commercial NAT
routers. Its main advantage is its price; its disadvantages include that
it's much harder to set up and that the client computers seem to get a
slower connection than the server does.

To install, download the software from here. http://www.nat32.com/

Unzip the file you downloaded to C:\Nat32 on the server. Open your now
familiar Network Control Panel, and click on "Add...=94 choose =
then click "Have Disk...". Under "Copy manufacturer's files from:" type
in "C:\Nat32" and then click "OK". Select the correct version of the
NDIS3PKT driver depending on your operating system and click "OK". Click
"OK" to exit the Network Control Panel. You'll need your Windows CD and
then you'll need to restart your computer.

Run C:\Nat32\Setup.exe to install NAT32 proper. The installation program
is ultra-fast and for once you won't have to re-start you computer.

Now run "Configure NAT32" from your start menu. When asked
to select which Interfaces you would like NAT32 to use, make sure that
both your network cards are selected (if you have no other network
devices you can just click "Select all"). Make sure "Create a shortcut"
is ticked - this is useful for starting NAT32 later. Click "Continue..."

Next you need to configure your Interfaces. In my installation of NAT32
everything was already correct and I didn't need to change any settings.
The main thing to be sure of is that the network card connected to your
home network has "Secondary" ticked and "Share" un-ticked, whereas the
network card connected to your cable modem has "Primary" and "Share"

Click through the remaining dialog boxes until you get to the console

Now, unfortunately, you'll need to change a couple of the TCP/IP
settings that I told you to put in earlier (sorry!). Basically, on each
client computer you need to open the Network Control Panel, click on
"TCP/IP" (or "TCP/IP -> [name of network card]" if that's what you used
before) and click on "Properties". In the "Gateway" and "DNS" sections,
you need to change the "" entries to "" - you do
this by clicking the old entry and then clicking "Remove", and then
adding the new entry (i.e. in the same way as you
originally added Click "OK" twice to exit the Network
Control Panel and suffer yet another Windows restart.

Now you need to do configure the software on the client machines (see
below) and you're done!

 Win Route Lite

Win Route is great because it is easy to install, has excellent NAT
routing, and (this feature's awesome) it features a powerful built-in
firewall. I would recommend it to everyone - in fact, I guess I do - but
it is by far the most expensive program of the ones on this page!

To install Win Route Lite, download the software from here.

Install the software on the server by simply running the installation
program you downloaded. You will be prompted to restart your computer.

Once back into Windows, double-click on the Win Route icon in your
system tray (at the bottom right of your screen). Click on the
"Settings" tab. Under "Select the adapter used for Internet connection",
click on "2nd network adapter..." and choose the network card that is
connected to your cable modem.

Configuring the Software on the Client Computers

This is so easy that it hardly merits a place on this page! All you have
to do is a little bit of mucking around with the setup of each of your
programs - and in fact, most programs don't need any changes at all, and
therefore most of them should already work! If they don't, they simply
need to be told to access the internet through a LAN (local area network
- your home network!) rather than a traditional modem. For example, in
Internet Explorer, go to the Tools menu and select "Internet Options".
Click on the "Connections" tab and select "Never dial a connection".
Simple isn=92t it? :-)

(For best performance you should also click on "LAN Settings" and make
all these settings are the same as they are on your server computer.)

Happy Networking!
Corey Seaton is a Systems Support Officer with Queensland Health.  He
also moderates an email group on Home Networking. Why don't you join and
talk to others who are networking their home PCs?
~~ Fred Arshoff


There are two types of viruses that usually get into Microsoft products.
They are as below, in no specific order.

1. Macro viruses
2. Email viruses

The email viruses are a lot more dangerous to most users than the macro
viruses.  The reason is the email viruses can cause you to loose data
and, if you're using a Microsoft email program (Microsoft Outlook or
Outlook Express), the viruses send themselves, without your knowledge,
to everyone in your address book.  Some of the newer ones send to  each
person whose email is in your Inbox.


Macro viruses effect only the applications that the macro is written in,
and thus don't effect your entire hard drive; you don't lose all your
data or have to format your hard drive. One of the best methods to avoid
getting these type of viruses
is this:   when you open a document, unless you recall placing a
macro in it,  when the application asks you if you wish to open the
macro, say no.  By doing that, the macro won't open and damage the
document.  These types of viruses will damage
(corrupt) the document you're working on and sometimes
spread to other documents in the same application.  It won't
cause you to format your hard drive.   Macro viruses are
written in the MACRO LANGUAGE of the applications that the program uses.
A macro virus made to effect Word documents won't damage (corrupt) an
Excel document.  To learn more about macro viruses in general go to
these URL's:

Antivirus at About.com
click on macro's to get information on macro viruses.

The Macro Virus

Macro viruses: How they spread, prevention, and removal ... from

Microsoft Office Vulnerability ... from Sophos Support

One of the first macro viruses was the Laroux virus and there
are many variations of this virus.   To learn more about this virus
go to any of the following URLs. There are many variations of this virus
and we are giving you a few to read up on.

Trend Micro




Most of today's viruses are sent by email, without the person sending
the virus knowing they sent the virus to someone. These viruses go
through WINDOWS MAPI system. There are hoaxes that state by putting in a
false address beginning
with !!!  the virus would be stopped.   This isn't true at all.
If it was email you sent, it would stop the email from going. Because it
was programmed to send by itself, it sends itself to all valid email
addresses in your address book and many
to addresses in your INBOX.   As an example of these
viruses sending themselves:   a couple of years ago someone I
was associated with sent me an email with the subject " I Love you." I
knew this person would never send me such an email, as we only emailed
each other business things.  What I'm trying to to tell
you is this:   that by looking at the subject you may know it is a
virus and delete it before your computer gets infected and you send the
virus to more people.  What you should do as soon as you determine that
a person sent you a virus- you should phone them (provided it is a local
call and you have their phone number)
and inform them they have such and such a virus.   If you can't
phone them, email them and inform them.  What I did in the case above,
was call the person by phone with the information.  The person thanked
me for the information and asked for removal
details.   No one would become angry at being told they have a
virus, as no one would want to keep a virus on their computer, and send
it without stop to family and friends.  One way, and the way I most
highly recommend, to avoid getting an email virus is by not opening any
attachments that you weren't informed you would be receiving, and also
by verifying the size of the attachment. If the file is bigger than you
are expecting,  it usually means there is a virus in the file.  Viruses
do make things bigger as they are coded into things.


As you all must be aware, Microsoft is one of the biggest software
vendors in the world, thus people target them to get
attention.   If they targeted John Smith's software, whom no
one had  heard of, would it make the news?   I don't think so.
Thus, by targeting Microsoft, they get their name or virus
they wrote in the news. Of course Microsoft is doing all it can
to prevent these holes for viruses to slip through.   They have
hundreds if not thousands of software engineers looking into ways to
make their products more secure to avoid viruses going through them or
allowing someone to hack into your computer. Also, Microsoft themselves,
had to close down their servers on occasions due to getting one the
viruses that went through a hole in a Microsoft product.  They lost
millions of dollars in revenue, plus paid employees overtime to remove
the virus from their servers, and had staff who couldn't work but still
had to be paid. So a virus is not something Microsoft wants at all.
Microsoft finds out sometimes about the holes from security companies
before or right after a virus is discovered and starts working
to make a patch to correct that problem.   At Microsoft's web
site you will see many patches to correct various problems (either
security wise or user problems) that had to be corrected. One of the
viruses that got into Microsoft's sever was the "I Love You" and, if my
memory is correct, they had to close their server for two days to remove
the viruses and get
everything set back up correctly.   Although a lot of viruses do
go through Microsoft products, lets not constantly criticize them. They
are doing the best they can to avoid having holes to let viruses slip
in.  We also have a part to play by being careful what attachments we
open up and, if we do unknowingly send a virus, notify  the people
receiving it, so they can delete that message in order that  the virus
won't spread.  Also, if you spot a hole, inform Microsoft so they can
plug the hole before someone else makes a virus that will slip through.

Rash of new viruses
As many of you must be aware, in the past couple of weeks
there seems to be a rash of new computer viruses. I say there isn't
really a bigger number of new viruses coming out then is the norm. On
the average day there is at least 10 new viruses coming out. For more
details on this go to this URL:

2001: Year of the Virus

What you should do and I advise each and every one of my clients to do
is, at least once a week, update your AV data files. If there is a real
major outbreak the new data file protecting against that particular
virus will be made usually the same day. Most AV vendors update the data
files on Thursday PM's so go after 8PM EDT to get the new data file and
protect yourself.
Fred Arshoff is self employed in the computer industry where his
favorite thing is troubleshooting security and virus issues. He runs two
Yahoo groups: Fred's Findings
and Fred's Virus Info. http://groups.yahoo.com/group/freds_virusinfo/

~~Kathleen Anderson, Spider Web Woman Designs


Happy New Year! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Before we get started, I have to give you an update on Bobby (ABC, Vol.
4). http://www.personal-computer-tutor.com/kath4.htm

Unfortunately, the downloadable version of Bobby is no longer free.
CAST, the organization that developed Bobby, is now charging $99 for a
single-user copy (they also have site licenses available). You can read
more about this at their site.
In this article we are going to discuss the DOCTYPE declaration, also
known as a Document Type Declaration. In Internet Explorer, do a View |
Source on a web page and you should see, at the very top of the page, a
statement that looks something like this:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

HTML standards require that you include this statement in all your HTML
documents. Why? One reason is that it tells a validator which HTML
specification to use when validating your page (see Resources at the end
of this article for the best known validators).  The other reason is
that, new versions of browsers are finally starting to use the DTD to
determine how to render your pages. These browsers include IE 5 for the
Mac, Netscape 6, and Mozilla. Internet Explorer for the Mac features a
new rendering engine, "Tasman", provides full support for the published
Internet content standards as defined by the World Wide Web Consortium
(W3C)! Netscape 6 (currently at version
6.2) appears to be much less quirky than Netscape 4.7. And then =
my personal favorite =96 Opera =96 IMHO, the most standards compliant
browser on the market today.

Why use the Transitional declaration, instead of Strict? HTML 4
Transitional includes all elements and attributes of HTML 4 Strict but
adds presentational attributes, deprecated elements, and link targets.
HTML 4 Transitional recognizes the relatively poor browser support for
style sheets, allowing many HTML presentation features to be used as a
transition towards HTML 4 Strict.

If you are using Frames, this is the DOCTYPE for frames pages:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Frameset//EN"

If you=92re using FrontPage, you=92ve probably noticed that FrontPage, =
default, doesn=92t code a DOCTYPE in your pages.  Here=92s how you can =
around this:

In Microsoft FrontPage, there is a file on your computer that is used as
the 'template' for the new_page_1.htm that's created either when you
open your web or when you hit the "New Page" button.  The file is called

In a normal install of FrontPage 2000 and 2002, this file is in
C:\Program Files\Microsoft Office\Templates\1033\Pages\ normal.tem\

You can open this file in FrontPage and edit it like you would any other
web page.  Navigate to the directory where the file is located, open the
file and choose File | Properties.  You can add things that you want to
be common to all the new web pages you create from this point on in all
your webs, like your Meta tags for Author, Copyright, Rating, etc., and

Here's a DOCTYPE statement that you can copy and paste into
the template, it goes before the <html> tag (in HTML View). The DOCTYPE
statement must be at the very beginning of your HTML. To see what I
mean, do a View | Source on this page.

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

When you've added it, do a File | Save As Normal.htm (Yes, you want to
overwrite the file). From that point on, every new page you create will
have a valid DOCTYPE declaration.

Known exceptions:

 When you create a new web and a home page is created for that web
(either index.htm or Default.htm), it doesn't appear that the Normal.htm
file gets used as a template.

 In FrontPage 2002, there are several wizards you can use to create a
new web - these wizards do not use the Normal.htm file as a template
when creating the new web.

For pages you=92ve already created, you can use ErrOmi to find the pages
that need one added. If you are using FrontPage 2000, ErrOmi will warn
you about missing DOCTYPES. If you=92re using FrontPage 2002, ErrOmi =
actually add the missing DOCTYPE for you!

Resources (all free):

W3C HTML Validator

Web Design Group (WDG) HTML Validator

NetMechanic Toolbox

IE 5 for the Mac

Netscape 6.2 =

Opera Browser


ErrOmi  http://www.solution-shelf.com/FrontPage/ErrOmi/EO_FAQ.htm
Kathleen Anderson is a webmaster at the State of Connecticut and chairs
their committee on web site accessibility for persons with disabilities
She also has her own web design company,
Spider Web Woman Designs, at
EDITOR'S NOTE:  It is recommended that you read the online version of
the following article which includes pictures and might make this
clearer for you. http://www.personal-computer-tutor.com/corey8.htm
~~Steve Mills


 2xExplorer ... 6 geezers
 Photocopier ... 4 geezers
 Digital Camera Enhancer ... 4 geezers
 Oscar=92s Renamer ... 5 geezers

Preamble =96 Well, I guess this is version 1.0 of this column. =
we will evolve over the coming months as we exchange ideas and have to
issue a Service Release with new enhancements. This column will have an
unusually high number of top rated programs. I guess that is natural as
it includes some that I have been using regularly and learned to

A word about ratings.

Each program will be given 1 to 6 =93Geezers=94 . Programs rated 4 and =
will be worth serious consideration. Take a look at my bio, if you care
to see some of my thoughts on ratings.

Let=92s get started: =
Program: 2xExplorer

Version and Date:     12/16/2001
Web Site:
License: Freeware
Rating: 6 Geezers

As tough as it is to admit, I=92m becoming a fan of XP. I just don=92t =
to reboot as often. Explorer, however remains an incredibly lame
program. Billy still hasn=92t come up with anything as good as Norton
Commander, XTree or a hundred other DOS classics. Over the last five
years or so, I=92ve tried a couple of dozen replacements =96 better than
Explorer, but none became a permanent part of my system until
2xExplorer. This is a multi-pane file manager, with a plethora of
options. You=92ll be using it right away and gradually begin to use the
more obscure features. For instance, when I originally wrote this
review, I commented that the program would be nearly perfect if it had
an internal graphics viewer. When I went to the site to check some
information, one of the screen shots showed a layout, which was EXACTLY
what I wanted. Never knew this capability was there. What a good, well
designed program AND it=92s REAL freeware. Get it!
Program: Photocopier

Version and Date: 2.24     1/2/2002
Web Site:
License: Freeware
Rating: 4 Geezers

This is one of those programs that was much harder to find
that I would have thought. Several years ago, I bought a simple program
from Disney to use my scanner as a copier. It had =93issues=94 and was
passed from company to company and I never could get any resolution.
Anyway, it didn=92t work with XP. I know some of the newer scanners have =
button right on the machine to do this, but my Epson 1200U doesn=92t. I
don=92t make a lot of copies and just needed something quick and simple.
Photocopier fills the bill.

One minor gripe =96 the program only prints to the default printer. So, =
you=92re like me and have a B/W and a color printer, you need to set the
printer before executing the program. Not a big deal, since most copies
will probably be black and white.

Photocopier is Freeware and a Pro version with more features
is available for $15. I haven=92t looked at it, because the freebie is
just fine for my simple needs. You do get a small ad for the Pro version
when you close the program. A small price to pay for a fine utility.
Program: Digital Camera Enhancer

Version and Date: 1.3     1/26/2001
Web Site:
License: Freeware
Rating: 4 Geezers

I love quick and dirty programs and this is a beauty. Personally, my
graphics capabilities stink =96 big time. Slowly, I=92m learning =
but there are times I just need to quickly clean up a scan or picture.
This is the program I use. Here=92s the description from the web site:

"Digital Camera Enhancer does the hard job of noise reducing and
automatic balance control for you. And it is free!

"The program works best if you have bad light condition (indoor, shadows
etc..) and your image is somehow off. So if some of your images are
already fine, you won't see much difference. DCE makes very delicate

"One thing makes DCEnhancer different from other tools - reducing the
noise and skin smoothing algorithm. It makes DCE ideal for making cool
portraits and close-ups! "

I use it to frequently adjust pictures for Ebay. It won=92t resize the
image or change jpg compression, but it will balance and adjust quite
nicely. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Program: Oscar=92s Renamer

Version and Date: 1.0    12/9/2001
Web Site :
License: Freeware
Rating: 5 Geezers

What a cool program. There are several good file renaming programs
around, but I really like this one. The approach is somewhat unusual in
that it actually pulls file names into a text editor =96 you make =
and then apply them. There=92s a nice macro utility for repetitive
functions. If you manage a lot of files, this is a real time saver.

One possible bug - the program has an option to install itself into the
right click of a file name. Doesn=92t seem to work in XP, though.
On Deck:

Internet Explorer Enhancements =96 NetCaptor etc.
Clipboard Managers
Auction Managers for Buyers and Sellers

If you have any comments, criticisms, suggestions etc.,
just mail them to steve@xxxxxxxx
Steve Mills currently does clerical work with a search engine consulting
firm and has been reviewing software in different capacities for many
******************STATION BREAK***********************
NOTE FROM THE EDITOR:  On my Windows page at Linda's
Computer Stop, I list many email groups that deal with Windows and other
related PC issues.....one of my favorites is PCTechTalk, a great group
for newbies and techies alike.  It's run by a guy named Guitar Man and
he does a fantastic job.


G Man runs a free, 24-hour-a-day email tech list where you
can submit any questions you have about computer hardware
& software. You can request fixes for specific problems
you're having with your computer or just sit back and learn from the
conversations of the other members. This list is one of the only PC
Groups I've found that truly caters to newbies and nerds alike, so you
can be assured that your questions will be taken seriously. To join,
either click on the PCTechTalk link above, or send a blank email to


~~PCTechTalk's Guitar Man


First, here's the tech side of things broken down into simple English:

As you're probably aware, every message you download into OE
is stored in a special set of files in a single folder on your hard
drive.  Unfortunately, the space this email takes up isn't automatically
returned to its previously free state (where the hard drive space is
available to Windows for storing data) once you delete the message.
Instead, these files are altered in such a way that you can no longer
see or get to that particular message from within OE.  In other words,
THE MESSAGE IS STILL THERE!  The only difference is that you can no
longer see it in OE.

And now, how to fix this:

    Before you panic (as the realization hits you that all of those
messages you THOUGHT you deleted will eventually fill up your hard
drive). There is a simple way that you can permanently get rid of the
garbage as well as clean these files of all this wasted space.  It
involves getting yourself used to the habit of compressing each folder
the moment you decide you've finished going through the messages they
contain.  Below is an example to show you exactly what I mean.

Say you've been reading all of the jokes your friend Cindy likes to send
to you every few days.  If you followed my last two-part tip on creating
folders and Message Rules, you're probably reading them from within a
folder called Cindy (which is possible a subfolder of one called
Friends).  Before you click on another folder (and leave the Cindy
folder) to continue going through unread messages from your other
friends, click to File/Folder and finally on Compact.  You'll see a
status bar window open up and hear some hard drive activity.  What's
actually happening is that OE is examining the special file that stores
all of the messages that are in the Cindy folder and eliminating that
wasted space I mentioned earlier. When it's through (it could be almost
instantaneous or it could take a bit of time depending on the number of
messages stored in the folder), you will have compressed the special
file and the wasted space will have been returned to Windows.

If you can get yourself into the habit of doing this for EVERY OE folder
as soon as you're finished with it, you'll never have the problem of OE
preventing you from having as much free hard drive space as possible.

If the idea presented in this tip is completely new to you, you might
want to go the extra mile the first time you try it.  Instead of
choosing Compact, choose Compact All Folders in the directions above.
This command will tell OE to go through ALL of those special files and
get rid of all of the wasted space contained within them.  Just for
kicks, I HIGHLY suggest that you check your free hard drive space before
and after running it (open up My Computer and right click on your C:\
drive.  from the context menu that opens up, click on Properties to see
the info on your hard drive space).

Don't be too surprised if you regain a LOT of space.  If you end up
recovering more hard drive space than you ever dreamed possible, write
me a short email and tell me about
it (I just LOVE hearing success stories lol).             8^)
EDITOR'S NOTE:  ABC is building an archive of G Man's OE Tips

The group's motto of "The only dumb questions are the ones that are
never asked." reflects their philosophy that ALL questions are important
and they sure do treat them that way.  Also, if you've ever been a
member of an email list, you'll appreciate that this list's moderators
do not  allow Spamming, flaming, cursing, etc.. To sign up, just send a
blank email message to



You know what they are doing is wrong. Whether it be internet crimes
such as identity theft, child abuse, pornography, or spam, there are
places to report the abuse. Here are some of them.

Cybersnitch--The World's Most Advanced High Tech Crime Reporting System

International Internet Investigators http://safety.iweb.net.au/main.htm

Dept of Justice CyberCrime Website

Reporting Internet Crimes

Government Reporting Agencies

CBS News Story=97Minding the CyberNeighborhood

18 States have actual laws against spam, and more and more people and
States are filing lawsuits against the spammers who don=92t follow the
laws. The States that don=92t have actual spam laws may have various
e-mail or harassment laws to cover you also.

Spam Laws: United States: State Laws http://www.spamlaws.com/state/

Did you know that it is also against the law to fax unsolicited spam?
Check here for the laws, and how to protect yourself, and save YOUR ink,
paper, and phone line time.

National Compliance Bureau for Unsolicited Faxes

That=92s all for this month. Hopefully by next month, I will be able to
tell you about a new project that I am working on.
NightSneak is a private investigator and a collector of URLs. Her
specialties are security and privacy.
(19.)  The Dream Pusher
~ Michael Werner, Dream Jobs To Go

Finding Job Salaries in Different Geographical Locations=A0

Sometimes you=92re good, and sometimes you=92re lucky. Then again, =
you just call on your friends. This Find comes from a long-time friend
and associate, Eldon Sarte. Eldon runs the Dirtsmart Netpreneur and is
one of the savviest Web guys around. As such, he=92s always looking for
cool tools and services for his small business and webmaster readers.
This one, though, fits right in line with what the Dream Pusher is all
about.Salary.com supplies something called a Salary Wizard that=92s =
quite clever. And fun. On top of that, it=92s a freebie and a pleasure =
use. You select an industry or profession, specify a zip code or
state/metro area, and choose the exact job title you're curious about.
When you then click on Create salary report, the site=92s online =
spits out the median base salary as well as high- and low-end figures.
This is great for job seekers, of course, but if you're trying to figure
out how much to charge for your independent services, this is also an
excellent place to start. In addition, you=92ll also get links to real
jobs in your search and classfication area. And, there=92s a heck of a
whole lot more to pricing your worth (and what the market will bear),
obviously, so don't miss their How is this calculated? feature if you
need help in this area.
Michael Werner, aka The Dream Pusher, is a writer and
publisher who specializes in career and employment issues.
You can reach him through his website, Dream Jobs To Go.=A0
Well, gang.....that's about it for this edition of ABC ~ All 'Bout
Computers.  I sure hope you enjoyed it!  If any of it was over your head
and you need some clarification from one of the Fleet, just send me an
email at ABComputers-owner@xxxxxxxxxxxxxxx and I will pass it on to
them.  Remember that they do this in their spare time on a voluntary
basis, so you might have to wait for an answer.  To make all things work
more quickly, include as many details as you can in your email and make
your questions as specific as possible.  Also, feel free to write to me
and let us know what you want the Fleet to teach you.  This is YOUR

Happy computing, my friends!

Linda Johnson

In order to get what you want, you must send your email to the right
place. These are the correct addresses to use:
Subscribe: ABComputers-subscribe@xxxxxxxxxxxxxxx
Unsubscribe: ABComputers-unsubscribe@xxxxxxxxxxxxxxx
Ezine owner: ABComputers-owner@xxxxxxxxxxxxxxx
Or, you can go to the homepage for this newsletter and change any of
your subscription preferences: http://groups.yahoo.com/group/ABComputers
This FREE publication is sent ONLY to people who have requested it.
Note: My subscriber list is NOT made available to other companies. I
value every subscriber and respect your privacy. Do you know anyone who
might be interested in receiving this newsletter? Please feel free to
forward it on to them and invite them to subscribe.
Routine Disclaimer: Although I make an effort to check out every
advertisement and link, I cannot assume responsibility for the actions
of my advertisers, or the availability of links. You use the information
provided at your own risk, it is always wise to back up your data before
editing.All advice given in this newsletter/ezine or at Linda's Computer
Stop is given with the best of intentions and should only be taken as a
suggestion and not a definite fix to a problem. ABC ~ All 'Bout
Computers and Linda's Computer Stop are the property of Linda F.
Johnson. The views expressed by readers or contributors are not
necessarily those of Linda F. Johnson and, as editor, she reserves the
right to deny inclusion of any contributions if she feels they could be
harmful to someone's computer. However, just because she allows it to be
included, does not mean she is responsible if it causes problems. ALL
ABComputers by linking to my sites.
or, click on these links to become an affiliate under me and you will
earn money if you sell any of my ebooks (or any other books published by
these companies, for that matter):

Thank you for reading "ABC ~ All 'Bout Computers".
(Copyright) 2001, 2002 - ABC ~ All 'Bout Computers, Linda F. Johnson,
MA. ABC may only be redistributed in its unedited form. Written
permission from the editor must be obtained to reprint or cite the
information contained within this newsletter. Please feel free to
forward this newsletter to any of your associates who might benefit from
this information. If you are receiving this issue as a forward, and
would like to get your own free subscription, please see subscription
management above, or visit
to see back issues.

Thank you and I hope to continue to bring you a newsletter that you will
actually want to read.

Linda Johnson

Other related posts:

  • » [abcomputers] ABC~All 'Bout Computers, Vol.8: Vic's COOL Colored DOS Windows and More