Search results

Hi Static, Thanks for chipping in! Probably first best to point out I may have mixed labels here between Classes and Lessons which are identical - sorry if that led to confusion. The basic structure will be Course with a one to many relationship with Lessons. In a sense Lesson 4 did replace...

Hi Grumm, Thanks for getting back to me! That seems to make sense. However, I'm unsure how I would then make apply this. I can follow the code, but not sure where I can make use of it. My end goal is to have a Courses form, with a subForm listing Lessons with a lesson status field that can be...

Hi Minty, Thanks for chipping in :) I'm a little unsure of what you mean regarding storing the Lesson Number as a fixed field for that course group? Think I follow you up to there though. Thanks, J

Hi Mark, Thanks for getting back to me! As I mentioned, I'm trying to learn so still a little shaky on some of the core concepts but I've been working through tutorials recently and I think get most of the code you kindly sent over. However, I have a few questions to help me get a better...

Hi Mark, Thanks for getting back to me! There are unfortunately a number of reasons in my business context why knowing the exact lesson number on each date is needed, and being able to update that data in a way that affects all subsequent lessons easily would be good. - I'd like to use that...

Hello all! I'm trying to learn VBA and Access and to do so I'm in the process of developing a training management database. The area I am currently working on relates to my tblTrainingCourses tblTrainingClasses. As you can imagine, each course can have many classes associated with it...