Search results

  1. D

    Qry within a tables field property

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

    Qry within a tables field property

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

    Qry within a tables field property

    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...
  4. D

    Qry within a tables field property

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

    Qry within a tables field property

    here it is again with a different compression setting.
  6. D

    Qry within a tables field property

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

    Qry within a tables field property

    here it is again
  8. D

    Qry within a tables field property

    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...
  9. D

    Qry within a tables field property

    Yes and yes.
  10. D

    Qry within a tables field property

    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...
  11. D

    Qry within a tables field property

    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
  12. D

    Qry within a tables field property

    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?
  13. D

    Qry within a tables field property

    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...
  14. D

    Qry within a tables field property

    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...
  15. D

    Qry within a tables field property

    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.
  16. D

    Qry within a tables field property

    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...
  17. D

    Command button that will auto enter fields into table

    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...
  18. D

    Command button that will auto enter fields into table

    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...
Back
Top Bottom