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 |
#11
|
|||
|
|||
purpose of subform?
i'm a hs teacher who took on a project over break (not paid). trying to use
access to streamline teacher recommendation process at our school. right now each teacher has to fill out a paper form for each student to select which subjects he/she recommends for the coming year. then guidance has to gather all the paper forms and figure out which student was recommended for which class(es), all this in a short turnaround timeframe. needless to say its not very efficient so i volunteered to try and create a program to do this so. interface to show list of students and subjects, allow teacher to select student and subject, then run reports for guidance. its turning out to be a bigger task than i thought (always is but i'm getting close "Gina Whipp" wrote: Oops forgot about that... You can't use the wizard to link them... Go to Properties of the Subform LinkChildField = NameOfStudentIDField in tblStudentSubjects LinkMasterFields = NameOfComboBox on Main form Student ID is blank because the form is not linked AND you need to create a Relationship between the tables with Cascading Updates set to Yes... You know I'm starting to get the impression I am doing your classwork for you. Is this an assignment? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... Gina, 1. - 3. The combo box on the Main Form should be unbound. You do not need to save the value for anything. got it. 4. Subform should be in continuous view and attached to the Main Form (Link Fields) StudentID. Then the field Student Subject should be a combo box using the tblSubjects as the Record Source and the value should be bound to the ssStudentSubject. -how do i (or when in the wizard do i) link the subform to the main form? -tried setting "Source object" for subform to main form but when i try to link child/master fields, get message stating "cant link unbound forms" tried all above 1)new record is created in tblStudentSubject w/ correct subject from cbo in subform but 2)studentID is blank. |
#12
|
|||
|
|||
purpose of subform?
Okay, well that explains it... Unfortunately, Access does have a bit of a
'learning curve' that isn't obvious right out of the box. You have few more days until break is over... you should make it! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... i'm a hs teacher who took on a project over break (not paid). trying to use access to streamline teacher recommendation process at our school. right now each teacher has to fill out a paper form for each student to select which subjects he/she recommends for the coming year. then guidance has to gather all the paper forms and figure out which student was recommended for which class(es), all this in a short turnaround timeframe. needless to say its not very efficient so i volunteered to try and create a program to do this so. interface to show list of students and subjects, allow teacher to select student and subject, then run reports for guidance. its turning out to be a bigger task than i thought (always is but i'm getting close "Gina Whipp" wrote: Oops forgot about that... You can't use the wizard to link them... Go to Properties of the Subform LinkChildField = NameOfStudentIDField in tblStudentSubjects LinkMasterFields = NameOfComboBox on Main form Student ID is blank because the form is not linked AND you need to create a Relationship between the tables with Cascading Updates set to Yes... You know I'm starting to get the impression I am doing your classwork for you. Is this an assignment? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... Gina, 1. - 3. The combo box on the Main Form should be unbound. You do not need to save the value for anything. got it. 4. Subform should be in continuous view and attached to the Main Form (Link Fields) StudentID. Then the field Student Subject should be a combo box using the tblSubjects as the Record Source and the value should be bound to the ssStudentSubject. -how do i (or when in the wizard do i) link the subform to the main form? -tried setting "Source object" for subform to main form but when i try to link child/master fields, get message stating "cant link unbound forms" tried all above 1)new record is created in tblStudentSubject w/ correct subject from cbo in subform but 2)studentID is blank. |
#13
|
|||
|
|||
purpose of subform?
Gina,
thx to you more progress i ended up putting cboStudent in the subform. when i select a student and subject, it creates a new record in tblStudentSubject correctly. interface issue: the cboStudent and cboSubject show up in column format on the subform. is there a way to format to make it more aesthetically pleasing i.e. some separation between the two cbo's? "Gina Whipp" wrote: Okay, well that explains it... Unfortunately, Access does have a bit of a 'learning curve' that isn't obvious right out of the box. You have few more days until break is over... you should make it! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... i'm a hs teacher who took on a project over break (not paid). trying to use access to streamline teacher recommendation process at our school. right now each teacher has to fill out a paper form for each student to select which subjects he/she recommends for the coming year. then guidance has to gather all the paper forms and figure out which student was recommended for which class(es), all this in a short turnaround timeframe. needless to say its not very efficient so i volunteered to try and create a program to do this so. interface to show list of students and subjects, allow teacher to select student and subject, then run reports for guidance. its turning out to be a bigger task than i thought (always is but i'm getting close "Gina Whipp" wrote: Oops forgot about that... You can't use the wizard to link them... Go to Properties of the Subform LinkChildField = NameOfStudentIDField in tblStudentSubjects LinkMasterFields = NameOfComboBox on Main form Student ID is blank because the form is not linked AND you need to create a Relationship between the tables with Cascading Updates set to Yes... You know I'm starting to get the impression I am doing your classwork for you. Is this an assignment? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... Gina, 1. - 3. The combo box on the Main Form should be unbound. You do not need to save the value for anything. got it. 4. Subform should be in continuous view and attached to the Main Form (Link Fields) StudentID. Then the field Student Subject should be a combo box using the tblSubjects as the Record Source and the value should be bound to the ssStudentSubject. -how do i (or when in the wizard do i) link the subform to the main form? -tried setting "Source object" for subform to main form but when i try to link child/master fields, get message stating "cant link unbound forms" tried all above 1)new record is created in tblStudentSubject w/ correct subject from cbo in subform but 2)studentID is blank. |
#14
|
|||
|
|||
purpose of subform?
Mike,
Good to know 'cause it's almost midnight here and I need my rest ) Go into design mode of the form (the little blue triangle and move the fields around/over/up/down... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... Gina, thx to you more progress i ended up putting cboStudent in the subform. when i select a student and subject, it creates a new record in tblStudentSubject correctly. interface issue: the cboStudent and cboSubject show up in column format on the subform. is there a way to format to make it more aesthetically pleasing i.e. some separation between the two cbo's? "Gina Whipp" wrote: Okay, well that explains it... Unfortunately, Access does have a bit of a 'learning curve' that isn't obvious right out of the box. You have few more days until break is over... you should make it! -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... i'm a hs teacher who took on a project over break (not paid). trying to use access to streamline teacher recommendation process at our school. right now each teacher has to fill out a paper form for each student to select which subjects he/she recommends for the coming year. then guidance has to gather all the paper forms and figure out which student was recommended for which class(es), all this in a short turnaround timeframe. needless to say its not very efficient so i volunteered to try and create a program to do this so. interface to show list of students and subjects, allow teacher to select student and subject, then run reports for guidance. its turning out to be a bigger task than i thought (always is but i'm getting close "Gina Whipp" wrote: Oops forgot about that... You can't use the wizard to link them... Go to Properties of the Subform LinkChildField = NameOfStudentIDField in tblStudentSubjects LinkMasterFields = NameOfComboBox on Main form Student ID is blank because the form is not linked AND you need to create a Relationship between the tables with Cascading Updates set to Yes... You know I'm starting to get the impression I am doing your classwork for you. Is this an assignment? -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... Gina, 1. - 3. The combo box on the Main Form should be unbound. You do not need to save the value for anything. got it. 4. Subform should be in continuous view and attached to the Main Form (Link Fields) StudentID. Then the field Student Subject should be a combo box using the tblSubjects as the Record Source and the value should be bound to the ssStudentSubject. -how do i (or when in the wizard do i) link the subform to the main form? -tried setting "Source object" for subform to main form but when i try to link child/master fields, get message stating "cant link unbound forms" tried all above 1)new record is created in tblStudentSubject w/ correct subject from cbo in subform but 2)studentID is blank. |
#15
|
|||
|
|||
purpose of subform?
Gina,
hope you slept well Go into design mode of the form (the little blue triangle and move the fields around/over/up/down... -when i go into design mode, the cbo's show up as independent boxes inside the subform which i can move all around (no blue triangles?) but no matter they still show up as side-by-side columns in form view. -also i think there will be less incorrect entries if i add a cmdBtn to allow user(teacher) to confirm selection. else, as soon as a class is selected its written to tblStudentSubject which i believe will lead to alot of invalid entries. is that difficult to change? |
#16
|
|||
|
|||
purpose of subform?
Mike,
Like a rock!!! 1. Are you using Access 2007? Maybe you said but I missed that. In earlier versions to get to design mode you clicked a blue triangle looking button. If Access 2007, then you probably have to UNgroup them to get them to move independently of each other. I THINK this can be done by right-clicking on one of the boxes and select 'ungroup'. If that doesn't work I'll have to open my Access 2007 and have a look. Also, if you are using Datasheet View then they will always be side-by-side no matter where you move them. 2. Then by all means add the button to add a new record. You know your users better then anyone. -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... Gina, hope you slept well Go into design mode of the form (the little blue triangle and move the fields around/over/up/down... -when i go into design mode, the cbo's show up as independent boxes inside the subform which i can move all around (no blue triangles?) but no matter they still show up as side-by-side columns in form view. -also i think there will be less incorrect entries if i add a cmdBtn to allow user(teacher) to confirm selection. else, as soon as a class is selected its written to tblStudentSubject which i believe will lead to alot of invalid entries. is that difficult to change? |
#17
|
|||
|
|||
purpose of subform?
Gina,
i'm using 2003. 2. Then by all means add the button to add a new record. You know your users better then anyone. since the cbo's are bound to fields in tblStudentSubject, when i select a cboStudent and then select a cboSubject, it creates a new record in tblStudentSubject which is what i want. however, i'd like to add a confirmation step. after user selects subject use a messageDialogBox to confirm entry. -i imagine i have to use VBA something like Private Sub cboSubject_click MessageDialogBox.show("Confirm entry") if yes, then add record to table w/ selected item in both cbo's else, reset cbo's w/out writing a new record End Sub will that do it? |
#18
|
|||
|
|||
purpose of subform?
Yes, that will work...
-- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... Gina, i'm using 2003. 2. Then by all means add the button to add a new record. You know your users better then anyone. since the cbo's are bound to fields in tblStudentSubject, when i select a cboStudent and then select a cboSubject, it creates a new record in tblStudentSubject which is what i want. however, i'd like to add a confirmation step. after user selects subject use a messageDialogBox to confirm entry. -i imagine i have to use VBA something like Private Sub cboSubject_click MessageDialogBox.show("Confirm entry") if yes, then add record to table w/ selected item in both cbo's else, reset cbo's w/out writing a new record End Sub will that do it? |
#19
|
|||
|
|||
purpose of subform?
On Wed, 31 Dec 2008 09:06:01 -0800, mike
wrote: -i imagine i have to use VBA something like Private Sub cboSubject_click MessageDialogBox.show("Confirm entry") if yes, then add record to table w/ selected item in both cbo's else, reset cbo's w/out writing a new record End Sub I'd actually use the Form's BeforeUpdate event. HOWEVER... in my experience this kind of confirmation really ends up being an annoyance. Users will get to the point that they thoughtlessly just choose OK (and then ask you to fix up the damage they've done), and it will just waste their time. "Yes, I wanted to make an entry, that's why I opened the blasted form!!!" -- John W. Vinson [MVP] |
#20
|
|||
|
|||
purpose of subform?
Gina, John (Vinson), and Allen (Browne):
wanted to say thank you for your gracious help. thx to Allen and John i was able to "properly" construct a DB using relationships, and thx to Gina for helping me bring it all together. john: i agree with your point about the confirmation button. going to omit it for now. as a teacher, i have an appreciation for people who are willing to share his/her knowledge for the sake of helping all in all i've got what i set out the create. could use a few bells and whistles but i can fiddle with it now. Regards. Mike "Gina Whipp" wrote: Yes, that will work... -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II "mike" wrote in message ... Gina, i'm using 2003. 2. Then by all means add the button to add a new record. You know your users better then anyone. since the cbo's are bound to fields in tblStudentSubject, when i select a cboStudent and then select a cboSubject, it creates a new record in tblStudentSubject which is what i want. however, i'd like to add a confirmation step. after user selects subject use a messageDialogBox to confirm entry. -i imagine i have to use VBA something like Private Sub cboSubject_click MessageDialogBox.show("Confirm entry") if yes, then add record to table w/ selected item in both cbo's else, reset cbo's w/out writing a new record End Sub will that do it? |
Thread Tools | |
Display Modes | |
|
|