2024/12/29 update
Office Page Links
This TH50 task purges dead-expires from membership.aacdb
⇓ 1. Start Task – Backup, Time-In, open files:
⇓ 2. Gather and note statistics:
⇓ 3. Purge Dead-Expires:
⇓ 4. End Task – Time-Out, close files:
⇑ 1. Start Task – Backup, Time-In, open files:
Open treasury.xlsx
> in name-hours > enter Date, Task = TH50, Time-In
Backup membership.accdb to D:\fmaatc\0-mship\mt-bkup folder (for possible restoration should there be an error).
Open membership.accdb
> click Purge button (Purge window opens) – see screenshot taken 2/14/24.
⇑ 2. Gather and note statistics:
FYI – the To-Purge-Year and Purge-Year are set at (Current-Year – 7)
Double click “Total Member Records Query”
> query opens listing entire tblMember
> page-bar shows total records
> note as beginning-total-records
> close query
Double click “To Be Purged Query” > query opens
> page-bar shows total records (i.e. total dead-expires which will be purged)
> note as purge-count
> close query.
Subtract purge-count from beginning-total-records
> note as ending-total-records count
⇑ 3. Purge Dead-Expires:
Double click “Purge Dead Expires Delete Query”
> a warning dialog displays (see TH50-querymsg1 example)
> click No to stop or click Yes to continue
> another warning dialog displays showing records about to-be-deleted (see TH50-querymsg2 example)
> If to-be-deleted does not match purge-count you recorded, there is an error – so click No to start over
> if to-be-deleted matches the purge-count you recorded, then click Yes and the records will be deleted.
> again double click “Total Member Records Query”
> total records of resulting query must equal the noted ending-total-records you calculated.
If counts not equal > there is a problem
> close membership.accdb
> copy backup membership.accdb and reinstate
> open as current membership.aacdb
> ↻ Step 2
If counts are equal > purge was correct
> proceed to step 4
⇑ 4. End Task – Time-Out, close files:
In treasury.xlsx
> in name-hours > enter Time-Out > save > close
> close/minimize other window as needed.
☕ 🙂