Need help with tables setup

Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums, and needless to say
my resource and reference files are getting quite large, and take some time
to sort through. I would like to develop an Access database for easier
access, however, I am not sure which type of format would be best. I was
thinking something along the lines of a library book type setup, with a
section for each newsgroup. I was hoping that one of the regulars here may
also use something of this nature to keep track of their references and a
sorting system.....of sorts.

I have been sampling with a few formats that I have used previously, but,
they don't really seem to provide the system that I would like to have for
researching.

Once I am able to determine the type of format to use, I can better decide
how to set up the tables and relationships. I'm just not sure how this
should be done, and I would truly appreciate any suggestions or references
to such information if possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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

Hi Jan,

Tony Toews has already done all the work for you.
Download his newsgroup "helper" database he

http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

You can begin collecting links, sample code, NG posts you
may use sometime, etc. I've been using this for quite a
while now and it has proved very useful in looking for
code that I think, "Boy, I remember saving that in here."
Also makes it real easy to respond to post topics that I
have already typed something up in the past.

I would just have one database for each newsgroup. Like
one for Access, one for Excel, one for PowerPoint, etc.

I would send you my Access one (~250 items), however, I am
unable to at the moment. Our office satellite connection
is down right now. It's not the modem this time, it is the
satellite itself! We are dead in the water; no e-mail, no
Internet, no NGs yesterday, today, and no estimate on when
things will be back to normal. I could be cut off for
quite a while. Noooo! I'm not even sure if this message
will go through as I am trying something (don't ask). So I
hope you see this message and good luck with Tony's file.
It should be just what you need.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums,
and needless to say my resource and reference files are
getting quite large, and take some time to sort through.
I would like to develop an Access database for easier
access, however, I am not sure which type of format would
be best. I was thinking something along the lines of a
library book type setup, with a section for each
newsgroup. I was hoping that one of the regulars here may
also use something of this nature to keep track of their
references and a sorting system.....of sorts.

I have been sampling with a few formats that I have used
previously, but, they don't really seem to provide the
system that I would like to have for
researching.

Once I am able to determine the type of format to use, I
can better decide how to set up the tables and
relationships. I'm just not sure how this
should be done, and I would truly appreciate any
suggestions or references to such information if
possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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

Hey Jeff! :-)

Hi Jan,

Tony Toews has already done all the work for you.
Download his newsgroup "helper" database he

http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

Wooohoo!!! Bless his heart! G


You can begin collecting links, sample code, NG posts you
may use sometime, etc. I've been using this for quite a
while now and it has proved very useful in looking for
code that I think, "Boy, I remember saving that in here."
Also makes it real easy to respond to post topics that I
have already typed something up in the past.

I would just have one database for each newsgroup. Like
one for Access, one for Excel, one for PowerPoint, etc.

'k...that sounds like a good game plan. It will also simplify the data
collection, and...keep me from posting the wrong information to the wrong
question, which I'm sure at some point(s) I most likely would. g

I would send you my Access one (~250 items), however, I am
unable to at the moment. Our office satellite connection
is down right now. It's not the modem this time, it is the
satellite itself! We are dead in the water; no e-mail, no
Internet, no NGs yesterday, today, and no estimate on when
things will be back to normal. I could be cut off for
quite a while. Noooo! I'm not even sure if this message
will go through as I am trying something (don't ask). So I
hope you see this message and good luck with Tony's file.
It should be just what you need.

Booo!! Sheesh...I hate it when that happens! I get horrible withdrawals!
Then I'm left to my own devices, and that is always a disaster looking for a
place to happen. ;o)

I'll start with Tony's examples, and when you can get back up on line, you
can e-mail me a copy of yours. I think you may still have my addy. I'd
really be interested to see how you have yours set up too.

Good luck with the Dead Star..... (satallite)

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


--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums,
and needless to say my resource and reference files are
getting quite large, and take some time to sort through.
I would like to develop an Access database for easier
access, however, I am not sure which type of format would
be best. I was thinking something along the lines of a
library book type setup, with a section for each
newsgroup. I was hoping that one of the regulars here may
also use something of this nature to keep track of their
references and a sorting system.....of sorts.

I have been sampling with a few formats that I have used
previously, but, they don't really seem to provide the
system that I would like to have for
researching.

Once I am able to determine the type of format to use, I
can better decide how to set up the tables and
relationships. I'm just not sure how this
should be done, and I would truly appreciate any
suggestions or references to such information if
possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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

Jan Il wrote:
Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums, and needless to say
my resource and reference files are getting quite large, and take some time
to sort through. I would like to develop an Access database for easier
access, however, I am not sure which type of format would be best. I was
thinking something along the lines of a library book type setup, with a
section for each newsgroup. I was hoping that one of the regulars here may
also use something of this nature to keep track of their references and a
sorting system.....of sorts.

I have been sampling with a few formats that I have used previously, but,
they don't really seem to provide the system that I would like to have for
researching.

Once I am able to determine the type of format to use, I can better decide
how to set up the tables and relationships. I'm just not sure how this
should be done, and I would truly appreciate any suggestions or references
to such information if possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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





I use something similar, but because I also use it for snippets of code,
and that often crosses multiple applications - think VBA - I did it this
way:

tblPrograms
ProgramID *
ProgramName
Application

tblAuthors
AuthorID *
Author

tblSubjects
SubjectID *
ProgramID
AuthorID
Subject - eg news subject

tblHints
HintID *
SubjectID
Hint - memo field
HintDate

tjcHintKey - junction table, combined primary key
HintID
KeywordID

tblKeywords
KeywordID *
Keyword
Description

The starred items are the primary keys. I think the structure is pretty
obvious, and seems to handle what I do reasonably well.
Inserting meaningful keywords is the hardest part, but also the most
powerful way of keeping track of stuff.

--
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 Adrian :-)

Jan Il wrote:
Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums, and needless to
say
my resource and reference files are getting quite large, and take some
time
to sort through. I would like to develop an Access database for easier
access, however, I am not sure which type of format would be best. I
was
thinking something along the lines of a library book type setup, with a
section for each newsgroup. I was hoping that one of the regulars here
may
also use something of this nature to keep track of their references and
a
sorting system.....of sorts.

I have been sampling with a few formats that I have used previously,
but,
they don't really seem to provide the system that I would like to have
for
researching.

Once I am able to determine the type of format to use, I can better
decide
how to set up the tables and relationships. I'm just not sure how this
should be done, and I would truly appreciate any suggestions or
references
to such information if possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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


I use something similar, but because I also use it for snippets of code,
and that often crosses multiple applications - think VBA - I did it this
way:

tblPrograms
ProgramID *
ProgramName
Application

tblAuthors
AuthorID *
Author

tblSubjects
SubjectID *
ProgramID
AuthorID
Subject - eg news subject

tblHints
HintID *
SubjectID
Hint - memo field
HintDate

tjcHintKey - junction table, combined primary key
HintID
KeywordID

tblKeywords
KeywordID *
Keyword
Description

The starred items are the primary keys. I think the structure is pretty
obvious, and seems to handle what I do reasonably well.
Inserting meaningful keywords is the hardest part, but also the most
powerful way of keeping track of stuff.

Yes...that look very simple, yet, that is what will make it efficient. As
with any large amount of data, the fastest way to search is to keep things
simple. That way, neither you, nor Access, has to think that hard. And for
me...that's really good! ;-)

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

Hi Jan,

I am going to try and send you the file from a different account.
I do not know if it will work so please post back here if it was
successful or not. Do not respond back to the e-mail as I will
not receive it.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Jan Il" wrote in message ...
Hey Jeff! :-)

Hi Jan,

Tony Toews has already done all the work for you.
Download his newsgroup "helper" database he

http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

Wooohoo!!! Bless his heart! G


You can begin collecting links, sample code, NG posts you
may use sometime, etc. I've been using this for quite a
while now and it has proved very useful in looking for
code that I think, "Boy, I remember saving that in here."
Also makes it real easy to respond to post topics that I
have already typed something up in the past.

I would just have one database for each newsgroup. Like
one for Access, one for Excel, one for PowerPoint, etc.

'k...that sounds like a good game plan. It will also simplify the data
collection, and...keep me from posting the wrong information to the wrong
question, which I'm sure at some point(s) I most likely would. g

I would send you my Access one (~250 items), however, I am
unable to at the moment. Our office satellite connection
is down right now. It's not the modem this time, it is the
satellite itself! We are dead in the water; no e-mail, no
Internet, no NGs yesterday, today, and no estimate on when
things will be back to normal. I could be cut off for
quite a while. Noooo! I'm not even sure if this message
will go through as I am trying something (don't ask). So I
hope you see this message and good luck with Tony's file.
It should be just what you need.

Booo!! Sheesh...I hate it when that happens! I get horrible withdrawals!
Then I'm left to my own devices, and that is always a disaster looking for a
place to happen. ;o)

I'll start with Tony's examples, and when you can get back up on line, you
can e-mail me a copy of yours. I think you may still have my addy. I'd
really be interested to see how you have yours set up too.

Good luck with the Dead Star..... (satallite)

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


--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums,
and needless to say my resource and reference files are
getting quite large, and take some time to sort through.
I would like to develop an Access database for easier
access, however, I am not sure which type of format would
be best. I was thinking something along the lines of a
library book type setup, with a section for each
newsgroup. I was hoping that one of the regulars here may
also use something of this nature to keep track of their
references and a sorting system.....of sorts.

I have been sampling with a few formats that I have used
previously, but, they don't really seem to provide the
system that I would like to have for
researching.

Once I am able to determine the type of format to use, I
can better decide how to set up the tables and
relationships. I'm just not sure how this
should be done, and I would truly appreciate any
suggestions or references to such information if
possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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

HI Jeff!

Yes, I received the DB, and it looks just perfect for what I need. I like
having the details of the response or instructions in a page format. A few
I have to use can be somewhat lengthy, as it is a series of instructions to
be carried out together. Having to insert them separately would be rather
inefficient.

Thank you very much for sharing your information, I truly do appreciate it.
If I have questions, which I am sure I will, I'll get back with you. Let me
know when they have you up and running on your e-mails again. :-)

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


"Jeff Conrad" wrote in message
...
Hi Jan,

I am going to try and send you the file from a different account.
I do not know if it will work so please post back here if it was
successful or not. Do not respond back to the e-mail as I will
not receive it.

--
Jeff Conrad
Access Junkie
Bend, Oregon

"Jan Il" wrote in message
...
Hey Jeff! :-)

Hi Jan,

Tony Toews has already done all the work for you.
Download his newsgroup "helper" database he

http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

Wooohoo!!! Bless his heart! G


You can begin collecting links, sample code, NG posts you
may use sometime, etc. I've been using this for quite a
while now and it has proved very useful in looking for
code that I think, "Boy, I remember saving that in here."
Also makes it real easy to respond to post topics that I
have already typed something up in the past.

I would just have one database for each newsgroup. Like
one for Access, one for Excel, one for PowerPoint, etc.

'k...that sounds like a good game plan. It will also simplify the data
collection, and...keep me from posting the wrong information to the
wrong
question, which I'm sure at some point(s) I most likely would. g

I would send you my Access one (~250 items), however, I am
unable to at the moment. Our office satellite connection
is down right now. It's not the modem this time, it is the
satellite itself! We are dead in the water; no e-mail, no
Internet, no NGs yesterday, today, and no estimate on when
things will be back to normal. I could be cut off for
quite a while. Noooo! I'm not even sure if this message
will go through as I am trying something (don't ask). So I
hope you see this message and good luck with Tony's file.
It should be just what you need.

Booo!! Sheesh...I hate it when that happens! I get horrible
withdrawals!
Then I'm left to my own devices, and that is always a disaster looking
for a
place to happen. ;o)

I'll start with Tony's examples, and when you can get back up on line,
you
can e-mail me a copy of yours. I think you may still have my addy. I'd
really be interested to see how you have yours set up too.

Good luck with the Dead Star..... (satallite)

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


--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums,
and needless to say my resource and reference files are
getting quite large, and take some time to sort through.
I would like to develop an Access database for easier
access, however, I am not sure which type of format would
be best. I was thinking something along the lines of a
library book type setup, with a section for each
newsgroup. I was hoping that one of the regulars here may
also use something of this nature to keep track of their
references and a sorting system.....of sorts.

I have been sampling with a few formats that I have used
previously, but, they don't really seem to provide the
system that I would like to have for
researching.

Once I am able to determine the type of format to use, I
can better decide how to set up the tables and
relationships. I'm just not sure how this
should be done, and I would truly appreciate any
suggestions or references to such information if
possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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

Hey Jeff... could you send that to me, too, please?

Thanks!
Fred

"Jeff Conrad" wrote in message
...
Hi Jan,

Tony Toews has already done all the work for you.
Download his newsgroup "helper" database he

http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

You can begin collecting links, sample code, NG posts you
may use sometime, etc. I've been using this for quite a
while now and it has proved very useful in looking for
code that I think, "Boy, I remember saving that in here."
Also makes it real easy to respond to post topics that I
have already typed something up in the past.

I would just have one database for each newsgroup. Like
one for Access, one for Excel, one for PowerPoint, etc.

I would send you my Access one (~250 items), however, I am
unable to at the moment. Our office satellite connection
is down right now. It's not the modem this time, it is the
satellite itself! We are dead in the water; no e-mail, no
Internet, no NGs yesterday, today, and no estimate on when
things will be back to normal. I could be cut off for
quite a while. Noooo! I'm not even sure if this message
will go through as I am trying something (don't ask). So I
hope you see this message and good luck with Tony's file.
It should be just what you need.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums,
and needless to say my resource and reference files are
getting quite large, and take some time to sort through.
I would like to develop an Access database for easier
access, however, I am not sure which type of format would
be best. I was thinking something along the lines of a
library book type setup, with a section for each
newsgroup. I was hoping that one of the regulars here may
also use something of this nature to keep track of their
references and a sorting system.....of sorts.

I have been sampling with a few formats that I have used
previously, but, they don't really seem to provide the
system that I would like to have for
researching.

Once I am able to determine the type of format to use, I
can better decide how to set up the tables and
relationships. I'm just not sure how this
should be done, and I would truly appreciate any
suggestions or references to such information if
possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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

Hi Fred! :-)

I've forwarded you a copy of the one Jeff sent me, just in case he has
problems sending right away.

Jan

"Fred Boer" wrote in message
...
Hey Jeff... could you send that to me, too, please?

Thanks!
Fred

"Jeff Conrad" wrote in message
...
Hi Jan,

Tony Toews has already done all the work for you.
Download his newsgroup "helper" database he

http://www.granite.ab.ca/access/newsgroupanswersmdb.htm

You can begin collecting links, sample code, NG posts you
may use sometime, etc. I've been using this for quite a
while now and it has proved very useful in looking for
code that I think, "Boy, I remember saving that in here."
Also makes it real easy to respond to post topics that I
have already typed something up in the past.

I would just have one database for each newsgroup. Like
one for Access, one for Excel, one for PowerPoint, etc.

I would send you my Access one (~250 items), however, I am
unable to at the moment. Our office satellite connection
is down right now. It's not the modem this time, it is the
satellite itself! We are dead in the water; no e-mail, no
Internet, no NGs yesterday, today, and no estimate on when
things will be back to normal. I could be cut off for
quite a while. Noooo! I'm not even sure if this message
will go through as I am trying something (don't ask). So I
hope you see this message and good luck with Tony's file.
It should be just what you need.

--
Jeff Conrad
Access Junkie
Bend, Oregon

-----Original Message-----
Hi all - Access 2002 XP - W2K

I am a regular responder on a few newsgroups and forums,
and needless to say my resource and reference files are
getting quite large, and take some time to sort through.
I would like to develop an Access database for easier
access, however, I am not sure which type of format would
be best. I was thinking something along the lines of a
library book type setup, with a section for each
newsgroup. I was hoping that one of the regulars here may
also use something of this nature to keep track of their
references and a sorting system.....of sorts.

I have been sampling with a few formats that I have used
previously, but, they don't really seem to provide the
system that I would like to have for
researching.

Once I am able to determine the type of format to use, I
can better decide how to set up the tables and
relationships. I'm just not sure how this
should be done, and I would truly appreciate any
suggestions or references to such information if
possible. Or, if someone has a better system, I
would really be interested to hear about it. :-)

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

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.

--
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.