Need help with a VB database project.

I'm new to programming but I can find my way around the environment and can use the data control and most of the associated data bound controls. I'm trying to develop a VB front end for an existing Access 97 database. The database uses one table that contains contact information for the clients of a law practice. The fields are common to a database of this type, First & Last name, Address, File # etc. My problem is that I'm trying to add a function that will enable the user to log a phone call, letter or other daily activities and have it store it by date so that it can be brought up later in a list and browsed or printed along with the other client information. I suppose this would be similar to a contact management program. Any help would be very much appreciated. Adding to the Access database is no problem if it is necessary. I hope I've stated this problem well enough for you to understand but like I said earlier..............I'm new!
Thanks again,
Danny Mullins
Clintwood, VA - USA

I consider it's what u mean:U will developer a db manager program to store customer information,And query some information to a customer..I recommend to use ms access if u have small information to be stored.If u have a lot of information(like 1000 customer information),I recommend u to use ms sql which has better process ability..

I can give u a sample code:http://www.freevbcode.com/ShowCode.Asp?ID=1342,and u can find more in the google.

I did this in my own custom contact manager by adding a diary table and some forms that allow adding/updating diary entries.

Hello,Doug G!Can u post your code to sharing??Or tell your mind about develope this code??

I added a 2nd table with a foreign key to contacts, a date stamp, and a text column.

Then SELECT * FROM contact_diary WHERE ContactID = <desired ID>

So are you trying to create a table in VB? Or do you want the SQL for interacting with that table with your VB Form?

Need more explanation...

cleverpig, I'll try downloading that and have a look.

Doug, We may be on the same wavelength here but I'm not sure what a "foreign key" is. I was thinking that I needed to add another table to the Access database and the text field is the way to go but, how would I get the daily contact data into the text field and be able to get it back out in some formatted fashion for viewing or printing? This problem may be too detailed to try and solve on a forum since I'm not sure how to explain it in terms that experienced programmers, like you guys, can understand. I do appreciate everyone trying to help.
Danny

A foreign key is a field in the 2nd table that links you back to the 1st table. In this case, assuming you have contacts in a table with a contact ID field, the 2nd table would have a field that holds the contact ID.

Gotcha' I'll try adding the second table and set it up with the id, date and text fields and then see if I can come up with some code that will send the daily entries to the text box. Maybe if I can get them in there I'll figure out some way to get them out and formatted later.
Thanks much for the help,
Danny

Doug,
Any chance of having a look at your contact manager or at least the "diary" section of it? I think it would help me with my project but I understand it's copywritten or otherwise private.
Thanks my friend,
Danny

Well, my contact program is not web accessible and it's a unique program I've thrown together for myself over the years.

In general, from a contact form I have a button "Diary". This opens a popup form that gets the current contact ID passed to it, and provides controls to display/add diary entries into the diary table. The diary form is pretty simple, just a few controls to hold the contact ID, date/time and a multiline text field to enter stuff.

hth