How to put a reminder/notification for a expiring date field?

[Amuse]

I am making a simple form.
Client information and each client has a expiration date.
I would like a reminder, like 3 months from the date of expiry.
The reminder can be a form of a form popup when someone opens the form, or an email notification to an email address, or another way.



I'm not that advanced in programming, but is there any way to do this and any code examples?

Thank you

[Robeen]

Hi Amuse,
It is certainly possible to display all records in a table that are within 3 months of the expiration date when your Form is opened.
Can you give me some details [Field names etc] about the Table in which the Client information is stored?
Or, doo this:
1. Create a Query that displays all Clients whose expiration date is three months or less in the future.
2. Create a Form based on that Query.
2b. In the Property Sheet | Format Tab - you can make your 'Default View' - 'Datasheet' - if you want to see all Clients in one sheet.
Otherwise the Form will open and display one Client at a time.
It's up to you.
3. In the On Open Event of your Original Form - create Code using the Code Builder.
In the Form's Design Mode - open the Property Sheet - Click the Event Tab - Click in the On Open row - Click the [...] to the right - Select 'Code Builder'.
4. In the Subroutine that is created, type in something like this:
DoCmd.OpenForm, "YourFormNameHere"
Where I have "YourFormNameHere" - Type in the name of the Form you created in Step 2.

Now - when you run the original Form - the second Form will open and display the results of the query you created in Step 1.

This helpful page has some more information on 'DoCmd':
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

I hope this helps!