B
Bob
Two tables "tblEmployee" and "tblEmployeeHistory".
Each table has identical fields. The tblEmployee has only one record
per employee and the other holds all archived edits.
Each field on the form "frmEmployee" detects a change (BeforeUpdate)
and checks a corresponding box (hidden on the form).
frmEmployee then detects a change (BeforeUpdate) and...
1.) Updates a single ModifiedDate field on the form
2.) Appends the current record to the tblEmployeeHistory table
3.) Updates the tblEmployee table to clear the check boxes
I am currently able to query a date range and get records from the
tblEmployeeHistory table and populate a report where I put a checkbox
next to each field that has been modified. Works fine BUT...
Ideally I would like to simply list just those fields that have a
check and not all of the fields whether the individual field has been
modified or not.
Does anyone know how I could accomplish this?
I wonder if I could use vba/DAO to step through the EmployeeHistory
table rows w/ date range criteria looking for a check (-1). If it
finds a check, grab the field name, value, mod user, mod date and
append to a temp table that I could use in the report.
Is this possible or just wishful thinking?
Thanks in advance!
Bob
Each table has identical fields. The tblEmployee has only one record
per employee and the other holds all archived edits.
Each field on the form "frmEmployee" detects a change (BeforeUpdate)
and checks a corresponding box (hidden on the form).
frmEmployee then detects a change (BeforeUpdate) and...
1.) Updates a single ModifiedDate field on the form
2.) Appends the current record to the tblEmployeeHistory table
3.) Updates the tblEmployee table to clear the check boxes
I am currently able to query a date range and get records from the
tblEmployeeHistory table and populate a report where I put a checkbox
next to each field that has been modified. Works fine BUT...
Ideally I would like to simply list just those fields that have a
check and not all of the fields whether the individual field has been
modified or not.
Does anyone know how I could accomplish this?
I wonder if I could use vba/DAO to step through the EmployeeHistory
table rows w/ date range criteria looking for a check (-1). If it
finds a check, grab the field name, value, mod user, mod date and
append to a temp table that I could use in the report.
Is this possible or just wishful thinking?
Thanks in advance!
Bob