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 |
#41
|
|||
|
|||
purpose of subform?
RecordSource: SQL stmt for subform
JOIN (tblTeachers INNER JOIN (tblSubjects INNER JOIN tblStudentSubject ON tblSubjects.SubjectID=tblStudentSubject.SubjectID) ON tblTeachers.[Teacher ID]=tblStudentSubject.TeacherID) ON tblStudents.StudentID=tblStudentSubject.StudentID; ControlSource cboStudent: tblStudentSubject_StudentID "John W. Vinson" wrote: On Tue, 6 Jan 2009 17:16:05 -0800, mike wrote: john, i click new record and when i select a student from the cbo i get the following dialog box: "The object doesnt contain the Automation object StudentID..." which only started happening after i rebuilt my subform using new tables/fields, any idea what's the cause of this? What's the Recordsource for the subform (post the SQL)? What's the Control Source of the combo? My guess is that the combo has a control source that is not a fieldname in the new table. -- John W. Vinson [MVP] |
#42
|
|||
|
|||
purpose of subform?
On Wed, 7 Jan 2009 05:48:01 -0800, mike
wrote: RecordSource: SQL stmt for subform JOIN (tblTeachers INNER JOIN (tblSubjects INNER JOIN tblStudentSubject ON tblSubjects.SubjectID=tblStudentSubject.SubjectID ) ON tblTeachers.[Teacher ID]=tblStudentSubject.TeacherID) ON tblStudents.StudentID=tblStudentSubject.StudentID ; This cannot possibly be complete - a query for this purpose must have a SELECT clause. Please post the entire query (it should start with the word SELECT). You may also want to post the SQL of the RowSource of the combo box. -- John W. Vinson [MVP] |
#43
|
|||
|
|||
purpose of subform?
John,
I recreated the subform and when doing so realized the errors. I'm rolling it out at our staff mtg tomorrow. Cant thank you enough. I learned a lot about access the past 2 wks thanks for the advice "John W. Vinson" wrote: On Wed, 7 Jan 2009 05:48:01 -0800, mike wrote: RecordSource: SQL stmt for subform JOIN (tblTeachers INNER JOIN (tblSubjects INNER JOIN tblStudentSubject ON tblSubjects.SubjectID=tblStudentSubject.SubjectID ) ON tblTeachers.[Teacher ID]=tblStudentSubject.TeacherID) ON tblStudents.StudentID=tblStudentSubject.StudentID ; This cannot possibly be complete - a query for this purpose must have a SELECT clause. Please post the entire query (it should start with the word SELECT). You may also want to post the SQL of the RowSource of the combo box. -- John W. Vinson [MVP] |
#44
|
|||
|
|||
purpose of subform?
On Wed, 7 Jan 2009 16:49:01 -0800, mike
wrote: John, I recreated the subform and when doing so realized the errors. I'm rolling it out at our staff mtg tomorrow. Cant thank you enough. I learned a lot about access the past 2 wks thanks for the advice Good luck! Sure hope you don't encounter the dread "Demo Effect": an app which works perfectly in test fails spectaularly when demonstrated before the High Muck-a-Mucks g. Glad to have been of assistance! -- John W. Vinson [MVP] |
#45
|
|||
|
|||
purpose of subform?
demo went well today. its the first piece of software i've ever created
that's actually being used. teachers liked it b/c it makes their life easier. based on some feedback going to add a few items which is easy to do since you guys taught me to use tables and relationships. regards to you, Allen, and Gina "John W. Vinson" wrote: On Wed, 7 Jan 2009 16:49:01 -0800, mike wrote: John, I recreated the subform and when doing so realized the errors. I'm rolling it out at our staff mtg tomorrow. Cant thank you enough. I learned a lot about access the past 2 wks thanks for the advice Good luck! Sure hope you don't encounter the dread "Demo Effect": an app which works perfectly in test fails spectaularly when demonstrated before the High Muck-a-Mucks g. Glad to have been of assistance! -- John W. Vinson [MVP] |
#46
|
|||
|
|||
purpose of subform?
On Thu, 8 Jan 2009 13:53:42 -0800, mike
wrote: demo went well today. its the first piece of software i've ever created that's actually being used. teachers liked it b/c it makes their life easier. based on some feedback going to add a few items which is easy to do since you guys taught me to use tables and relationships. regards to you, Allen, and Gina high fives and grins all around Glad you got such a good reaction. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|