Auto Archiving

[Hulk]

I have a database which i have put a yes/no field to show when a tast
has been completed. I wish to have something that will auto archive the
record when exiting so that the record will no longer be visble but will be
stored for future reference. I am using Access 2002.

Any help would be helpful.

Thanks in Advance

 

[Jim Allensworth]

I have a database which i have put a yes/no field to show when a tast
has been completed. I wish to have something that will auto archive the
record when exiting so that the record will no longer be visble but will be
stored for future reference. I am using Access 2002.

Any help would be helpful.

Well, you are in effect archiving if you don't allow the records to be
seen. Just use a WHERE clause to show only tasks that have *not* been
completed. This will be much easier to deal with now and in the
future.

- Jim

 

[Reggie]

Hulk, Base your form on a query that is based on the table you are
currently using. In the query under the Yes/no field on the criteria line
type in 0(zero). Now only the records that have not been checked will be
displayed on your form. Should you want to see the others, either open the
table directly or remove this criteria from the query.