Date question

[cthai]

Hello-

How do I generate a pop up that tells me when a "Date Closed" have reach 2 years and need to be deleted. Currenly I have a date function that said "Date_Closed" I would like when the "Date_closed" reach 2 years from the date that a pop up will notify me to delete the record.

 

[PHV]

I have a date function that said "Date_Closed"
Which code and where ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cthai]

Hi PHV-

the date i have in is my query -


2Years: DateAdd("m",+24,[Date Case Closed])

 

[SkipVought]

hi,

Is this decision, "notify me to delete the record," optional?

If not, why not just run a DELETE query to delete ALL such rows, or have them moved to an archive of some sort?

If this question is related to MS Access, then you would get better responses in one of the many MS Access forums like forum701.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[cthai]

Hi Skip,

Sorry if I misunderstand the suggestion you ask. so i have [2Years: DateAdd("m",+24,[Date Case Closed])] in my query I would like a pop up on the front end that notify me when 2Years match the current date... and say " Date reach 2 years record need to be deleted"

 

[PHV]

Something like this ?
Notify: IIf(DateAdd("m",+24,[Date Case Closed])<=Date(),"TO BE DELETED","")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[cthai]

Hi PHV!

Yes! how do I get that to POP UP in the record? like sort of a pop up message

 

[PHV]

I'd use a dedicated form with the apropriate RecordSource for that purpose.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886