A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

purpose of subform?



 
 
Thread Tools Display Modes
  #41  
Old January 7th, 2009, 02:48 PM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default 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  
Old January 7th, 2009, 07:02 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old January 8th, 2009, 01:49 AM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default 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  
Old January 8th, 2009, 02:44 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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  
Old January 8th, 2009, 10:53 PM posted to microsoft.public.access.forms
mike
external usenet poster
 
Posts: 3,942
Default 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  
Old January 9th, 2009, 12:57 AM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:30 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.