superseded table/file

[wheather girl]

I am using office 2007. I thought i read somewhere (but now i cant find it)
that once you have set up a table or tables and linked them to a primary
table, that somehow if there are records that u dont need anymore or there
are other records that u need to add to supersede that record that u can send
it to a superseded table or section, not sure where it goes but i believe
you can send that unwanted record to a certain place where you can store it,
so if you need to look it up later in the future the history of that record
is still there and not deleted but stored in that area/space/section/table ?
what ever it is called. Can someone help me and tell if what i read is
correct and how do i go about doing this.

thanks

 

[NAS]

You mean an archive table? See
http://office.microsoft.com/en-us/access/HA010345681033.aspx

 

[Tom van Stiphout]

On Fri, 2 Oct 2009 05:56:02 -0700, wheather girl

That is often called an Archive table, and there is nothing built-in
to Access to support that, but you can certainly write your own code.
Here is an article about that topic:
http://allenbrowne.com/ser-37.html

-Tom.
Microsoft Access MVP

 

[wheather girl]

yes an archive table, where and how do i do this?

 

[wheather girl]

Thanks Tom I will have a look at your the article.

 

[wheather girl]

Tom, I had a look at the link, and thankyou it seems that it is possible to
do this...the only problem is i really just dont know where to start in order
to accomplish this, I am not so advanced access. Are u able to help with
process ex. where to start? where do I look for it? which buttons etc to use
and where do i write this code?