Re: Communication Log

How's this for a reference!

His (... i.e. Steve) technical answers in these forums are good.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/




"John Marshall, MVP" <lancucki@xxxxxxxxxxxxx> wrote in message
news:exwbC89zHHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
Be careful, steve does have a reputation. Check his references first.

John... Visio MVP

"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B01F381C-7DB6-47C3-A1C1-5EF419147CF0@xxxxxxxxxxxxxxxx
Hello Steve,

May I send you copy of the database that I made? It will have fake info
in
it so that you can see how I have it set up so far. I'd like you to veiw
it
and tell me if I'm on the right track. If you're willing to share your
real
email address with me I'll give you mine beacuse I'd like to contact you
further about my database. Please reply ASAP.

Thank you,
--
John R. L.


"Steve" wrote:

Helo John,

A good database begins with a set of well designed tables. Here's a
recommendation for your tables:
TblContact
ContactID
FirstName
MI
LastName
<<Fields of contact information>>

TblContactMethod
ContactMethodID
ContactMethod

TblContactWithContact
ContactWothContactID
ContactID
ContactMethodID
ContactDateTime
ContactNote

For entering contacts, contacts with contacts and viewing contacts with
contacts, you can use a form/subform. First create a query based on
TblContact and sort ascending on LastName. Use that query for the
recordsource of the main form. Then create a query based on
TblContactWithContact and sort descending on ContactDateTime. Use this
query
for the recordsource of the subform. Make the subform a continuous form.
Set
the LinkMaster and LinkChild properties of the subform control to
ContactId.
If you do all this, the main form will display one contact at a time and
the
contacts will be in alphabetical order. The subform will be a list and
will
display all the contacts with the contact in the main form from last
contact
to first contact.

PC Data***
Providing Customers A Resource For Help With Access, Excel And Word
Applications
resource@xxxxxxxxxxxxxxx





"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F6369E5-32A7-4649-B7EC-59DF7A3CDA72@xxxxxxxxxxxxxxxx
I'm not sure if I'm posting this message in the correct area so if you
read
this and you think that it should be posted somewhere else please let
me
know.

Before I ask my question I'm going to tell you a litle bit about what
I'm
trying to do.
I am the Public Relations (PR) Officer for the Self Advocacy Council
of
Northern Illinois (SACNI) and I am making a database to keep track of
all
contact nformation (members & other people we've contacted). I want to
set
up
a communication log in the database so that it will store the Date,
time,
and
Contact Method ID for 1 year for each contact.

My form is set up as follows. (Note: LC = Label Caption & Txtbx = Tex
tbox

LC Control Notes
Contact Method ID: Dropdown box (I can select a value to store in the
ContactMethodID
field)
LC Txtbx1 Txtbx2
Last Contact Date & Time: Date Time

Notes: Txtbx1 is set to accept Date from the Date/Time option that I
set
for
the LastContactDate field in my table and Txtbx2 is used to insert the
tme
into the LastContactTime field.

The above controls are set up in a page using te tab control.
Underneath
the
tab control I have two more controls set up and they are as follows:

LC Txtbx1 LC Txtbx2
Contact Updated on Date at Time

Note: Txtbx1 stores the date in the DateContact Updated field and
Txtbx2
stores the time in the TimeContactUpdated field.

Now that I've explained how the form is set up, my questions are as
follows:

I want to have the control for each field store the data in the proper
fields. When new dates and times are entered I want the database to
move
the
old valuses to the Communications log. When I view my records I want
to be
able to view the communication log by clicking a link that says View
Communication log. and have it pull up the information for that
contact. I
want it to display the newest or the most up-to-date information
first
followed by the old er values. I also want to use only one log to
store
all
the contacts' information

1. Is there a way to set up my database so that it will save the
information
stored in the ContactMethodID, LastContactDate & LastContactTime for
the
length of 1 year?

--
John R. L.







.