Need help with tables setup

Hi Adrian :-)

Jan Il wrote:


The one thing that I have found in the manner I have been logging the
snippets, which is somewhat organized, is that I wind up duplicating
some,
perhaps by just a bit of wording, as I review various sites in
research. I
find that many experts have their own favorite method or style of doing
things, and they are all good, so I like having the various methods.
However, I don't think there is a need to have several variations of the
same method. Thus, I've decided it's time to get me to the database.

Thank you very much for your time and sharing your information, I really
do
appreciate it. The task does not look quite so onerous now. g




The duplication problem is always there, thats why I used my own set of
keywords, and of course by assigning the keyword to several different
snippets, a search on the keyword pulls them all up together.

Yes...and I will keep that information in mind while compiling the data for
the tables. There's often more than one reference word for some procedures,
so determining the keywords for these will be a bit more difficult. Think
I'll have to create my own glossary for some of them. :-)

Jan

--
Regards,

Adrian Jansen adrianjansen at internode dot on dot net
Design Engineer J & K Micro Systems
Microcomputer solutions for industrial control
Note reply address is invalid, convert address above to machine form.

Hey Jan:

I've been too busy (helping my children with their homework - how did I
*ever* pass elementary school?!?) to put much time into this, but I'm
interested. Do you still have a copy of my library application? The use of
keywords twigged with me; you might want to create a many-to-many table so
that any one record could have multiple keywords, much as a book could have
multiple subjects...

Oh, and thanks for the forward pass!

Fred
"Jan Il" wrote in message
...
Hi Adrian :-)

Jan Il wrote:


The one thing that I have found in the manner I have been logging the
snippets, which is somewhat organized, is that I wind up duplicating
some,
perhaps by just a bit of wording, as I review various sites in
research. I
find that many experts have their own favorite method or style of
doing
things, and they are all good, so I like having the various methods.
However, I don't think there is a need to have several variations of
the
same method. Thus, I've decided it's time to get me to the database.

Thank you very much for your time and sharing your information, I
really
do
appreciate it. The task does not look quite so onerous now. g




The duplication problem is always there, thats why I used my own set of
keywords, and of course by assigning the keyword to several different
snippets, a search on the keyword pulls them all up together.

Yes...and I will keep that information in mind while compiling the data
for
the tables. There's often more than one reference word for some
procedures,
so determining the keywords for these will be a bit more difficult. Think
I'll have to create my own glossary for some of them. :-)

Jan

--
Regards,

Adrian Jansen adrianjansen at internode dot on dot net
Design Engineer J & K Micro Systems
Microcomputer solutions for industrial control
Note reply address is invalid, convert address above to machine form.

Hi Jan,
Here's another tip for you, since you are using OE. If you come across a
post that you'd like to keep, you can drag the message from OE into Access.
A bit of parsing and you can separate the header information (date, title,
author, message). Add some keywords, and you've got your own little
newsgroup search database.

Although you can keep messages in local folders in OE, I find it easier to
search in Access, and also OE has more than once destroyed my local folders.

--
Joan Wild
Microsoft Access MVP

Hi Joan! :-)

Hi Jan,
Here's another tip for you, since you are using OE. If you come across a
post that you'd like to keep, you can drag the message from OE into
Access.
A bit of parsing and you can separate the header information (date, title,
author, message). Add some keywords, and you've got your own little
newsgroup search database.

Very good idea! That would save a lot of time too.

Although you can keep messages in local folders in OE, I find it easier to
search in Access, and also OE has more than once destroyed my local
folders.

Indeed! That is sort of what I have been doing, merely due to the lack of
time when I want to add a new find, which seem to be in abudance these days
with the problems with SP2 and IE. So, getting them direct into Access
would be a big time saver. Also, as you say, OE is not a good baby-sitter
for files. I lost a 3 months worth of messages and files when OE decided to
dump me. So now I back up my folders about twice a week, or more if I've
been saving a lot of messages. OE is sooo fickle..one day it knows
you.....the next day your toast! ;o)

Thank you very much for the additional information, I really do appreciate
it. Now I'm of the see deh Wizard! :-)

Jan
Smiles are meant to be shared,
that's why they're so contagious.


--
Joan Wild
Microsoft Access MVP

Hey Fred! :-)

" Hey Jan:

I've been too busy (helping my children with their homework - how did I
*ever* pass elementary school?!?) to put much time into this, but I'm
interested. Do you still have a copy of my library application? The use of
keywords twigged with me; you might want to create a many-to-many table so
that any one record could have multiple keywords, much as a book could
have
multiple subjects...

No problem. Yes! I do still have the copy of our library setup you sent
me. In fact, I was thinking about that as well. In fact, I was wondering
where you were. Now....you should know better than to 'help' your children
with their homework. All parents are Kinderkid faiures, or 'that was the
way they did things in the old days! See...today it's the New math and New
Wave English Lit, and History revised and then revisited. vbg

I'll give it a look, as the many to many may be a good idea since there can
be more than one keyword and topics for each.

Oh, and thanks for the forward pass!

You're very welcome! I haven't had much chance yet to get into the db, as
our power has been sporadic here the past couple of days, and out most of
this morning. They're renovating our apt. building. It's one of the older
buildings in Warrenton, VA in the Old Town district. Why...we'll even have
indoor plumbing! (vbg)

Jan
Smiles are meant to be shared,
that's why they're so contagious.



Fred
"Jan Il" wrote in message
...
Hi Adrian :-)

Jan Il wrote:


The one thing that I have found in the manner I have been logging
the
snippets, which is somewhat organized, is that I wind up duplicating
some,
perhaps by just a bit of wording, as I review various sites in
research. I
find that many experts have their own favorite method or style of
doing
things, and they are all good, so I like having the various methods.
However, I don't think there is a need to have several variations of
the
same method. Thus, I've decided it's time to get me to the
database.

Thank you very much for your time and sharing your information, I
really
do
appreciate it. The task does not look quite so onerous now. g




The duplication problem is always there, thats why I used my own set
of
keywords, and of course by assigning the keyword to several different
snippets, a search on the keyword pulls them all up together.

Yes...and I will keep that information in mind while compiling the data
for
the tables. There's often more than one reference word for some
procedures,
so determining the keywords for these will be a bit more difficult.
Think
I'll have to create my own glossary for some of them. :-)

Jan

--
Regards,

Adrian Jansen adrianjansen at internode dot on dot net
Design Engineer J & K Micro Systems
Microcomputer solutions for industrial control
Note reply address is invalid, convert address above to machine form.