If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help with Combo boxes, I think???
I am a relative newcomer to Access. With the help of a few experts on this
forum, I successfully managed to build a database a year ago for a project and need to do another one but can't remember a lot of what I learnt last year...! I would really appreciate some more help. I have a table with class details. There are several different fields (eg day, time, venue, teacher, subject, level). I have another table and form with the student details. I now need to go to each student record and enter the classes they attend (i have the classes as a subform on the student details form). From the class subform on the student record, I need to be able to go to ClassID and get a drop down box that will show me the full details for each class eg ClassID 1 = Monday, 10am, Maths, Room 3, Mrs Brown, level 2 At the moment, I go to the ClassID and just get a drop down box with a list of numbers which are meaningless. I know I manged this last year but can't for the life of me remember how....!!! Sadly I don't have much time to get this database built, and I am sure it is an easy solution... Thanks Edith -- thank you for your help |
#2
|
|||
|
|||
help with Combo boxes, I think???
Edith
If you built one last year, have you looked at it to see how you handled it then? Regards Jeff Boyce Microsoft Office/Access MVP "edith" wrote in message ... I am a relative newcomer to Access. With the help of a few experts on this forum, I successfully managed to build a database a year ago for a project and need to do another one but can't remember a lot of what I learnt last year...! I would really appreciate some more help. I have a table with class details. There are several different fields (eg day, time, venue, teacher, subject, level). I have another table and form with the student details. I now need to go to each student record and enter the classes they attend (i have the classes as a subform on the student details form). From the class subform on the student record, I need to be able to go to ClassID and get a drop down box that will show me the full details for each class eg ClassID 1 = Monday, 10am, Maths, Room 3, Mrs Brown, level 2 At the moment, I go to the ClassID and just get a drop down box with a list of numbers which are meaningless. I know I manged this last year but can't for the life of me remember how....!!! Sadly I don't have much time to get this database built, and I am sure it is an easy solution... Thanks Edith -- thank you for your help |
#3
|
|||
|
|||
help with Combo boxes, I think???
Hi Jeff,
When I did last year's it was on someone else's pc which I no longer have access to (forgive the pun!), and stupidly I didn't keep a copy for my own learning! -- thank you for your help "Jeff Boyce" wrote: Edith If you built one last year, have you looked at it to see how you handled it then? Regards Jeff Boyce Microsoft Office/Access MVP "edith" wrote in message ... I am a relative newcomer to Access. With the help of a few experts on this forum, I successfully managed to build a database a year ago for a project and need to do another one but can't remember a lot of what I learnt last year...! I would really appreciate some more help. I have a table with class details. There are several different fields (eg day, time, venue, teacher, subject, level). I have another table and form with the student details. I now need to go to each student record and enter the classes they attend (i have the classes as a subform on the student details form). From the class subform on the student record, I need to be able to go to ClassID and get a drop down box that will show me the full details for each class eg ClassID 1 = Monday, 10am, Maths, Room 3, Mrs Brown, level 2 At the moment, I go to the ClassID and just get a drop down box with a list of numbers which are meaningless. I know I manged this last year but can't for the life of me remember how....!!! Sadly I don't have much time to get this database built, and I am sure it is an easy solution... Thanks Edith -- thank you for your help |
#4
|
|||
|
|||
help with Combo boxes, I think???
Edith
If I understand correctly, you have a one-to-many relationship between classes and (enrolled) students. One way to handle this is to use a main form based on the class, and a subform based on the enrolled students. This implies three tables ... tblClass tblStudent trelEnrollment Is this how your data is structured? Regards Jeff Boyce Microsoft Office/Access MVP "edith" wrote in message ... Hi Jeff, When I did last year's it was on someone else's pc which I no longer have access to (forgive the pun!), and stupidly I didn't keep a copy for my own learning! -- thank you for your help "Jeff Boyce" wrote: Edith If you built one last year, have you looked at it to see how you handled it then? Regards Jeff Boyce Microsoft Office/Access MVP "edith" wrote in message ... I am a relative newcomer to Access. With the help of a few experts on this forum, I successfully managed to build a database a year ago for a project and need to do another one but can't remember a lot of what I learnt last year...! I would really appreciate some more help. I have a table with class details. There are several different fields (eg day, time, venue, teacher, subject, level). I have another table and form with the student details. I now need to go to each student record and enter the classes they attend (i have the classes as a subform on the student details form). From the class subform on the student record, I need to be able to go to ClassID and get a drop down box that will show me the full details for each class eg ClassID 1 = Monday, 10am, Maths, Room 3, Mrs Brown, level 2 At the moment, I go to the ClassID and just get a drop down box with a list of numbers which are meaningless. I know I manged this last year but can't for the life of me remember how....!!! Sadly I don't have much time to get this database built, and I am sure it is an easy solution... Thanks Edith -- thank you for your help |
Thread Tools | |
Display Modes | |
|
|