Moving Scheduled Events - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Moving Scheduled Events

James Hopkins

2 years ago

Hey Richard and the Crew, I have an 'Reschedule Event Form' that I use to reschedule Event forward or back, Days or Months. But I am trying to figure out how to 'Move All Unclosed Events' or 'Only Move This One' using Button. I wondering if I should create a separate Table for Recurring Event Table for the Events that are created by the Original Event when the Event is Saved?

	Alex Hedley @Reply 2 years ago
What determines an Unclosed Event?

	James Hopkins OP @Reply 2 years ago
I have a 'IsCompleted' , 'IsSkipped', or 'IsScheduled' Yes/No Fields and a Status Field in the Table.

	James Hopkins OP @Reply 2 years ago
I just trying figure out if 'Move Only this One' or 'All Unclosed Events' that are scheduled recurring for Client, Equipment, or Vehicle that were created by the Original Event that was Generated by it. How to move Forward or Backwards for that Client, Equipment, or Vehicle? Should create an separate Table to store the Recurring Events that are Children Record from the Parent Record?

	James Hopkins OP @Reply 2 years ago
So I could use the Foreign ID in children Table to do the Move One or All.

	James Hopkins OP @Reply 2 years ago
Hey Guys, I figured out the Recurring Events that are Child Records of the Parent Record. The problem that I having is how to move all the Recurring Events Start Date by the Number of Day(s), Month(s), and Year(s) or the Date selected in the Date Picker.

	Alex Hedley @Reply 2 years ago
DateDiff

	James Hopkins OP @Reply 2 years ago
Alex, the problem I running into is how to deal with if the Scheduled Date Interval is on an certain 'Weekday' or 'Month'. I been trying to DLookup the Interval in the Schedule Table. But the problem I also running into is also trying to DLookup the 'FieldHelperID' that corresponds with the ID Number in the Schedule Table for the Interval Number is. What's the best way to do this correctly?

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

Next Unseen

New Feature: Comment Live View