Search results

Hi There, I have three tables: Students STUDID (pk) txtFname txtLname etc. Classes CLASSID (pk) txtClassName txtClassRoom etc. Student_Class (join table) STUD_CLASSID (pk) fk_StudID fk_ClassID I am trying to set up a form which shows a "Class" and a subform which I can add a student to it...

Hi There, I'm sure there is an easy way to do this but I have not clue. I have three tables: Students STUDID (pk) txtFname txtLname etc. Classes CLASSID (pk) txtClassName txtClassRoom etc. Student_Class (join table) STUD_CLASSID (pk) fk_StudID fk_ClassID On my Class form when assigning...

Hi There, I'm trying to add a record(s) in a join table but I'm not sure what is the best way to do this. Here are my tables: tblStudents StudID (pk) txtFname txtLname etc tblClasses ClassID (pk) txtClassName txtClassCode etc tblStud_Class StudClassID (pk) fk_StudID fk_ClassID I would like...

On my form I have a "New Record" button which works fine. However, the people I am working for ONLY want that button enabled IF they are on the last record. Apparently their issue is, if they are on record # 123 and press the "New" button it throws them off if the "New" record is, for example...

Hi There, Yes, still a newbie AND trying to change somebody else work. I am working with Access 2003. I have a new record button on a form and I can get it to add a new record but I can't get it to display. However, if I close the form and re-open it there is the new record, what am I doing...

Hi There, Newbie here, trying to help out a school who have MS Access 2003. I usually program in C+. They want a button to add a new record however I am getting the error mentioned in the title above. The table shows: DailyReportID autonumber (Primary Key) fkStudCourID number (derived from...

Hi There, Yes, I am a newbie especially because I have been tasked with updating an old MS ACCESS 2003 database. The school wants to add a record to a students file by clicking on a button which will add a new record but also increment the daily record number. In other words, when adding a...