Alert User of appoitments

[alguzman]

In my membership database I have popup forms within the main member form. One of the popup forms is a form called phonelog. Within phonelog lets say I might put call this cusotmer back on Wednesday. I would like to click a checkbox that will set an alert for me so the next time I start the dababase on wednesday it will alert me of the phone log entry that I did on Monday.

 

[Pat Hartman]

Create a query that selects all call backs for today.

Select ...
From YourTable
Where CallBackDate = Date();

Then run the query from the AutoExec macro or startup form.

 

[shacket]

Just thinking of all possibilities here...

You may want to consider the idea that for one reason or another (a holiday, your office is closed, etc.) that the database will not be opened on the day the call is requested. You may want to make Yes/No field in the table as to whether the call was followed up and adjust your SQL Statement to get all records equal to or prior to today's date that have not been followed up.

HTH

 

[alguzman]

Thank you, you have been very helpful.