G
GeorgieGirl
Trying to create an audit log in Access of changes to an Excel Worksheet My
application transfers the data from Excel into Access and runs edits on it.
When importing each row is assigned a record # (auto number field). I have
successfully linked to an Excel worksheet and can update it from a form in
Access. All changes must be made in the original Excel worksheet and logged.
My problem - I want to view the Access table and the Excel worksheet so that
rows requiring updating can be easily found by the record number in the
Access table. I have tried to use a form whose record source is a query
giving the required fields from both the Excel worksheet and the Access
table. But I cannot update/change any data in the form.
Is there a way for this to work, or will I need to create a form and subform
that are synchronized?
application transfers the data from Excel into Access and runs edits on it.
When importing each row is assigned a record # (auto number field). I have
successfully linked to an Excel worksheet and can update it from a form in
Access. All changes must be made in the original Excel worksheet and logged.
My problem - I want to view the Access table and the Excel worksheet so that
rows requiring updating can be easily found by the record number in the
Access table. I have tried to use a form whose record source is a query
giving the required fields from both the Excel worksheet and the Access
table. But I cannot update/change any data in the form.
Is there a way for this to work, or will I need to create a form and subform
that are synchronized?