Search results

  1. M

    Solved VBA loop update table with field from another table - multiple criteria

    Thank you, much appreciated! 😊
  2. M

    Solved VBA loop update table with field from another table - multiple criteria

    That worked!! Thank you so much! I wanted to save this data into table1 as it's going to be useful in the future. DLookup is a great idea too, but I went with the recordset approach. Thanks again!
  3. M

    Solved VBA loop update table with field from another table - multiple criteria

    Correct! This means each school can only accept ONE new student. I was thinking of adding a Yes/No field or a checkbox in Table_2 where it gets updated with a "Yes" each time a school is occupied. That way I can add a third condition where a student cannot be sent to a school with a checked off...
  4. M

    Solved VBA loop update table with field from another table - multiple criteria

    Thank you! The thing is I'd like to update the table one record at a time. The reason being I cannot use a School Name more than once; two students cannot be sent to the same school. There's more to the table but unfortunately I cannot reveal more info. Hope that helps!
  5. M

    Solved VBA loop update table with field from another table - multiple criteria

    Hi all, I am quite new to VBA and in need of help. I have two tables: Table_1 and Table_2. Table_1 Student Name Current School Future School Age School Max Age Residence Area School Area Richard Bell Little Angels 3 Erindale Table_2 School Name School Max Age School Area St John...
Top Bottom