[abcomputers] ABC ~ All 'Bout Computers, Volume 4: More Furniture Moving in Word

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

ABC ~ All 'Bout Computers
Volume 4; September, 2001 - mailed to 1107 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://www.personal-computer-tutor.com/ABC.htm
(frames) http://www.personal-computer-tutor.com/vol4.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://www.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

Do you have a website?  If you do, I would like to help you....and you
can help me.  Don't ya just love the way we can scratch each other's
backs on the Internet?

I am going to build a webpage where I will post links to all
subscribers' sites.  If you put a link for this newsletter at YOUR site,
I will put a link to your site on this new page.  Just link to this
newsletter using either of these links:




and send an email to ABComputers-owner@xxxxxxxxxxxxxxx
with the url where you put the link and I will link back to you!

Pleasure doing bizness wit ya .... and my back is a lot less itchy!  LOL
(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.  What's In This Issue

3.  Linda's Thought of the Month

4.  Linda's Soapbox ~ Who Owns MY Website, Anyway?

5.  What's New at Linda's Computer Stop

6.  Subscribers' Exclusive Tip ~ Getting That Sticky Window To Open

7.  GeekSpeak Translation from the Cap'n


~~Charles Kyle Kenyon, J.D.

Moving the Furniture To Someone Else's Home:
Sharing Your Customizations With Other Users


9.  Tina's FrontPage News ~ Help!  I Need Some ***

10.  Hal's Hardware Haven ~ Partitions and Multiple Operating Systems

11.  Jack's Internet Connection ~ Sometimes You Can't Get There
>From Here

12.  James's Database ~ OK, I've Built My Database. Now What? ***

13. Parker's Mailbox ~ Sharing Information in Outlook ***

14. Chad's Macro Mania ~ Clean Up This Mess! ***

15. Corey's Network Corner ~ Configuring Windows To Recognize the
Network Cards *** http://personal-computer-tutor.com/corey4.htm

16. Kathleen's Spider Web ~ Website Accessibility

17. Vic's Registry RoundUp ~ Assorted Windows Registry Tips

18. Outlook Express Tip from PCTechTalk's G Man ~ Backing Up the Address
Book http://personal-computer-tutor.com/gman.htm

19.  NightSneak's Snoop Scoop ~ Links For Info on Online Privacy ~ from
Master Links 4 Master Investigators

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:


Well....this is the issue that almost wasn't.  It seems a LOT of the
Fleet had computer problems this month which slowed things down. Plus I
went on vacation to sunny Fenwick Island, DE and expected to get a lot
done down there but ended up with a very bad internet connection and
difficulties with my laptop.  And, I just wanted to be at the beach.
Alas, I am human.

But the issue is here and jam-packed with great stuff!

First thing is....we have two new regular features!

One is VIC'S REGISTRY ROUNDUP.  For any of you who want to learn more
about the Windows Registry and how it works, Vic is "da man"! Please go
to the MeetTheFleet page and learn all about our newest Fleet member,
VIC FERRI. http://www.personal-computer-tutor.com/meetthefleet.htm

And while you are there, check out our other new member, ANNA MORVEE,
who will be doing a monthly column, starting with the next issue.
Anna's specialty is COMPUTER SAFETY AND SECURITY so she will be teaching
us how to practice Safe Cyber.

The second new addition is NIGHTSNEAK'S SNOOP SCOOP.
NightSneak has graciously accepted my invitation for her to share some
links with us from her website, "Master Links 4 Master Investigators".
NS is a private investigator in real life and she has collected links on
everything imaginable.  In this issue, she gives you lots of links to
help you with ONLINE PRIVACY.  If you like what she shares here, check
out what she has to offer at her website.

Our FEATURED ARTICLE this month is by CHAS KENYON and it is full of his
usual great content on how to make WORD work the way we want, as
individuals.  This guy is teaching me a lot and I thought I was a whiz
at Word.  And, of course, he gets into macros again, and CHAD WELCH
chimes in with a great article on more ways to clean up these macros
made by using the macro recorder and he uses EXCEL in his examples, so
you can become more accustomed to using macros in both programs.

HAL CARDONA is here again with yet another one of his great articles
(don't ya just love this guy?).  This time he explains how to setup
partitions on your hard drive so you can have your computer bootup with
MULTIPLE OPERATING SYSTEMS.  This is something I setup on my own
machine, with Hal holding my hand.  He knows this stuff very well!

And, KATHLEEN ANDERSON has started her series on
WEBSITE ACCESSIBILITY.  She's gonna teach us how to make websites that
everyone can enjoy and use.  Rumor is that she will be using this online
web-azine as one she will test for accessibility.  But we all know this
will pass with flying colors, because if you were having any problems
with it, you would let me know, right?  :-)

And, if all of this website construction is just too confusing for you,
check out TINA CLARKE's great article about USING HELP menus and
online resources.   A lot of what she tells you will help you get help
more than just FrontPage.

One of my favorite articles this month is JAMES LA BORDE's Access
article.  Since I am newer to ACCESS than I am to the other Office
programs, I hang on James's every word.  This article in his series
really gets into the meat of getting information into that database the
way we want it.

others on your network.  It's clear and understandable and addresses
many of the questions I used to get when I worked helpdesk and supported
Outlook with Exchange Server.

COREY SEATON tells us how to setup Windows to recognize our NETWORK
CARDS.  Boy, I wish I would have read this one before I did this.  Makes
it all perfectly clear.

And, good ol' JACK TEEMS explains what can be effecting our INTERNET
SPEEDS and how to see if we can fix it.  This is something we ALL want
to know!

And, please don't miss CAP'N PATT's GEEKSPEAK TRANSLATOR.
Even if you know what all the terms in the articles mean, it's worth
reading just to get to know the Cap'n.

Also, don't forget to check out GUITAR MAN's OUTLOOK EXPRESS TIPS.  This
month's tip is about SAVING YOUR ADDRESS BOOK. He's building an archive
now, so soon we'll have a large collection.

And, last but not least, have a look at WHAT'S NEW AT LINDA'S COMPUTER
STOP.  I've added some good stuff.

And please read LINDA'S SOAPBOX.  This one means a lot to me!

Most important -- Enjoy this newsletter and let us know what you think!

What's the ultimate level of trust between two computer geeks?

Sharing your passwords.  :-)
~~Linda F. Johnson, Editor


Well, people often warn me to stay away from controversial issues, but
it just ain't my nature.  When something that comes up in this world
upsets me, I just HAVE to open my big mouth.

And this one upsets me BIG TIME.=A0
I don't know if any of you are aware of the recent hoopla concerning
Microsoft's newest version of IE that will be released in its final form
later this year.  Seems Microsoft was trying to "help" Internet surfers
by adding "Smart Tags" to their browser, which would add to or replace
the links in websites.  This means, you would see additional links
supplied by Microsoft when you clicked on any link at a website.  Web
owners freaked out at this because we felt it was OUR right to direct
our viewers to the links WE chose and Microsoft was in fact changing the
content of OUR websites when they did this.  Well, good for us for
screaming about this.  Microsoft backed off on this idea for now.  And,
to give credit to Microsoft, I must say that they did provide a meta tag
for website owners to use which would disable this feature.

Now, there is a new problem.

A program called KaZaa Media Desktop is now the number 4 download at
CNet.  This program includes something called Top Text which does the
same thing noted above (that MS tried to pull on us) but this one offers
no way for website owners to disable it! (They do say we can write to
them and they will not include our site. My fear is that writing to them
will, in fact, alert them that we HAVE a site if they didn't already

Rather than tell you about this myself, I will quote some of my fellow
techies who say it well enough (with their permission, of course):


Hal Cardona:

"People.  If you aren't sure what we are talking about, let me tell you
a little bit about it. TopText adds links to web pages when they are
viewed in your browser, I call it scumware because what they do is
terrible IMHO. They sell these links to advertisers.  So, since I have a
web page and you visit it with the TopText plug in loaded, you will
see links on MY site that I didn't create!   If you click on one of my
existing links they offer you a way to go to one of their advertiser's
sites instead of following the link. Basically they are hijacking MY
links and, IMHO, infringing on MY copyright for MY website. They=A0are
advertising on MY site and NOT paying me for the privilege. Right now
it's being distributed by KaZaa.  Those of us who have our own web sites
would appreciate it if you would NOT use this."

G Man:

"While the main program may be good for peer to peer file sharing, it
also installs a secondary program without telling you the truth about
its use. This secondary program is called TopText from ezula.com and it
runs the Cydoor spyware trojan on your computer. The term Spyware is the
catch-all name for programs that watch what you choose to view/download.
This information is then stored on their server as your profile. This
profile can be used for many things that would place you and your
privacy in serious jeapardy. In addition to the above, this particular
program also creates links on websites to redirect you to sites that are
paying them a fee for this service. While this may not seem like a big
deal to you right away, it should be noted that it seriously hurts the
original site's webmaster by luring visitors away from her/his website
to other sites that are affiliated with the Spyware company and that
only want to sell you something (and collect information about you).=A0
To learn more about Spyware and why we should all be afraid of it, head
on over to http://cexx.org/problem.htm to read all about it. Here are
two more excellent sites for you to bookmark.
Go to http://www.spychecker.com and click on the "What is Spyware?" link
at the top.


"The flaw with KaZaa is the architecture and the means in which its
creators' promote it. Anyone can do a search on anything using KaZaa=92s
home page and get the IPs of 20+ online users.  With a bit of net savvy
one can view all shared files from each user on the KaZaa network. Why I
think this is bad: KaZaa's search engine exposes the IPs of its users to
non-users and only to non-users! KaZaa users have no clear way of
knowing who they are downloading from as far as I can tell. Further, if
you use the software you don't download from a single user you download
from all (the source of KaZaa's praise). If a would-be bad person uses
the search engine and you happen to have a static IP you are not only a
target you are advertising your IP but also your shared files. One step
further into paranoia: With it your IP might as well be your street
address (even more so if it is static), if someone - anyone - doesn't
like the files you are sharing there are no limits to the repercussions.
If you have a shared Metallica song, lawyers can trace you to your ISP
with ease for example and send them a nasty letter, etc. What could be
worse? A bad person does like what you have. This would-be attacker can
look for ways into your computer for what you don't want to share."


Thanks to my friends who said this all so well.....please, readers,
think about this long and hard.  This is truly big brother trying to
infringe on our rights.  While I don't think we, as consumers, can stop
KaZaa from doing this, I DO believe we can stop CNet from distributing
this horrendous software by letting them know our feelings.

PLEASE go HERE and rate this software....not only will this let CNet
know how we feel, but it will alert others who may be considering
downloading this crud!



Click here for the full story on this.

**This editorial reflects the opinions of Linda Johnson and the other
three people mentioned.  It does not necessarily reflect the opinions of
others associated with this newsletter.**

Linda Johnson is a college instructor of all of the Microsoft Office
Programs, as well as Adobe PhotoShop, Windows, and TeleCommunications.
She has worked helpdesk and teaches and lectures at many local
businesses in her area.  Support this newsletter by checking out Linda's


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
******************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!
(5.)  WHAT'S NEW at Linda's Computer Stop

This month was vacation month for me, so I didn't add as much to my site
as usual.  But I do have some new goodies for you:

I.  Two new members added to the ABC Fleet:

Vic Ferri

and  Anna Morvee http://www.personal-computer-tutor.com/anna_morvee.htm

Please visit their bio pages and send us an email to let them know you
appreciate them!

II.  And,

Vic has also added a Printing Tips page to my site and a list of some
great printing supplies vendors.  Great prices, including FREE

Vic's Printing Tips http://www.personal-computer-tutor.com/printing.htm

Printing Supplies


This is an article I wrote for Fred's Findings and have reproduced for
you here. http://www.personal-computer-tutor.com/suites.htm

IV.  Software Trainers Resources

This is a compilation of some of the resources I came across on the net
when I was researching my newest ebook, How To Get Started as a Software
Trainer (due to be published soon by Dream Jobs To Go). If you like what
you learn here, keep an eye out for the ebook so you can learn LOTS
more! http://www.personal-computer-tutor.com/STresources.htm

V.  And, of course,

Lots has been added to Cap'n Patt's GeekSpeak Translator

and my FUN STUFF TO DO ON THE WEB pages.  Look for
the revolving N's for the new ones:

so check them out too.

Well, that's the major highlights of what's new on this end.  I hope you
all will visit my website regularly and while you're there, go to the
bottom of my homepage and sign my guestbook.  I would love to "meet"

(6.)  And HERE'S A TIP, presented FIRST to you subscribers


Don't ya hate it when you go into your C:\Windows folder or your
C:\Windows\System folder and you get that message telling you not to
mess around in here and you must click on the link to "Show Files".
Just another example of Microsoft suggesting that it might be better
than us at managing our computers.  Both the Windows and the Windows
System folders are controlled by a hypertext template file called
folder.htt.  This file tells Windows to add this extra control and it is
in these two folders by default when you install Windows.  If you no
longer want to be bothered by this nagging extra step every time you
enter one of these folders, simply rename this file (right click on it
and select "Rename" and name it folder.old and hit Enter).  Now this
folder will behave like every other folder.

Want another way to make your Windows folder even more accessible?
Right now I assume you are going into Windows Explorer or My Computer
and navigating your way to it.  Well, try this.  In Windows 9X, go to
your Start button and select Run.  In the Run Box, type two periods in
succession (thats ".." or dot dot) and hit the Enter key.....and voila!
There you are inside that Windows folder and if you renamed folder.htt
to folder.old, you have quick access to your Windows files.

But, remember that Microsoft adds these warnings and hides files for a
reason.  The reason is that this is not a place to mess around if you
don't know what you are doing, so BE CAREFUL in there :-)

******************STATION BREAK********************
Bored in your job? Want to make a career change to something that you
have only "dreamed" of doing? I did this, at the age of 50, and you can
too. And, I've written an ebook about it, tentatively called "How to Get
Started As a Software Trainer", which is due to be published this Fall
by Dream Jobs To Go http://www.dreamjobstogo.com/?10456
Go here and see if your dream job has already been included in this
series. If so, snag the ebook for only $9.95 and you will be on your
way! If you are already employed in your dream job, go here and see if
you can sign up to write your own ebook to help others. They also have a
FREE weekly newsletter called Dream Jobs Dialog where you can get tips
and dialog from real life dream jobbers.  When you get to the site, just
look for the subscribe button in the upper right corner.

Hey....even if you already have a job, it's still fun to DREAM!!
~~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.
(8.) Chas' Word World
Charles Kyle Kenyon, J.D.

Moving the Furniture To Someone Else's Home: Sharing Your Customizations
With Other Users

In previous columns I've discussed customizing your own Word interface
to make it easier for you to get your work done. This can be done
through macros, AutoText, keyboard shortcuts, and custom toolbars. Once
you've gone to the work of creating these, it would be nice (and maybe
worth a few brownie points) if you could share them with your co-workers
and friends. These same procedures work to make a backup of your
customizations and make it easier for you to transport them to a
different machine.

Customizations in Word - Background

The customizations that you can make in Word include:

1.  Macros - recorded or written using VBA - these are kept in templates
(default Normal.dot) or documents. Unless you have a definite reason and
know what you are doing, keep them in templates.

2.  AutoText entries - also kept in templates (default Normal.dot).
AutoText entries cannot be stored in documents. For more on AutoText,
follow the links on my Web Resources page.

3.  Custom toolbars - also kept in templates (default Normal.dot) or
documents. As with macros, you will want to keep toolbars in templates
with rare exceptions. You make these with Tools =3D> Customize... or =

4.  Custom toolbar buttons and menu commands - really a subset of custom
toolbars except includes customizations to built-in toolbars and menus.

5.  Styles - also kept in templates except that after creation documents
have their own styles which are generally not updated by the styles in
the document's underlying template. See Understanding Styles for more
about styles. http://www.addbalance.com/usersguide/styles.htm

6.  UserForms - homemade dialog boxes and wizards

7.  Keyboard shortcuts (also called keybindings) are stored in templates
or documents.

8.  AutoCorrect entries - for the most part stored in separate files and
very different from AutoText in construction if not in use.

9.  Your user preferences (Tools =3D> Options) - stored in the =
Word data key. We won't mess with the registry here. (Keeping with the
metaphor of moving furniture, working with the registry is closer to
rewiring your house, with all of the implications that go with that

We will first look at the customizations that are stored in templates
and copying/moving them to a different template. That is: Macros,
AutoText, Custom Toolbars, Keybindings and Styles. We will then look at
those stored elsewhere: AutoCorrect Entries and user preferences.

Open the target template or a document based on the target template.

I would suggest that you move the items you want to share into a global
template. The simplest way is to open the template or create a new
document based on the template. You will want to use a document template
instead if the customizations only are used in a specific kind of
document that will have its own document template.

Starting a new global template

If you don't already have a global template, go to File =3D> New and =
"New Template" in the bottom right corner of the dialog box.

Select blank document. You can use this document to keep notes on what
you have done if you want. Save it using a name like "MyGlobal.dot."
Don't close it.

Copy your Styles

Use the Organizer:

(Tools =3D> Templates and Add-Ins... =3D> Organizer (button) =3D> Styles
(tab)) to copy your styles to a document or document template. I
recommend making the copies three times. This is so any styles based on
other styles will "take." Specifically, copy all of the styles you need
to copy once. Then copy the same styles again, and again a third time.
The second and third times you will be asked if you want to overwrite
the existing style(s). The answer to this should be "yes." Failure to
make the multiple copies may mean that your styles won't transfer
properly. If any of your macros apply your styles, you should copy the
styles before the macros.

Copy your macros

(Tools =3D> Templates and Add-Ins... =3D> Organizer (button) =3D> Macro
Project Items (tab)) to copy a macro module.

Probably, the macros will be in the Macro Module "New Macros." in
Normal.dot. If you already have a Module named "New Macros" in your
template, rename it "OldMacros" for now so you can copy the Module from
Normal.dot to your template. If there are other modules in Normal.dot
you want to copy those as well.

Then close the Organizer and save your template. Don't close the
template, yet.

Use the VBA Editor (Alt-F11) to look at the New Macros module in your
template (not the one in Normal.dot). You should be able to spot the
macros that you use. Delete any other macros and Ctrl-S to save your
changes to the Template. If you already had macros in your template and
had to rename "New Macros," double-click on that "OldMacros" module. For
now, you will want to move all the macros to your new "New Macros"
module. Then right-click on the "OldMacros" Module and remove it. Word
will ask you if you want to export first;
answer: No. With your insertion point back in the New Macros module of
your template, press Ctrl-S to again save your template.

Then double click on the Module "New Macros" in Normal.dot and delete
the macros that you transferred to your template. (Don't delete the ones
that you decided you don't use, just yet, in case you were wrong about
them.) Ctrl-S to save your changes to Normal.dot.

If you have macros that are called by toolbar buttons or keybindings,
the macros must be in place before you move these customizations. They
must have the same name and be in a module with the same name in a
project with the same name that  they were in before. i.e., the macro
named MyMacro that is in a module named TrustedMacros in project named
TemplateProject, will not work with a moved toolbar or keybinding unless
it, and the project and module keep the same names they had when the
toolbar/keybinding was created. They will run just fine if you give them
new names, but your toolbars and keybindings won't be able to find them.

Save your global template.

Copy your toolbars

If you have toolbars that you want to move, copy those as well, after
you have copied any macros, styles, or AutoText that the toolbars call.
Again, Styles won't do you much good in a global template.

Save and close your global template. If this is a new template, close
Word and move the global template to your Word Startup folder.

Open a new blank document. Tools =3D> Customize =3D> Toolbars
(1st Tab) and check your custom toolbars. Right-click on the selection
and rename it xxx Old Toolbar. (We are doing this before deleting it.
Want to check if new toolbar works and can't really do that without
changing the name.) Close the Customize dialog box.

Create a new document from your template. File =3D> New... Check to see =
your toolbars and macros function the way you want them to. Type
something in the document and then close it without saving it. You
should be prompted as to whether your want to save the changes made to
MyGlobal.dot. Answer "Yes."

Assuming that your toolbars and macros function properly, you can now
use Tools =3D> Customize (this time customizing Normal.dot) to delete
"Anne's Old Toolbar." Quit Word and save your changes to Normal.dot.

Next time, when you create a toolbar using the Customize command under
the Tools menu, or Tools =3D Macros... to record a macro, check to make
sure that it is being saved in the template that will be using it rather
than in Normal.dot. Likewise, make sure that any changes you make to
that toolbar or macro get saved in the template.

This way, if you pass your template on to someone else, they will have
the benefit of your toolbar and macros. Also, Normal.dot corrupts from
time to time (even without the assistance of a virus). Rebuilding your
customizations can be a real pain.

How to create copy-able customizations to the built-in toolbars and

Organizer will not copy customizations to built-in toolbars and menus,
so you have to work around this limitation. You cannot copy
customizations made directly to these toolbars or menus. The way I have
used is:

I create a shadow toolbar in my global template to hold my
customizations. It has a custom menu for each built-in menu or toolbar
that I customize.

MyFile MyEdit MyView MyFormat, etc.

I use a separate shadow toolbar for the shortcut menus but you could put
them all on one if you wanted to, it depends on how many customizations
you do. I include a custom menu named Chas that has some of my favorite
templates and commands. That menu is one of the main customizations of
my global template and I want to be able to back it up or move it. It
was designed to go on the main menu bar, but if I created it there (as I
did at first) I would not be able to copy it.

I put the customizations on those custom menus on this custom toolbar
first. That means using Customize to add the commands. Then, once I've
added a command to the custom toolbar, I Ctrl-drag it to the built-in.

You can use custom menus as a submenus to hold the deleted items, the
simplest way to do this would be to move the items from the File menu to
the MyFile =3D> Deleted Items submenu and so forth.

This isn't perfect but it makes rebuilding the customizations to the
built-ins a lot less painful because the custom toolbar can be copied to
another template using the organizer.

How to copy/move Userforms:

If you don't know what a userform is, chances are real good that you
don't have any that you have written. It is a VBA construct - a homemade
dialog box or wizard, not a piece of paper that you fill out, or an
online simulation of this. If you have created and are using userforms,
you probably don't need this tutorial and certainly don't need explicit
instructions, so: Within the Visual Basic Editor either drag the
userforms from one project to another or export the form from one
project and import it into another.

Userforms can be very simple or elegantly complex. If you are doing VBA
programming and not using them because you don't know how, take a look
into the tutorials on the MVP website.

How to copy/move Keybindings:

These are the custom key assignments made to macros and commands. I use
Chris Woodman's Add-In ShortCut Organizer, which looks and works like
the regular Organizer except that it deals with keyboard shortcuts. You
can download this from ShortCut Organizer download page.

Copying Customizations not stored in templates

How to copy/move AutoCorrect entries

AutoCorrect entries are stored in *.acl files and in Normal.dot. The
files are language-specific. The best way to do this is to use the macro
you can find at "How can I import and export all my AutoCorrect entries,
so they can be transferred to another machine?" There is a macro
included with Word that is supposed to do this, but it has several bugs
that are fixed in this one available on the MVP website.

How to copy/backup user preferences that are stored in the Registry's
Data Key.

This requires a simple macro, which you can record! Start up Word for a
fresh session and record a macro called "MyUserSettings." The action to
record is opening the Tools =3D> Options dialog box and clicking on the
tab for every page on that box. Then close that dialog and open the
Tools =3D> AutoCorrect dialog and do the same thing - click on each tab
and then close the dialog box. This is based on instructions by Beth
Melton in the article "What exactly does the Data Key in the Registry
store". http://www.mvps.org/word/FAQs/Customization/DataKeySettings.htm

I also include the Customize dialog box and Keyboard button from that
box in this but am unsure that it actually helps. Stop recording. You
now have one method to return to these settings: Just run the macro.
Unfortunately, this won't save all of your user preferences, just a lot
of them!

To save all of them, you can use RegEdit (Start =3D> Run =3D> RegEdit). =
not change anything in the Registry without (1) making a backup, and (2)
having a good idea what you are doing! That is not for the
faint-at-heart! I am suggesting making a specific backup of the Data Key
for Word. The article by Beth Melton explains how to find the Data Key.
If you right-click on it you can export it (make a copy) of your Word
settings. This is a good idea because the Data Key seems to be easily
corrupted. Doing this will not make any changes to the registry itself.

See Template Basics for more on templates (user and workgroup), global
templates and Normal.dot.

See also Assigning Custom Button Faces to Your Toolbar and Menu Buttons.

See Distributing Your Macros to Other Users by Jonathon West, MVP.

We've covered a lot in the last few articles. Next month we'll take a
look at dates in Microsoft Word. If you have a topic you would like to
see covered in one of my columns' please write me at
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.kenyonck.addr.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
~~Tina Clarke, AccessFP - Frontpage Resource Centre

Where=92s the Best Place To Ask for Help?

Before asking your FrontPage question in a list, group, club, or forum
etc., think about using the Help menu. It is at the far right end of the
menus, and from it you can search through an index of all the on-disk
help. You can also press F1 to access it.

You might like to know about the FrontPage Online Help files, which are
duplicated on the Microsoft web here.

Microsoft also has a knowledge base of articles about FrontPage (all
versions) here. http://search.support.microsoft.com/kb/c.asp?ln=3Den-gb

You should also upgrade your help files at Office XP Update: Additional
Help Files http://office.microsoft.com/downloads/2002/ofHelp.aspx

This downloadable file contains the most current Microsoft Office XP
Help files and replaces the existing Help files available in Office XP.

If you are using a screen reader that doesn't work with expandable links
in Microsoft Office XP online Help, you can download alternative Help
with pre-expanded content Office XP Add-in: Expanded Help File

Plus, Office XP Add-in: Microsoft Document Imaging Expanded Help File

If you are using a screen reader that doesn't work with expandable links
in the Microsoft Document Imaging, Microsoft Office XP Small Business,
and/or Microsoft SharePoint Team Services online Help, you can download
alternative Help with pre-expanded content.

If you aren't sure what a specific command or button does, or if you
want to know more about an option in a dialog box, you can get help
through ScreenTips. ScreenTips show information about different elements
on the screen.

To get help about a specific command or button, click =91What's This?=92 =
the Help menu, and then click the element you want information about.

To get help about a dialog box option, click the question mark in the
upper right corner of the dialog box, and then click the option.

Copy examples from Help:

If you see an element in a Microsoft FrontPage Help topic that you'd
like to include on one of your Web pages. For example a form field or a
hover button, you can copy that element from Help and paste it into a
page in Page view. You can then customize the Help example with your own
text, pictures, labels, etc.

In the Help topic window, select the element that you want to copy,
right-click, and then click Copy on the pop up dialog box.

Note:   If the element you want to copy is a non-text element, for
example a table, you may need to begin and end the selection at the text
just before and after the element that you want to copy.

In Page view, open the page to which you want to copy the element from
Help. Position the insertion point where you want to insert the element,
right-click, and then click =91Paste=92 on the pop up dialog box.

What if you want to find more help about FrontPage from a third party?

There are also a number of sites that provide online tutorials
http://tutorials.beginners.co.uk/ http://www.trainingtools.com/

more are listed here. http://accessfp.net/freefrontpagestuff.htm

There are expert sites staffed with volunteers where you can ask a
FrontPage question for free.


Yahoo Experts

AllExperts http://www.allexperts.com/getExpert.asp?Category=3D1558

You can find a listing of Newsletters, Tip lists, E- Lists, Forums,
Discussion forums, Chats, Bulletin Boards, Clubs, Specialist lists and
Magazines, all about FrontPage at: http://accessfp.net/plists.htm

How can you help other people visiting your site with information,
explanations and on the spot help?

When writing your html pages and you find the need to explain an
uncommon or technical word, you might like to use the title tag which
works like the alt tag on pictures and pops up with your explanation

For example:

 <A title=3D"What You See Is What You Get">WYSIWYG</a>

Paste the above code in your html view in the body section, go to
preview and mouseover  =91WYSIWYG=92 and you will see a pop up with the =
=91What You See Is What You Get=92 inside.

You can find more about the title tag here.

The above coding is done with html but you can do something similar with
JavaScript, however please note that not everyone has JavaScript enabled
in one=92s browser.

Visit http://www.bosrup.com/web/overlib/
for some neat JavaScript pop up solutions.

Remember there is usually a solution out there; it=92s just a matter of
knowing where to look and who to ask.
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/
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/hal4.htm
~~Hal Cardon, PC Sleuth


Hello again.  First I want to thank everyone that wrote in about my last
article on System Resources.  Hopefully I didn=92t get too geeky.  As
always if you have any comments about my writing please e-mail me at

This month=92s topic is actually two:
Partitions and Multiple Booting your computer.

Unfortunately these topics are pretty geeky (sorry), so please bear with
me, hopefully by the end of the article it should make some sense.

Creating a multiple boot computer can cause data loss, so if you decide
to try this make sure that you have a good back-up and test it to make
sure that you can recover.  I used to work at a motorcycle shop where we
has a sign on the wall that said "If you have a $10 head, wear a $10
helmet".  Well the same holds true for your data. If it is important to
you, BACK IT UP.

In order to understand Multiple Boot systems, you will need to
understand Partitions, and Hard Drive geometry.

Geek Terms

Let=92s start by defining some terms.


- A partition is a section of your drive. You may not realize it, but
all hard drives have partitions.  If your hard drive has a single
partition then you see that as drive C in Windows or DOS.  Partitions
are created with partitioning software like fdisk for Windows or DOS.
You can use fdisk to create more than one disk on a single hard drive.
There are certain rules for Partitions:

Partition rules
- You can have no more than 4 partitions on a hard drive. However one
can be an extended partition and it can contain multiple logical drives.

- To be bootable (by DOS, Windows and some Operating Systems (OSes),
partitions must be primary, active and the first sector must be below
the 1024 cylinder limit (8 GB).  For DOS in particular the boot code
MUST reside beneath a 2GB barrier.

- DOS and Windows 9.X should have only one visible primary partition, or
data corruption may occur.


Before a partition is usable it must be formatted.  When you format a
partition, a File Allocation Table (FAT) is created.  The FAT maps out
the available space in the partition into clusters so that when you
write data to the hard drive it can found again.


Hard Drives are constructed out of platters; the platters are round and
look like a stack of pancakes with a little gap in between them.  We
define the size of a hard drive in Cylinders, Heads and Sectors.  A
track is the section of a platter that can be read with out moving the
head.  When we look at all the heads, a cylinder is a collection of all
the tracks on the platters that can be read with out moving the heads.
It may help you to think of Cylinders like this:  Take our stack of
pancakes (platters) from above and cut a circle out of the middle of
them.  Now cut a ring off the outside.  If you remove the inner circle
and the outer ring from the stack, what remains is a cylinder with each
pancake ring being a track.


Sectors are a subdivision of tracks.  They are smallest size unit that
can be written to a hard drive.


Clusters are created by formatting a partition, they are sized by the OS
and the type of FAT used.  Clusters are a collection of sectors on the
hard drive.  Each cluster can only contain one file or portion of a
file.  Each cluster is represented by an entry in the FAT. The size of
each cluster is determined by the OS and type of FAT.


Multiple Boot refers to computer that can boot to more than one OS, for
example my main desktop computer can boot in to Windows 98, Windows XP,
Windows 2000 Pro, Linux Mandrake 8.0 and BEOS 5. In a multiple boor
scenario you normally choose the OS to boot when you turn on your


Run More than one Operating System

A multiple boot computer is great way to try out an OS without having to
make a long term commitment to a new OS.  For example one of the reasons
I multiple boot my computer is to give me the ability to try out the
beta versions of Windows XP.  Using a multiple booting system I can try
out beta OS on my main desktop safely, with out putting my important
data at risk.

Some other OSes you might want to try.

- Other versions of Windows ie: Windows 9.5, 98, NT 4.0, XP
- Linux
- Unix


There several things you need to know before you create a multiple boot

1024 Cylinder Limit

Several OS have a requirement that either all or some their bootable
partition reside below the 1024 cylinder barrier.  The 1024 cylinder
barrier equates to 8 GB.  OSes of this type include all versions of

Primary Partitions

Most OS must reside on a Primary Active Partition to be bootable.


Partitioning Tools

Before I talk about some specific partition managers, I have to warn you
that playing around with the partition table of your hard drive may
cause you to lose everything on your hard drive.  So if your data is
important, BACK IT UP.

Partition Managers are software utilities that are used to manage your
partitions.  Before you try and create a multiple boot system, create a
bootable diskette that will give you access to your partitioning tool.
Make sure that you TEST IT!


Fdisk is a command line based partitioning tool that is included with
DOS and Windows, there are also versions of fdisk included with many
Linux distributions.  Fdisk, while very functional is a very bare bones
utility, it often can=92t recognize partitions that were created by a
different partitioning tool, also repartitioning your hard drive with
fdisk WILL ERASE your data.

Partition Magic

Partition Magic is GUI based partition manager that allows you create,
resize, copy and move partitions.  It also allows you to convert
partitions between different formats.  In most cases you can do all of
these things without losing any data.  You have to buy Partition Magic.
In my opinion Partition Magic is the best bet of all partitioning tools.
It also includes the boot manager Boot Magic.

Ranish Partition Manager http://www.users.intercom.com/~ranish/part/

Ranish Partition Manager is a free utility to help you manage your
partitions. It allows you to:

Save and restore MBR,
Create and delete partitions,
View hard disks' IDE information,
Format and resize FAT-16 and FAT-32 file systems.

It includes Advance Boot Manager.

Partition Commander

Partition Commander is GUI based partition manager that allows you to
create, resize copy and move partitions.  Like Partition Magic you have
to buy Partition Commander, it also includes the boot manager System

Boot Managers

Boot Managers are software that provide an easy way to choose which
operating system you want to run.  The can often hide unused primary
partition(s) and set a partition as Active.

Windows NT

The boot manager included with Windows NT, 2000 or XP.  It is a very
powerful tool but can be tricky to configure. It must be booted from a
partition inside the 1024 cylinder limit.

System Commander

System Commander is my favorite boot manager, it has features that the
others don=92t and is fairly straight forward to configure.  You have to
purchase System Commander.

Boot Magic http://www.powerquest.com/partitionmagic/pm7details.html

It is the boot manager included with Partition Magic.  Boot Magic is
very easy to use, but isn=92t as configurable as System Commander.

Advanced Boot Manager

Advanced Boot Manager is included with the free program Ranish Partition


Lilo is the LInux LOader.  It can be used to load other OSes as well.  I
t can tricky to configure properly.

How to create a multiple boot computer

There are a number of ways to create a multiple boot computer, I will
cover 2 common scenarios, but they can be expanded and combined to
create the others.


One Primary Partition

It is possible to create multiple boot computers with only one primary
partition.  That partition must contain your boot manager.  Since almost
all OS can read and write to FAT16 your primary partition is usually FAT
and therefore limited to 2 gigabytes in size.  You can do this having
one primary partition and at least one other partition (which can be on
another drive).  What you do is load Windows 9.x or DOS on your primary
partition then insert the set-up disk for a Windows NT based OS (NT,
2000, XP) and run set-up but have it install the NT based OS to a
partition other than C:.

The limitation to this method is if you want to remove one OS, you will
still be booting to FAT partition, If that partition does not contain an
OS it may get confusing.  For example in DOS/Windows nomenclature, your
autoexec.bat will be on drive C: while Windows is located on drive D:\.
It must be noted that Microsoft no longer supports more than one OS on a
single partition.

You need to be careful in this scenario, some programs default to
installing to C:\Program Files, so if you remove the Windows 9.X OS you
will loose access to those programs from the other OS.

Multiple Primary Partitions

This is my preferred method of running more than one OS on a system.
What I do is create 3 primary partitions on a hard drive, with each
partition having a presence below the 1024 cylinder limit. The
advantages to this method are:

Each OS is completely hidden from the other OSes on the computer. I can
use a logical drive on an extended partition as a programs drive that
can hold programs that are accessible to other OSes.

I use my partitioning tool to unhide the first primary partition and set
it as active and hide the other 2 primary partitions.

I then install the oldest OS on the first primary partition; along with
my Boot Manager (I keep the first partition=92s size below 2 GB if it =
contain DOS or Windows 95 original).

I then use my partitioning tool to hide the first primary partition and
set the second primary partition as active.

Now I load the second OS.  I usually make this Partition just under 6

I again use my partitioning tool to hide the First and second Primary
Partitions and unhide the third primary and set it active.  Remember
that the third primary partition MUST have enough of it existing (large
enough section to contain the boot files) below the 1024 cylinder limit
in order to be bootable for most OSes.

Now I load my third OS.

After loading the three primary OSes, I use my partitioning tool again
to hide the third primary partition and set the first primary partition
as active and unhidden.

I boot to the first OSes and reload my boot manager and configure it to
boot to my 3 OSes.

Now I load my programs under the appropriate OSes on to drive D:.

Remember that each program you wish to use with an operating system must
installed under that Operating system.  You can however install to the
same drive and directory to save space.


I prefer the Multiple Primary Partition method for multiple booting my
systems.  I find that if one OS goes down, I don=92t lose my other OSes
and therefore I can still use my computer.

My favorite partition manager is Partition Magic; I find it safe and
easy to use.

My favorite boot manager is System Commander; I find to be the most
powerful, it makes it easy to boot from more than one hard drive.

I know this topic was very geeky.  Hopefully it helped you understand
some the issues surrounding multiple booting your computer. I know that
it got fairly deep, but that is what the topic required. Unfortunately,
creating a multiple boot computer is not a trivial undertaking.  I
recommend that you read the documentation for any OS you wish to use,
and for the tools that you choose before you start. Please back-up your
data before you start, it is very easy to make a mistake and lose
everything on your hard drive.

As always please let me know (abcomputers@xxxxxxxxxxxx) if you find this
article too hard or not in-depth enough.

See you next month!
Hal Cardona
PC Sleuth
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.
~~Jack Teems, Neat Net Tricks


When things slow down while you are surfing the Net, you may be tempted
to blame your dinosaur computer, your Internet service provider, a full
moon, or all of the above.  Likely, none of the above is the correct
answer.  Your connection on the Internet follows a number of points, or
hops, in going from your computer to the desired site.  The distance
usually involves several thousand miles and a dozen or more systems, any
one of which may malfunction.

Before you are quick to affix blame, use a handy feature in your Windows
operating system to find a problem.  It's called "tracert=94 and you
simply enter that word followed by the Web site address (URL) either in
the box created when you click on Start and Run; or, go to Start,
Programs, MS-DOS Prompt, and enter this information immediately
following the prompt that is displayed.  The second technique is
preferred so that the display window will remain on your screen until
you click it off.

If, for example, I am having difficulty in getting to my Web site, I can
enter "tracert neatnettricks.com=94 (without the quotation marks) and =
13 or so hops will be displayed showing the systems through which my
transmission has gone to reach its destination.  If there's a breakdown
or a slowdown in this path, this will be shown.

This sounds a lot more complicated than it really is and if you would
like a nice graphical display instead, consider downloading Neoworx

or VisualRoute. http://www.visualware.com/visualroute/index.html

These interfaces have much more going for them than the built-in tracert
utility. While they all allow you to test your Internet connection and
identify whose system may be the culprit, Neoworx and VisualRoute also
enable you to investigate domains and identify Internet service
providers.  These are valuable tools in contacting the right people if
you wish to hunt down and complain about spammers.

Several Internet sites such as The Internet Weather Report sample
conditions and present a geographic map showing "lag time"=94

This is a term to denote how long it takes for a packet of data (in
other words, your transmission) to get to an Internet node and return to
your computer, much like shouting from a cliff and waiting to hear an
echo. If the lag is too long and the echo never returns or is extremely
slow in returning, you can expect a problem in your communication.

Remember, since things are measured in nanoseconds on the Internet, any
delay seems like an eternity. When this happens, turn in early and get a
good night=92s rest. Maybe it's the moon after all.
Jack Teems' Neat Net Tricks is available in three flavors:
You can subscribe to the free twice-monthly ezine by sending a blank
email or click the subscribe button on the NNT Web site.  If that=92s =
enough, you can subscribe to a special edition, Neat Net Tricks PLUS,
for just $10 a year at the NNT Web site.  And, if you want every Neat
Net Trick ever published on diskette 4 times a year, the ArchivesExpress
is as little as $20 (details are also at the NNT Web site.)
http://www.NeatNetTricks.com .
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/james4.htm
~~James La Borde


Well Folks, it certainly is nice to see all of you again.  In case you
missed the previous articles, our trek along the Access database
creation highway has taken us through preparation

and into the realm of the various data types available to us.

We are going to continue this adventure with Populating the Database.

Now you have all your planning done, and your tables are built,
normalized and ready to go.  You are probably asking yourself "What
Next?"  I answer, "Populate the database!" In Database terms, that
merely means putting the data in or data entry.  We will discuss several
methods of populating our database including datasheet entry, forms, and
importing and linking tables.

Adhering to the K.I.S.S. Principle

The simplest method of entering data in the database, for a beginner, is
by using the datasheet (see figure 1).  The datasheet is a simple
representation of the table with one row for each record.

The datasheet has several advantages and disadvantages to its use. Some
of the advantages include the simplification of data entry by
eliminating unnecessary graphics, the ability of the user to see all of
the data; (this can be a disadvantage as well.)  A simple tab through of
all the fields in the table.

While there are some advantages, the datasheet is generally not accepted
as a viable means of data entry in a user database.  The main
disadvantage of the datasheet is the fact that the creator does not have
as much control over what the user can do or see.  Another disadvantage
lies in the inability to use some of Access=92s more advanced features.

To enter data using the datasheet you merely highlight the table in your
database window and click Open.  This will bring you up in the datasheet

(see online version for Figure 1)

Steering the User

While the datasheet is quite simple, the Form can be quite complex. The
form gives the developer a great deal of control over the user=92s =
to enter and view data.  To see the difference between a datasheet and a
view, take another look at Figure 1, and then look at the same data in
Figure 2.  Both of these are based on the same table. The form in Figure
2 also has a sub form.  We will touch briefly on these a little later.
By using the form=92s greater variety of controls, the developer can =
the user into only the actions that are desired.

(see online version for Figure 2)

Going to the forms tab and clicking the New button creates the form. You
are given the opportunity to select the table you choose to make a form
for and several methods of creating the form. We will be discussing two
of these, Design View and the Form Wizard.

The Form Wizard is a simple tool that will take the guesswork out of
creating your form.  I highly recommend the Form Wizard when you are
first starting out.  It is a great tool to learn about the basics of
creating a form.  It will automatically create your form with the fields
that you designate.  You can then go into the newly created form and add
additional elements to it.

Now that you have your form created, you are ready to set your form and
field properties.  This is where you steer the user.  We will briefly
discuss some of the major elements of form control here.  Next month=92s
issue will cover forms in greater detail.  For our purposes here, we
will concentrate on the Data tab of the Form properties.

The data tab (See Figure 3) is where you control what the user is able
to see as he/she enters new data into the table.  A few of the key
controls are Allow Edits, Allow Deletions, and Data Entry.  Allow Edits
does just what it sounds like it does.  If set to no, it will not allow
the user to edit data once it has been entered.  Allow Deletions, again,
is exactly what it sounds like.  If set to yes, you are allowing the
user to delete a record.

Finally Data Entry, this property is not quite as obvious as it sounds.
However, it can be the most restrictive of these properties.  By setting
Data Entry to yes, the form will open to a new record only.  Once a user
leaves a record, they can no longer view it.  This can be very useful
when the user is dealing with confidential data, such as a social
security card number.  They can enter it, do what they need on the
current form, then after they leave the form, the data is secured from
their view.

There are numerous other property controls on a form that can be used to
steer the user in a particular direction, from tab settings and stops to
input masks.  All of which guide the user into entering data the way the
developer wants them to.  We will cover each of these in greater detail
in next month=92s issue.

(see online version for Figure 3)

Another little treat of using forms is the sub-form.  A sub-form is
another form that is made part of your form.  If you look back at Figure
2, there is a sub-form on it.  Basically the sub-form is a subset of
data from another table that matches a part of your current form.  In
this case, it is all the products within the category.  With this one
form, you can view all of your categories and the products within each
category.  Sub-forms will be addressed in a future article.

"My Data already exists in a database, why should I Re-enter it?"

If you already have access to your data in another database there is no
reason to duplicate your efforts.  You can get that data into your
database in one of two ways.  If you want the complete set of data and
it will not change, you can simply import the data, or if the data is
likely to change, (or is simply too large for your database) you can
link to the data.

The process for importing or linking are much the same, the only
difference being where the data will be stored.  As with most Microsoft
products, there are conversion wizards to allow you access to various
forms of data.  In the import selection box, you can choose another
Microsoft Access Database, Microsoft Excel, Text Files, HTML Files,
Dbase versions 3, 4, and 5, Microsoft FoxPro databases and ODBC
databases which opens up a whole new set of databases.

The process for either is quite simple, provided you are selecting any
option other than the ODBC database.  Merely click file, Get External
Data, then select whether you want to Import or Link.  Next select your
input type and navigate to its location.  Select what you want to import
and a wizard will walk you through the rest.

ODBC (Open DataBase Connectivity) databases require a little extra
preparation to get to their data.  The advantage of doing this extra
work is that you can link to a much larger database.  ODBC databases
include Microsoft SQL Server, Oracle, Sybase SQL Anywhere, and
PostgresSQL.  When you select ODBC for a database type, you will get a
new window asking you to select the ODBC connection you wish to use.
You may also set up a new connection at this point.  Let=92s use an SQL
database as an example.  In our example, we want to connect to the
Products table in the Northwinds database on the Sales server.  The
first selection you will need to make is whether you want this
connection to be for this machine or for this particular file.  Which
you choose will depend on how often you will need to make this
connection. For our purposes we will select Machine and click on that
Tab.  After clicking New, we are presented with another option.  Do we
want this to be a User or System connection?  Again this will depend on
your situation.  Will multiple users be using this application from this
machine? Select system.  If only one use will be using this particular
application but others use the machine, select User.  This will provide
an extra layer of security for your application, as even if someone were
to open it, they would be unable to access the data.

We have chosen system, as we will have several users for our example.
Now you are presented an option of what kind of driver you need to use,
this will be selected based upon your data source.  In our case, we have
a Microsoft SQL Server database so we will select that.  If you do not
see the connection you need, do not fear, not all are loaded with the
default install of Access and more are available from Microsoft.  The
next page to come up is a summary showing you what you have selected.
If you are following along, you should see:

System Data Source

Driver:  SQL Server

If this is correct, click Finish.  You are not actually finished; this
will bring you into a new wizard to set the properties of your SQL
Server connection. The name of your Data Source will play a part if you
choose to use it again.  Name it appropriately so that you know what it
actually is.  The description field is to help you in finding it again.
The Server field is critical; you must enter the name of the server
exactly as it appears in the network.  In our example, the server is
named Sales, so we enter that and click next.  This is where the
authentication is set up.  Do you want to use the network authentication
(if you are on an NT
network) or do you want to use SQL authentication.  These setting depend
on what the SQL database is set up to handle. This is where you want to
check the box marked change to default database and enter your database
name, in this case, we will enter Northwinds. Click Next. The one thing
to watch for here, is one of the default settings. Use ANSI nulls and
paddings can cause corruption in an SQL database, uncheck it!  The rest
of the settings here depend largely on your SQL database but most are
acceptable as defaults as are those on the next page.  Click Next and
then after perusing your settings on that page, click finish.  You will
now be taken to a Test Your Connection screen.  Click on the Test
Connection and make sure that you get a Test Completed Successfully
message. Then click close.  We are now ready to select our table.  They
will be listed in a text box with a check box beside them.  Select the
box next to the tables you want, in this case, Products.  Before
clicking finish, decide whether you want to save the password.  If you
do not check this box, the password you entered in the ODBC connection
must be entered by the user when they enter this table.  Click Import,
then close.  You now have your table linked.

Any changes made to that table are now made on the SQL Server. The user
will also be able to see any changes that have been made in the table on
the server.

"What about Excel?"

Excel imports are pretty much the same as the procedure for importing
data from another database.  It is actually one of the options
available. Here are a couple of methods to keep you on the right track.

As my wife often reminds me, it isn=92t just importing the data, it=92s =
quality of the data.  When importing from Excel it is imperative that
your data be in good shape.  Clean data is the key to a successfully
importing data from Excel to Access.

The first method is by far the simplest, a simple copy and paste of your
data.  Open both Excel and Access, then highlight and copy your data in
Excel, switch to Access and click on the Tables tab, then click paste.
It will only ask you one question; "Does your first row contain field
names?"  A Yes response uses the first row as your field names and a No
response gives you a simple, but unhelpful Field1, Field2, etc.

The second method is the one described above in the Importing section.
Simply click, File, Get External Data, Import and then on the pull down
list at the bottom for files of type, change it to Microsoft Excel.
This will start a wizard that will assist you in importing your Excel
spreadsheet. The first page will ask you whether you want to import
worksheets or ranges and show you a sample of your data to be imported
as well. Click next and you will be taken to another question, does your
first row contain field names for your table?  Next is the option of
importing into a new table (highly recommended) or into an existing
table.  Until you have done this numerous times, I highly recommend
importing into a new table then moving it into your existing table after
you ensure that you have a good import.  Next in the wizard is the field
options page.  This lets you set up to three options on each field,
first the field name, second is the data type, and last is whether or
not to index the column.  You can also elect to skip an entire column if
necessary.  If you have calculated fields in your Excel spreadsheet and
are importing all your component fields it is recommended that you skip
the calculated field.  Access can do the calculations on the fly.  It
also allows you to change the fields without worrying about having to
change the result manually.  Next is the primary key selection.  After
clicking next all that is required is a table name to import to.  Click
Finish and your data is in.  Access will produce an Import Errors table
so that you know if data failed to import, what it was and why.

Still yet another method and a slightly automated one at that is to use
the macro command Transfer Spreadsheet.  While it is not quite as
detailed as the Import Wizard, it does automate the tasks for repeated
imports.  The macro requires six pieces of data.  First is the transfer
type, you can import, export or link.  Next is the database type.  You
simply select your spreadsheet format from a pull-down list.  Next is
the table name that you would like it to import into.  This is followed
by the File Name, unless your file is in the same directory, give the
full path.

Then the Has Field Names option is needed, simply select yes or no.
Finally you will need to input your range.  You have three options in
this field.  Leave it blank and you get the entire spreadsheet or you
can input your range as either a range of cells or a named range.  After
saving your macro you are ready to go.

As you can see you have numerous options for getting the data into your
database.  Direct Input requires either the Datasheet or a form,
depending on your users skill level and the level of security you want
on it.  If the data already exists, you can opt to import or link to it,
largely depending on how dynamic the data is.  And of course, you can
get your data from an Excel spreadsheet.

Stay tuned in coming months for:


Forms - an in depth look at creating various types of forms to guide
your user through your database.


Queries - What you can do with your data once you have it in the


Reports - Presenting your data in an end user friendly format.

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 might make this
clearer for you. http://www.personal-computer-tutor.com/parker4.htm

~~Parker Renaud, IT Manager, Colliers Keenan, Inc.


If your kindergarten report card said "Doesn=92t share well with =
its time to get over it! To increase your efficiency with Outlook, you
need learn to share information. Outlook 2000, running on Microsoft
Exchange Server, offers several ways to share information with others.
You can set access "permissions" for the default folders through folder
properties, share access by creating "delegates" in the Tools>Options
menu, or create public folders and set access permissions on them. Today
we will talk about setting access permissions on the default folders.

Why would you want to share information with someone?

There are many reasons. Maybe you would like to have someone check your
e-mail when you are away from the office and contact you if something
important comes in. Or you might need the information contained in one
of your contacts while traveling, or want to know when you sent a
particular e-mail.

To share access to your folders:

1.  Display your folder list and right click on the folder you wish to
share.  Click Properties, select the Permissions tab, and the Properties
box will appear.

2.  Click on Add and the Add Users dialog box will be displayed.

Only the users with accounts on the same exchange server will be listed.
You cannot share information with people outside your network using this

3.  Highlight the name of each of the users with which you want to share
and click add. You will notice that, though this will add the users to
the list, their role is "None". (A role simply signifies the level of

4.  To assign a role to a user, highlight the name and click the button
next to "Roles" to open the "Roles" drop down list. (You can also click
the option button next to each permission to set them individually.) If
you want multiple users to have the same Role, you can select all of
those users at one time, then select the desired role.

5.  There are nine available Roles, plus "Custom". They range from None,
which only makes the folder visible, all the way to Owner, which gives
other users the same rights you have as the folder owner.

There are some limitations to the use of permissions. You can share only
six of the default Outlook folders: Calendar, Contacts, Inbox, Journal,
Notes, and Tasks.

Now that someone has permission to access your folders, how do they do
it? It is very easy in Outlook 2000:

1.  Click on File>Open>Other Users Folder.

2.  Select the name of the "other person" and the folder to which you
have access.

3.  The folder will then open in a new window.

4.  If you have not been given access to a folder, a message will
appear, telling you the folder could not be found.  In other words,
Outlook will neither confirm nor deny the existence of the folder!
That=92s all there is to it.

Next month I will talk about creating delegates to access your Outlook
Parker Renaud is the one-man IT department at Colliers Keenan where he
manages 90 PCs on 5 servers.
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/chad4.htm
Chad K. Welch

Part 2

Last month we learned a few steps to clean up the code that the macro
recorder records. http://personal-computer-tutor.com/chad3.htm

As you may recall, the recorder will record all steps that you make
regardless of whether or not it is a necessary step.  For example, begin
recording a macro in Excel.  Select cell C4, type =9145=92 and press =
Stop the recorder and select Tools>Macro>Macros.

In the dialog box that opens highlight the macro you just recorded and
click on Edit.

The following lines of code are recorded:


ActiveCell.FormulaR1C1 =3D "45"


As we learned last month, those three lines can be reduced to:

Range(=93C4=94) =3D 45

VBA does not need to select the cells to place a value in it.  The
general rule of thumb is:

If the first line contains Select or Activate and the following line
contains Selection or Active___, the lines can be rewritten on one line.

There are a couple of exceptions to these rules.  Let=92s record another
macro to see an exception.  Once again in Excel start the macro
recorder. Select cells D8:F11.  Press the copy icon on the toolbar.

Select cell A1 and press the paste icon on the toolbar.   Stop the
macro, and go into the VBE again to view the code.  This is what was





The first two lines contain a Select and a Selection.  Those lines can
be consolidated to:


The last two lines also contain a Select and an Active___.  However,
consolidating these lines to Range(=93A1=94).Paste would create a =
error.  The reason is that the selection is a range, but the Paste
method is used on a sheet object.

WHAT!?  I know; that was confusing.  Let me rephrase that and leave out
the Geekese.

Range(=93A1=94).Select selects a cell, while ActiveSheet.Paste is =
an action (paste) to a worksheet.

Because the Select and Active___ refer to different components of a
workbook, they cannot be consolidated.  Let=92s rephrase our rule of

If the first line contains Select or Activate and the following line
contains Selection or Active___ and refer to the same object, the lines
can be rewritten on one line.

Good Luck and Happy Coding!
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/corey4.htm
Corey Seaton


(I'm sorry but I don't have any experience with Macintosh networking,
and Linux networking is completely dependent on your distribution=85 =
free to email me for general tips, but for anything complex you'll need
to ask someone with specific experience)

Now that you've installed the hardware, you need to configure Windows to
recognize and use the network card properly. This means Windows needs a
"device driver" for the card, which is basically a piece of software
that tells Windows how to control your hardware (that is, how to
"control" your "device", hence the name). With any modern network card
this should be simple - when you start up your computer, Windows should
recognize that there's new hardware and look for drivers for it. Insert
the driver disk that came with your card (it did come with one, right?!)
and install the device drivers. If there's anything unusual about your
card, e.g. the drivers are in an obscure directory on the disk; the card
will (hopefully) have come with instructions on how to install the

If your card didn't come with drivers, the chances are that it will be
compatible with an older card that Windows has device drivers for. Let
Windows "search for the best driver for this device", and it'll probably
come up with something like "RealTek=85" or "3Com=85=94 Whatever it =
says, just
try it out - it will probably work!

If Windows didn't display any message about detecting new hardware,
don't worry. You just need to go into the Windows Control Panel and
choose "Add New Hardware" and follow the prompts.

Let Windows search for new hardware. With any luck it should now find
your card and ask you for a driver disk - if you have one, use it,
otherwise let Windows use whatever driver it comes up with (as above).
If Windows still can't find your card, you're probably in trouble - the
card may be faulty. Ask the vendor for help.

Checking that the card is there: Now go into Windows Control Panel and
choose "System". In Windows 95/98/ME, go to the "Device Manager" tab; in
Windows 2000, go to the "Hardware" tab and click on "Device Manager"=94
Look for the "Network adapters" section. In this section you should find
the network card that you just installed (and on the computer that's
acting as the server you should also see the network card that came with
the cable modem). Make sure the card is working properly - click on the
card and then click on the "properties" button. Windows should tell you
"this device is working properly". If not, you'll need to work out why
not - there may be a hardware conflict, or you may need to restart your
computer, or you may be using the wrong device driver, or the card may
be faulty. In any case, you need to have the card working properly (i.e.
getting the message "this device is working properly") before you
proceed to the next step.

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?
Kathleen Anderson, Spider Web Woman Designs


You keep hearing this phrase more often these days=96 More and more web
sites you visit even have an =91accessibility policy=92 link on their =
or a graphic.

What do they mean? Accessibility? Who (or what) is Bobby?

Web site accessibility means making web sites accessible to persons with
disabilities.  This month=92s article focuses on three types of visitors
to your site and the problems they might encounter.

People who cannot see will be unable to use the graphics or colors on
your site for navigation. To experience this for yourself, launch your
browser (my examples will use IE 5), and go to http://www.abcnews.com
and take a look at their use of graphics, especially the ones that are

Now, with the page still loaded, choose Tools | Internet Options |
Advanced in the Multimedia section, uncheck the "Show pictures" box and
click Apply. Reload the ABC News page in your browser, and notice that
the graphics are gone - in their place are boxes with the words "Click
here" (or worse, no words at all) in them. "Click here". Why? What=92s
going to happen when I do that? There=92s nothing there to let me know
where you=92re going to take me when I click that link. What if it takes
me to a page that=92s going to download something to my computer, or
worse, to a site that I shouldn=92t be going to while I=92m at work?  =
should be something a bit more descriptive, don=92t you think?

You might be interested in knowing that another group of people for whom
this is an issue are people using low-end computers, with slow or
pay-per-minute connections.  They turn off the images in their browser
to make web pages load faster.

OK, you can turn the pictures back on now.

People who don=92t use a mouse will most likely be using only their
keyboard for navigating around your site. Bring up your favorite site in
your browser and then put away your mouse (don=92t disconnect it - just
move it or put it on the floor). Now using only the Tab key, move around
the page until you find a link you want to try out, and hit the Enter
(Hint: Shift + Tab will let you tab in reverse, back towards the top of
page.) One thing to look out for is the =91tabbing order=92 of the links =
the page. Do they flow in some kind of logical order or are they all
over the place? With no logical order, getting to a specific link is
going to be very frustrating and time-consuming for someone who can=92t
just =91point and click=92.

Something else you might want to try sometime is going to your favorite
online shopping site, and see how well you can use the online order
forms with just your keyboard. Some of those forms with dropdown boxes
and radio buttons can be quite tricky, and sometime impossible, to use
correctly without a mouse.

Someone with a hearing impairment is going to have a problem with a lot
of the multimedia content being delivered over the web today. As an
example, pay a visit to another popular news web site
http://www.msnbc.com and choose one of their Video or Live Video links.
But first, turn off your computer=92s speakers. Do you have any idea =
that newscaster is saying?  It sure would make more sense to you if the
news broadcast was close-captioned, wouldn=92t it? They do it TV - why =
on the web?

OK - who is Bobby? Bobby is a free service provided by the Center for
Applied Special Technology (CAST) to help Web page authors identify and
repair significant barriers to access by individuals with disabilities.
You can run Bobby against a single page on your site (or someone =
by typing in the URL on this page. http://www.cast.org/bobby/

Or, you can download Bobby and run it on your own computer against your
entire site (or someone else=92s). Bobby checks your page for
accessibility, using the Web Content Accessibility Guidelines at the
W3C: http://www.w3.org/TR/WCAG10/

If your site passes the Bobby test, you are entitled to place the Bobby
logo on your page to show you that you took the time and care to make
your site accessible to persons with disabilities.

Next month we=92ll run a few web pages through Bobby and discuss the
problems we might find.
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
******************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!
~~ Vic Ferri, Windows Tips & Tricks


(These tips were tested on Windows 9x and\or NT
WARNING!  Altering your Registry can have devastating effects. If you do
not know how to backup your registry, go here.

If you do not know anything about the Registry, go here.

Linda's Computer Stop and Vic Ferri are NOT responsible for your
computer....YOU are.)

Regedit Command Line Options

Here are some of the command line options, along with examples for each,
that can be used with regedit.exe in native DOS or in a batch file. Note
that some of these options may not apply to all Windows operating

The syntax to follow is:
regedit.exe [options] [filename]

For example:  regedit.exe /s myfile.reg

Using this option(as in the example above) imports the reg file without
any confirmation. It hides the dialog box stating that your file has
been successfuly imported into the registry.

This option is used to export  the registry or part of it to a file.
example: regedit.exe /e myfile.reg HKEY_LOCAL_MACHINE\

This would export the entire Software key to myfile.reg.

Note that it doesn't have to be a reg file you export to - it can be a
text or document file, as well.

/L:system  /R:user
This is to specify the location of the system.dat and user.dat files to

regedit /l:c:\windows\system.dat /r:c:\windows\user.dat /e
c:\windows\newreg.reg This would be used in native dos to export the
entire contents of system.dat and user.dat to newreg.dat

This stands for create

regedit /l:c:\windows\system.dat /r:c:\windows\user.dat /c

This would create a new registry from the contents of
"c:\windows\newreg.reg"and is normally used in conjunction with the
previous example. Note - your current system.dat and user.dat are
destroyed during this process. New dat files are built from the contents
of newreg.reg

This is to specify a key to delete and is available only in Win98\Me


regedit /l:c:\windows\system.dat /r:c:\windows\user.dat


Extensions - Forcing a Never Show

Windows uses a special flag to make sure that file extensions they
really don't want you to see aren't displayed, even when you have your
options set to show all extensions. They do this by adding a REG_SZ
value to the root of the file extension. This example is straight from
the registry, showing the flag cloaking SHS - Shell Scraps - extensions:


The "NeverShowExt" will cloak the extension type - no matter what


Passwords - Disallowing Local

If you use Windows 9x on a network, and you don't want to bother with
keeping two passwords - one for the network, and one for Windows, you
can disallow local passwords by setting the registry with this entry:

 \CurrentVersion\Policies\Network "HideSharePwds"=3Dhex:01,00,00,00


Importing Reg Files without Confirmation Notice

If you need to write a lot of information into the registry, and you
don't want to script it out , you can use REGEDIT with a /S switch
(followed by the name of your file) to load a registry file into the
registry "quietly" (no external notifications).

Example:  regedit /s myfile.reg
You can run the command in  the Run box, batch file or right at the DOS


Startup Sequence

You can start various applications or events at controlled time in
Windows, by dictating when the 32-bit process should be activated. Here
is the areas in which you should assign tasks, based on when you want
them to start:

CurrentVersion\RunService(Once) - As soon as Windows enters 32-bit mode,
these applications/services are started - these are running prior to the
logon script, or logon box

\CurrentVersion\Run(Once) - run after a user logs on, after the logon
script finishes, but before the desktop is fully loaded in.

\CurrentVersion\Run(Once) - once the logon script is finished, and
Windows has loaded the desktop STARTUP folder from the Start Menu - last
place Windows starts programs from


Internet Explorer Restrictions

Using the Windows registry, there are a number of restrictions one can
make on the operation of Microsoft Internet Explorer.  The restrictions
below were tested on IE 5 but should work with other versions as well.

NoBrowserClose : Disable the option of closing Internet Explorer.
NoBrowserContextMenu : Disable right-click context menu.
NoBrowserOptions : Disable the Tools / Internet Options menu.
NoBrowserSaveAs : Disable the ability to Save As. NoFavorites : Disable
the Favorites. NoFileNew : Disable the File / New command. NoFileOpen :
Disable the File / Open command. NoFindFiles : Disable the Find Files
command. NoSelectDownloadDir : Disable the option of selecting a
download directory. NoTheaterMode : Disable the Full Screen view option.

  Launch regedit and go to the following key:


Hide Display of Drives in My Computer

If for whatever reason you want or need to hide the drives shown in My
Computer, here's how to do it. This will disable the display of both
local and networked drives in My Computer.

Click Start>Run, type in regedit and click Ok, to launch the registry.
Go to this key: HKEY_CURRENT_USER\Software\Microsoft\Windows
In the right pane for the Explorer key, create a new DWORD value by
right clicking in a blank area and choosing New>Dword Value. Name it
NoDrives. Now double click it and enter a Hexadecimal  data value of
3FFFFFF And that's it. Exit the registry and press F5 to refresh. Open
up My Computer - all your drives should now be invisible. To enable
their display again,Computer, simply delete the DWORD value OR change it
to 0.

You can automate the hiding and display of drives with two simple reg
files as follows:   To hide drives:   REGEDIT4
To show drives:   REGEDIT4   [HKEY_CURRENT_USER\
Software\Microsoft\Windows\ CurrentVersion \Policies\Explorer]


Better DVD playing on slower computers - Win 9x- ME

With DVD,s  even a 450 mhz processor is considered on the slow side for
playing DVD's smoothly without dropped frames, from your DVDROM drive.
With that in mind, here's a reg hack that should greatly help boost
performance of your DVD's.

Launch Regedit and go to this key:

HKEY_LOCAL_MACHINE\System\CurrentControlSet\ Control\ FileSystem\CDFS.
In the right hand pane you should notice the following three values with
the corresponding default data values:

CacheSize =3D 0x0000026b (619)
Prefetch =3D 0x000000e4 (228)
PrefetchTail =3D 0x00000080 (128)

Double click each one of the above values and edit the data so it reads
as follows.

CacheSize =3D 0x00000800 (2048)
Prefetch =3D 0x00000800 (2048)
PrefetchTail =3D 0x00000200 (512)

Reboot, and then try playing a DVD.   Note -  it's assumed you know
how to enter the above values.
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.
******************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.

You might be interested in subscribing to this free, 24-hour-a-day email
tech list where you can submit any questions you may have about computer
hardware & software.  You can request fixes for specific problems you're
having with your system 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.  Here's just
one of the tips you'll learn.


~~PCTechTalk's Guitar Man


If you're like most folks, your Address Book is your lifeline to the
world of email. As such, it's EXTREMELY important that you back up the
info it contains on a regular basis.

To back it up, open up Outlook Express and go to File/Export/Address

When the Export Wizard opens, select the "Text File (Comma Separated
Values)" option and click on the Export button. The wizard will ask you
to give the file a name. I suggest using something like "OE Address Book
8_26_01" to help you to remember what it is and when you created it.

After giving it a name, click on the Browse button and show the wizard
where you'd like to store this file (the My Documents folder works great
for this).

Click on the Next button to continue creating the back up. Select the
fields you want to export (unless you have a good reason for not
allowing some of them, I suggest selecting all of them). When you're
finished, click on the Finish button to complete the creation of the
back up.

While the default My Documents folder works fine for storing the backup
on your hard drive, I recommend that you now copy the resulting file
onto a floppy or some other form of storage outside of your computer.
This is necessary in case of a full hard drive crash or if the need for
a hard drive format ever comes up.

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

~~Links For Info on Online Privacy ~
from "Master Links 4 Master Investigators"

There is a whole world of knowledge available on the Internet. Do you
run a firewall? Do you run a virus scanner? Do you know how much
information you provide just surfing the Internet sites, giving out your
e-mail addresses, or posting messages to lists that you are on?

Check out some of these links.

Electronic Frontier Foundations Top 12 Ways to Protect Your Online
Privacy http://www.eff.org/Privacy/eff_privacy_top_12.html

Enonymous=97Improve Your Privacy, Check a Site=92s Privacy Rating-- =
the most comprehensive study of privacy policies ever conducted (over
30,000 sites are analyzed). http://www.enonymous.com/

U.S. Senate Judiciary Committee .pdf files on Internet Privacy. You will
need to have Adobe Acrobat Reader (Free) on your computer to read .pdf
files. Get it here. http://www.adobe.com/products/acrobat/readstep.html

Please remember, these are US Government sponsored documents. My point
in bringing you these points-of-view, along with specific programs or
steps to take, is to give you search options, ideas on what can be
learned from you surfing the web, and your vulnerability if you don=92t
take some precautions:  Know the Rules Use the Tools-- Privacy in the
Digital World: A resource for Internet users

Is Windows always crashing? Does your browser keep shutting down after
performing an "illegal operation"? Are your system resources always
running dangerously low, even without that many windows open? You may be
transmitting your personal information across the Internet without your
knowledge or consent. Beware of Freeware--It might be SPYWARE

Here is a site to check if one of those programs on your computer is
"sending home" messages:

The Spyware Infested Software List http://www.infoforce.qc.ca/spyware/

XXX-CELL-ANT=97Scary---Analyze Your Internet Privacy http://privacy.net/

Check Your Firewall XXX-CELL-ANT
and then click at "Symantec Security Check"

This site below is made for activists to hide their activity, but they
provide some of the best methods for providing us "little people" with
ways to protect our own privacy in this world of the Internet. They do
advocate the most severe measures on maintaining privacy, but this site
will show you ways to alleviate spamming, and for protection of your
children or yourself.

Computer & Internet Security, Privacy, Anonymity and more

Computer Professionals for Social Responsibility--A public-interest
alliance of computer scientists and others concerned about the impact of
computer technology on society, http://www.cpsr.org/ especially Privacy
and Civil Liberties http://www.cpsr.org/program/privacy/privacy.html

Find these and more links at our easily-searchable site of over 15,000
links. Subscribers to this newslist will be given a free trial period.
E-mail me at the below address for access.

Master Links 4 Master Investigators
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 - 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, Volume 4: More Furniture Moving in Word