Add records based of the days and date range entered. (1 Viewer)

[tamraght]

Hello friends,

I have a form where I choose the class code, the days of the week when the class will be scheduled, and the date range when this class will start and end. So, that the program will add all the class schedule, each record will have the class code, and the class date.

Here is a screenshot of the program.

Could anyone tell be how the VBA code or the query would look like?

and lastly, I want to thank everyone who supports and participates in this forum. I feel lucky to finally find a place where I can get the support I need.

Thank you,

 

[theDBguy]

Can you show us the structure of the table where you want to add these new records?

 

[tamraght]

Can you show us the structure of the table where you want to add these new records?

Here is a screenshot of the table where the records will be added to.

 

[theDBguy]

Thanks. What is the last column for?

 

[tamraght]

Thanks. What is the last column for?

That is for cancelation in case a class is canceled. We modify it manually.

 

[theDBguy]

That is for cancelation in case a class is canceled. We modify it manually.

Okay, so I am thinking you don't need that table at all. If you must, you can have a table of cancelled classes instead.

What would you use this table for?

 

[tamraght]

Okay, so I am thinking you don't need that table at all. If you must, you can have a table of cancelled classes instead.

What would you use this table for?

To add class dates. So whenever I will be adding attendance data to the database, I will choose the class code (ID_GROUPE), so I will be given the dates that this class have in its schedule.

 

[theDBguy]

To add class dates. So whenever I will be adding attendance data to the database, I will choose the class code (ID_GROUPE), so I will be given the dates that this class have in its schedule.

For attendance recording, you don't need all that information. That table structure is not normalized. I don't even see a column to record which student attended or how many students were present.

It might help if you can review the table structure or data model for a class and students database. Somebody here might have a link where you could find a sample or a template. I'll see if I can find any.

 

[theDBguy]

Here's one potential example.

databaseanswers.org - databaseanswers Resources and Information.

databaseanswers.org is your first and best source for all of the information you’re looking for. From general topics to more of what you would expect to find here, databaseanswers.org has it all. We hope you find what you are searching for!

www.databaseanswers.org

 

[tamraght]

Thank you for all the information you provided. I will diffinitely look at it and try to rearrange my database.

At this moment, I just need a code or SQL, so I can use it to add mutliple records, each one will have the Class code I choose, a date that comes in those days of the week and is between the date range we chose.

Thank you so much all.