Web Development

General discussion


MS Access - Automate Data Entry

By jgreer ·
I am currently working on a database that will need to update approx 1,000 records with specific information. Here is what I need it to do and I haven't been able to get it to work so steps would be appreciated.

I have one table that has all of the records information and a field called RecordID that is autonumber. In another table I am tracking mailings and it has a entry cell that is autonumber, a RecordID that is just a number, Date and Status fields. I have created a relationship between the two RecordID fields but now I need the database to automatically post the RecordID from the general information table to the mailing table and set the date to todays date and the status field to mailed each time that record is requested. Is there anyway to automate this task since it has to update so many records? I have experimented some with update and append queries and I still cannot seem to get the RecordID to post into the mailings table.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by john_wills In reply to MS Access - Automate Data ...

The mailing action should be accompanied by carrying of the mailing-list RecordID and it's corresponding tracking RecordID. With DoCmd.RunSQL invoke an UPDATE query. I wish you hadn't called both subsidiary keys RecordID, and I suspect you didn't need them at all - why not use the Autonumber keys?

Collapse -

by jgreer In reply to

Poster rated this answer.

Collapse -

by jgreer In reply to MS Access - Automate Data ...

This question was closed by the author

Related Discussions

Related Forums