Recent content by tamraght

  1. T

    Add records based of the days and date range entered.

    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...
  2. T

    Add records based of the days and date range entered.

    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.
  3. T

    Add records based of the days and date range entered.

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

    Add records based of the days and date range entered.

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

    Add records based of the days and date range entered.

    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...
  6. T

    Add empty rows in a report

    Yes It did, thank you so much and also to @bastanu and @arnelgp for the help. You guys are Amazing.
  7. T

    Add empty rows in a report

    Thank you so much for your effort and your time. I'm still a beginner in VBA. I tried to apply your code in my report, but I was getting an error. So I just used the Union All Method And I think so far it does what I need it to do. Thanks again,
  8. T

    Add empty rows in a report

    Thank you all for your replies and all the attachements you sent. Using the Union All method I was having this error as it is shown in this screenshot, and I don't know why. Here is the SQL Code: SELECT PRINT_LIST_UNION1.* FROM PRINT_LIST_UNION1 UNION ALL SELECT TOP 25 PRINT_LIST_UNION2.*...
  9. T

    Add empty rows in a report

    Hello Friends, I have a report that prints out the attendance sheet with a list of students enrolled in that class. In many cases, students enroll after the class already started. So, we would have to print another sheet and copy the previous attendance data manually. I was looking for a...
Top Bottom