Create a Class Schedule Table - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Create a Class Schedule Table

Ronald de Boer

4 years ago

Hi,

I have been attempting to create a form with some complex VBA code (for me at any rate) in an event to create add the dates to the table (image supplied below) with no success.

I need to create a table which has a fixed number of classes. In my 1st case there are 60 classes. These classes occur in a known and repeatable sequence.

The sequence is a repeating Monday and Wednesday or Tuesday Thursday (Attached image shows a Tuesday/Thursday) but with the complication of some 3 Saturdays and the added complication where a class occurring on a Public holiday that class then starts on the next Tuesday Thursday.

My uploaded image shows a Tuesday/Thursday Schedule

I repeat the sequence of Tuesday/Thursday and the intermittent Saturday's is known and fixed.
How do I go about creating a table with the dates associated to these Monday,Wednesday and Saturday classes obviously with a Parameter asking what is the date of the 1st class?

Is there a easier way to update these dates with multiple queries?

Thankyou in advance.

Ron de Boer

	Adam Schwanz @Reply 4 years ago
I can't think of a beginner level way to do this, especially with intermittent saturdays. So the VBA way I would probably use a For Next Loops or a recordset. If you know that the first one for example is going to be a tuesday, and the next one is going to be 2 days later (thursday), you should be able to add all the records based on how many days they are away from the first date.

	Scott Axton @Reply 4 years ago
Like Adam said I don't see any viable solution just using queries either. Check out the Work Days video. Especially the extended cut. After that one go to the Next Appointment video. Between those two it should get you pretty far down the road to what you are wanting to do.

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

Next Unseen

New Feature: Comment Live View