Move a person once it expired

[Dwayne129]

Good morning. I am currently new to Access and a project that I have been working on is a database for people trained and when they expire. Ive played around with it for awhile and cannot figure out how to make the system auto move it after the expire date. If anyone has any ideahow to do this. Please let me know.

Thank you,

Dwayne

 

[healey21]

Welcome to the Forum what do you mean by Auto Move after Expire Date. Do you mean remove the person from the table? I would be very careful around this as if you have related data it will also remove any data that is linked to the person. You loose your history and that's not good.

If you want to hide someone from a list because a date is shown then you can create a query and set the Expire Date field to not show against entries in that Field.

 

[Dwayne129]

Thank you for your reply. So I have two Tables that I have made. One is for "Current active certificates" the other is "expired" is there anyway for me to set it up so where it will move from the Active to the Expired list?

 

[Joe4]

If you want to hide someone from a list because a date is shown then you can create a query and set the Expire Date field to not show against entries in that Field.

Healey21 is giving you some good advice here. The best design is NOT to have two almost identical tables, one for Active and one for Expired, but rather to have a single table and just have an Expired field. It is easy enough to exclude those expired records from queries, forms, reports, as he indicated.

 

[Dwayne129]

How do you go about excludeing these from a document? Is there any way to maybe see if people are close to expiring?

Thanks Hayden

 

[Joe4]

Assuming that your Expiration Date field may be blank (empty), let's say that you wanted to find any records with expiration dates within the next 7 days. You could create a calculated field in a query like this:

ExpireCheck: DateDiff("d",Date(),Nz([ExpireDate],DateSerial(2099,1,1)))

and then put the following Criteria under this calculated field:

Between 1 And 7