I am teaching myself VBA and have come to a roadblock.
I have an event (task that needs to be completed) every 56 days, with the countdown starting on a specific date. I would like to show a warning when my database main menu starts up. I would like the warning to only show up 5 days prior to the 56th day to remind the users that the task will be due. It would be nice if the pop up or msg box would show the days remaining until the task was due. So at the 53rd day a message would show up that states “5 days until task is due”.
I am not sure how to code any of this, especially an event that will happen every Xth day. If anyone can answer my question without taking up too much of your time I would appreciate it.
Mike
I have an event (task that needs to be completed) every 56 days, with the countdown starting on a specific date. I would like to show a warning when my database main menu starts up. I would like the warning to only show up 5 days prior to the 56th day to remind the users that the task will be due. It would be nice if the pop up or msg box would show the days remaining until the task was due. So at the 53rd day a message would show up that states “5 days until task is due”.
I am not sure how to code any of this, especially an event that will happen every Xth day. If anyone can answer my question without taking up too much of your time I would appreciate it.
Mike