Search results

That is ont he right track of what I am looking the colors to do and I did manage to get that far as well. But I really want that based on if a radio button is marked, then a text box will change colors.

Yes I did download it. I looked at it again, just now too. I was not able to enter any new students, but the dropdown on the courses is nice. And No I don't know how to break and single step the code

I don't know what that form is supposed to be doing. I would have to say that no, that isn't what I was aiming at. I do appreciate your help though. I think I'm well over my head with this one. :) programming really isn't my thing. Before I post on a different problem, maybe you can help...

again, thank you for looking at this. If this proves to be taking too much of your time, I totally understand.

here it is again with a different compression setting.

I have winzip pro 11.1 and it's fine on my machine.

here it is again

sure, there is only dummy info in there now. The original tables are tblCertPrograms, tblClassData, tblStudents The tables I tried on your help are tblClasses, tblStudentsClasses, tblClassStudentMerge The forms are Form1 = main form frmStudentMaintenance = entering student data I just tried...

Yes and yes.

I have a form (Students). I enter First, Last names, Enroll date, and a drop down to select the program. My goal was to have all classes assigned based upon what program was selected. This part is over my head. I am now thinking to have a new section on form Students with all classes listed...

I'm in new territory here... How does the data get into this new table? I did link the 2 autonumber fields through the relationship window

Just so I'm on the same page here... This class table - the field names should be each class, then the records will be the student number?

Continuous form mode? I'll have to look that up as I haven't heard that before. I will say that originally that is how I had the form laid out. A Student form with course subform. But I couldn't figure out how to link the classes with the student without manually enterting the classes. I'd...

I have all the data I need laid out in a different table, but I need it to auto populate to this first table. I have tried numerous times and can't get it to work. I have 6 main programs with up to 10 classes in each program. I have a form setup to add new students, but I also need this table...

I have run into major problems with lookup fields before. I have not seen that liunk before, so thank you, but I'm still at a loss of what to do.

I have a table named: tblStudents I have a fields named Course and Basic Code Enforcement Within the properties for Basic Code Enforcement, I have this as a Lookup row source: SELECT IIf([Course]="Residential Inspector Multi-Discipline",1,"") AS Expr1 FROM tblStudents; It is also set as...

Changed goal slightly I revamped my form a bit and thus have changed what I need to do slightly. I was not getting all the data I needed to be linked correctly on a subform, so I scrapped that idea. What I did was to add each class as a field on the tblStudents. I am now able to have all...

I'm not sure is this is the right section or not, but here goes... I am trying to create a db for 6 class programs, each program has from 7-10 individual classes. I have tbls created and a form(frmStudentMaintenance) for new student entry that enters or modifies the student data. I also have...