Solved Automating a function

[Rashid]

I want to send a message to students parent on a specific date automatically by setting a date. How can this done by VBA in ms access db

 

[theDBguy]

You can use a Form's Timer to do something like that, but it's probably better if you can use the Window's Task Scheduler.

 

[The_Doc_Man]

Generally, doing it with a simple date in Access means you need to assure that Access is actually running on that date. If the date happens to be a non-work day, that could be a problem. There is also the issue that too much automation would lead to sending the message more than once. Having offered a couple of warnings, the answer is "Yes" you can do that.

The code to actually do this is too complex for me to offer to you - not because I think you wouldn't understand it, but because it becomes a matter of the structure of your database. It becomes too specific to your code and environment, which I don't know, and therefore I cannot build anything for you. But I can offer advice.

FIRST AND FOREMOST - break this down into parts. Divide and conquer on this one.

Part 1 is deciding it is the right time to send the message.
Part 2 is identifying a specific person.
Part 3 is building a message tailored to a specific person.
Part 4 is actually sending the message.
Part 5 is any step needed to prevent an accidental re-send.

Once you get each part figured out, you can then put them together in the proper order.