Rescheduling Events - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Rescheduling Events

James Hopkins

3 years ago

Hey Richard, I am trying to figure out how to correctly Reschedule Event Start Date by using Buttons: One Day to Six Days, One Week to Three Weeks, and One Month to Three Months. Also, if I wanted to use an Calendar Box to select The Date to reschedule to Start Date of the event. I tried this VBA Code:

Private Sub BtnMoveStartDateOneDay ()
If isnull (ScheduleID) then exit Sub
Docmd.runsql "Update ScheduleT set ScheduleStartDate = ScheduleStartDate + 1 WHERE ScheduleID=" & ScheduleID

End Sub

	James Hopkins OP @Reply 3 years ago
Should I use "DateAdd" function the add the Number of Days to the Scheduled Start Date to get the "Days, Weeks, or Month"?

	Richard Rost @Reply 2 years ago
What you got should work fine to add 1 day, and if you want to do weeks, just add 7 days. Months are a little more tricky. For that, I would use the DateAdd function.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View