creating an archive of data

[Guest]

I am trying to setup a database that would accept various pieces of data via
a form with many subforms which will in turn store the data in multiple
tables. The tables are all linked with a one-to-many relationship back to
the the main tables primary key.

This part is working fine...one of my issues comes from when I try to pull
the data back together for another form or report. The form is not that big
a deal as I can always make a GOTO button on the form but that is not my
ideal solution.

Ideally what I would like to achieve is when a user comes back and wants to
make a modification, they would open a similar form that has a parameter
query as it's source. This way the specfic record they wish to view is easy
for them to access. ...I am still trying to figure out how to pull these
together in another post as I will need this to make my reports work I think


The topic of this post is once I figure out how to get the data together
again, "How do I get all the data into an archive table." For this my idea
is I would like the record (including all the subform data) to be placed into
another archive table when a user opens the modify form. I am even OK with
keeping it in the same tables and perhaps just making a clone of the data and
at some point run a query to move the data all at once into an archive but
not sure how to do that either. Anyway I am not finding how to make a clone
of the original data so that I can track all changes to the fields. Any
ideas are appreciated!

 

[Guest]

Hi Grasshopper,

The topic of this post is once I figure out how to get the data together
again, "How do I get all the data into an archive table." For this my idea
is I would like the record (including all the subform data) to be placed into
another archive table when a user opens the modify form.

See is this article is what you need:

Creating an Audit Log
http://allenbrowne.com/AppAudit.html

This one might also be helpful:

Archive: Move Records to Another Table
http://allenbrowne.com/ser-37.html


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________