Not sure if this is possible

  • Thread starter Thread starter Simon Dowse
  • Start date Start date
S

Simon Dowse

Is there anyway to track changes in Access. I have a
database with a few forms linked to a table and I wondered
if there was anyway to build a new form so that if any
controls in a form are changed they are stored.

Any guidance would be greatly appreciated!
 
On my website, see sig below, is a small sample database called AuditTrail
that shows how to track changes in the data. If you mean changes in the
application itself, I'd look at a product like Microsoft Visual SourceSafe.
It is used for version control.
 
Is there anyway to track changes in Access. I have a
database with a few forms linked to a table and I wondered
if there was anyway to build a new form so that if any
controls in a form are changed they are stored.

Any guidance would be greatly appreciated!
Click to expand...

Are you talking about tracking changes to the *data* or changes to the
*structure of your form*? If the former, you can create a log table to
record changes, and write information to it in the AfterUpdate event
of each of your forms. (You won't need to build a new form to do this,
though you will probably want a form to review the log after it's been
created). I don't know any good way to "store" a textbox or combo box
on a form however!
 
Back
Top