Novice
Windows 7 64bit 
Access 2010 64bit
Hello-
I have two tables Main Table and Last Contact Table. I have a "relationship" between the two. I need to add a date to multiple contacts to create a "last contact date - rather than entering the info to each contact (over 3,000 names). I am trying to create a report of people Not contacted in some many days. Do I need to create a "last contact id" (auto)" or "main id (auto)" in the last contact table. I tried to do an append table and it didn't work. Thanks!
Moderator
Windows XP Access 2003
What are the fields in your tables?
If you have no record of the Last Contact Date for any people, what date did you plan on adding?
Can you walk through an example using some appropriate data so that we understand WHAT you are trying to do?
Advanced System Analyst
Windows XP Access 2007
probably you need to create a form with last contact date field. Create a VBA code to automatically add =Now() to last contact date when some action trigger.that way you need not have to add last contact date manually to each row.
Novice
Windows 7 64bit Access 2010 64bit
Thanks for replying Orange...Originally Posted by orange
The main table has Main ID and personal info like last name, first name, full name, address, Phone numbers, email address, birthdates, work address, title, family member names, and a notes field etc.
The Last Contact table has a Main ID to connect the two tables, a Last Contact ID and last contact date, type of contact (email, phone, in person) and purpose (reason for the call..hand hold, goodwill, review, etc.)
I have added in alot of new names and I am trying to create a report that will show me all those names. They are not in a certain place in the database - the IDs are all different and in different places so I can't group them to add a bulk last contact date. I had planned on adding a "certain date" so I can locate them easily.
Does this help?
Thank you
Novice
Windows 7 64bit Access 2010 64bit
The main table has Main ID and personal info like last name, first name, full name, address, Phone numbers, email address, birthdates, work address, title, family member names, and a notes field etc.
The Last Contact table has a Main ID to connect the two tables, a Last Contact ID and last contact date, type of contact (email, phone, in person) and purpose (reason for the call..hand hold, goodwill, review, etc.)
I have added in alot of new names and I am trying to create a report that will show me all those names. They are not in a certain place in the database - the IDs are all different and in different places so I can't group them to add a bulk last contact date. I had planned on adding a "certain date" so I can locate them easily.
Also, what is a VBA....I am a complete novice....
Thank you
Moderator
Windows XP Access 2003
Can you tell us the use of this database? If it's for some sort of business, then I think you should seriously consider studying some of the concepts of database design and structure. In any event there seems to be a few issues that some design adjustment might "improve".
Here are a couple of articles that you should read to help get some perspective.
http://forums.aspfree.com/attachment...achmentid=4712
The first 3 topics at http://www.rogersaccesslibrary.com/forum/topic238.html
As for vba http://en.wikipedia.org/wiki/Visual_...r_Applications
Good luck with your project.
Novice
Windows 7 64bit Access 2010 64bit
Its for two people - we have our clients and prospects in a database. I just dont want to create a record for over 3,000 names. I thought in the past we could do it. I have been researching how to do. I tried using the Append query and the Update query but I need to get the names I needed in a certain area. All I want to do is if I have NO last contact for a prospect then add a last contact for them with a random date. Its been done before, but I can't remember how to do it and the article you send really didn't describe what I am looking do for.
I thought someone out in cyber world would know how to do this - it seemed easy enough. I guess it isn't. Oh well...thank you for your advice.
Moderator
Windows XP Access 2003
It can be done, and relatively easily. It's important to know what your tables are and what they represent.
You mention Clients and Prospects, but you only referred to Main Table and Last Contact Table.
Are you keeping a History of when you contact a person?
Can you show the layouts of your Tables?
Novice
Windows 7 64bit Access 2010 64bit
Yes we are keeping a history of the contacts..
I am unable to show they lay outs - I have the lay out on a personal computer with NO internet access.
I have a total of three tables:
1) Main table...its has clients and prospects names and personal info
2) last contact table....has obviously last contact dates and it may have up to 20 records - we make a records each time we speak to them
3) Nect contact table...it shows when we need to seak to them next.
All I need to do is to do a "mass update" type thing where there is NO last contact record to add one and link it to their "main Id" record.
Moderator
Windows XP Access 2003
Look in Access help for UnMatched Query and see if that helps.
Here is another link
http://office.microsoft.com/en-us/ac...010205132.aspx
Date textbox for multiple records in table
Adding multiple records from one form
Posting Permissions
Reply With Quote