add multiple records at once

V

vedran

I am using Contacts database template available from Microsoft Access website.
I'd like to be able to add new Call notes to multiple contacts at once.
Contacts table is related to Calls table where each contact can have multiple
Call notes. For example, if I send an email to all my contacts and would like
to log that in calls table can I do it for all contacts instead of having to
go into each contact to add a note? Is there a way to do something like this?
 
J

John Vinson

I am using Contacts database template available from Microsoft Access website.
I'd like to be able to add new Call notes to multiple contacts at once.
Contacts table is related to Calls table where each contact can have multiple
Call notes. For example, if I send an email to all my contacts and would like
to log that in calls table can I do it for all contacts instead of having to
go into each contact to add a note? Is there a way to do something like this?
Click to expand...

You could create an Append query; if you have some criteria
identifying which contacts need new Call records, simply base the
Append query on the Contacts table using these criteria. Append the
ContactID from the Contacts table, and the other fields (date/time,
purpose, etc.) from calculated fields:

INSERT INTO Calls
(ContactID, CallDate, Subject)
SELECT ContactID, Now(), "EMail about database design"
FROM Contacts
WHERE <your criteria>

John W. Vinson[MVP]
 
Top