please help for date

[ga3la]

hi everybody, i hope everybody good..well i made database with access but i have problem i tried about the way but i didn't found solution, the problem is that i have one table with start date and end date...all i want to creat for warning that one cliente make 6 months after of start date and the other mess 6 months to end date...and i want too like pop up message remind of those warnings...i hope i can find help here, really i need that faver from your all...thanks

 

[HiTechCoach]

See if this example helps:

Reminders

 

[ga3la]

thank you HiTechCoach, that very important...but still nobody reply about what can i do to make table calcule in the start date 6 months and mess 6 months in the end date...thank you

 

[Poppa Smurf]

Have a look at the function DateAdd
For six months after the Start Date would be
me!remind_start=DateAdd("m",6,"Me!start_date")

For six months before the End Date would be
me!remind_end=DateAdd("m",-6,"Me!end_date")

 

[ga3la]

hi Poppa Smurff, thank you for reply me...i tried use that code but don't work with me maybe the problem is me i didn't know how to use it..for that i ask you if you can explain more and how i put it, or upload one exemple for see how to work....i'm sorry for that but really i need your help...thank you for everything

 

[ga3la]

i need to say thanks here too...Pappa Smurf, really you helped me very much...thank you again for your attontion.

 

[Poppa Smurf]

Thank you for the compliment. Thanks also to HiTechCoach for the link to Reminders.