Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using classroom template for training database. I've added a column for
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.

"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "

I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.

Any help will be much appreciated.
 
this is not an answer to your question; not clear what you mean when you say
you are adding a "column" to both the Student & Classes tables....since one
would think it could be only appearing in one table....probably the Class
Table.....
 
Each Class form has a subform for the students that completed the training
course. A colum was added to that subform to indicate the date that the
student completed the course.
The info for the class and who took the class is combined in a table
"Students and Classes", which I added the Date Completed. too.
I have a subquery whuich is the Student Subform Subquery, which I also added
the Date Completed to. The problem is when the student form is opened with
the classes subform, the subform lists only the classes taken by that
student, but I can't get the Date Completed to show.
--
Thanks for your help,
Greg


NetworkTrade said:
this is not an answer to your question; not clear what you mean when you say
you are adding a "column" to both the Student & Classes tables....since one
would think it could be only appearing in one table....probably the Class
Table.....
--
NTC


Greg said:
I'm using classroom template for training database. I've added a column for
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.

"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "

I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.

Any help will be much appreciated.
Click to expand...
Click to expand...
 
The recordsource that you showed for the subform doesn't have a Date
Completed field selected.

Did you try adding the field you want to the recordsource? It would
probably be something like [Student Subform Query].completionDate (and
could be placed after the "SELECT DISTINCTROW " part of the statement).

Daniel
Each Class form has a subform for the students that completed the training
course. A colum was added to that subform to indicate the date that the
student completed the course.
The info for the class and who took the class is combined in a table
"Students and Classes", which I added the Date Completed. too.
I have a subquery whuich is the Student Subform Subquery, which I also added
the Date Completed to. The problem is when the student form is opened with
the classes subform, the subform lists only the classes taken by that
student, but I can't get the Date Completed to show.
--
Thanks for your help,
Greg


NetworkTrade said:
this is not an answer to your question; not clear what you mean when you say
you are adding a "column" to both the Student & Classes tables....since one
would think it could be only appearing in one table....probably the Class
Table.....
--
NTC


Greg said:
I'm using classroom template for training database. I've added a column for
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.

"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "

I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.

Any help will be much appreciated.
Click to expand...
Click to expand...
Click to expand...
 
I've tried that, but it hasn't worked. No matter where I've put the [Student
Subform Subquery].DateCompleted it doesn't work. I always get a error the
says all the other fields control or record source is in error.
--
Thanks for your help,
Greg


Daniel said:
The recordsource that you showed for the subform doesn't have a Date
Completed field selected.

Did you try adding the field you want to the recordsource? It would
probably be something like [Student Subform Query].completionDate (and
could be placed after the "SELECT DISTINCTROW " part of the statement).

Daniel
Each Class form has a subform for the students that completed the training
course. A colum was added to that subform to indicate the date that the
student completed the course.
The info for the class and who took the class is combined in a table
"Students and Classes", which I added the Date Completed. too.
I have a subquery whuich is the Student Subform Subquery, which I also added
the Date Completed to. The problem is when the student form is opened with
the classes subform, the subform lists only the classes taken by that
student, but I can't get the Date Completed to show.
--
Thanks for your help,
Greg


NetworkTrade said:
this is not an answer to your question; not clear what you mean when you say
you are adding a "column" to both the Student & Classes tables....since one
would think it could be only appearing in one table....probably the Class
Table.....
--
NTC


:

I'm using classroom template for training database. I've added a column for
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.

"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "

I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.

Any help will be much appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Try pasting the recordsource including the DateCompleted field into a
new query statement. When you try and open/run this query, does it
work? If not, what's the error?
I've tried that, but it hasn't worked. No matter where I've put the [Student
Subform Subquery].DateCompleted it doesn't work. I always get a error the
says all the other fields control or record source is in error.
--
Thanks for your help,
Greg


Daniel said:
The recordsource that you showed for the subform doesn't have a Date
Completed field selected.

Did you try adding the field you want to the recordsource? It would
probably be something like [Student Subform Query].completionDate (and
could be placed after the "SELECT DISTINCTROW " part of the statement).

Daniel
Each Class form has a subform for the students that completed the training
course. A colum was added to that subform to indicate the date that the
student completed the course.
The info for the class and who took the class is combined in a table
"Students and Classes", which I added the Date Completed. too.
I have a subquery whuich is the Student Subform Subquery, which I also added
the Date Completed to. The problem is when the student form is opened with
the classes subform, the subform lists only the classes taken by that
student, but I can't get the Date Completed to show.
--
Thanks for your help,
Greg


:

this is not an answer to your question; not clear what you mean when you say
you are adding a "column" to both the Student & Classes tables....since one
would think it could be only appearing in one table....probably the Class
Table.....
--
NTC


:

I'm using classroom template for training database. I've added a column for
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.

"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "

I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.

Any help will be much appreciated.
Click to expand...
Click to expand...
Click to expand...
 
When I run the students and classes query, the date completed shows. But when
I open the student form, the subform for for the classes that student has
taken shows #Name? instead of the date
--
Thanks for your help,
Greg


Daniel said:
Try pasting the recordsource including the DateCompleted field into a
new query statement. When you try and open/run this query, does it
work? If not, what's the error?
I've tried that, but it hasn't worked. No matter where I've put the [Student
Subform Subquery].DateCompleted it doesn't work. I always get a error the
says all the other fields control or record source is in error.
--
Thanks for your help,
Greg


Daniel said:
The recordsource that you showed for the subform doesn't have a Date
Completed field selected.

Did you try adding the field you want to the recordsource? It would
probably be something like [Student Subform Query].completionDate (and
could be placed after the "SELECT DISTINCTROW " part of the statement).

Daniel

Greg wrote:
Each Class form has a subform for the students that completed the training
course. A colum was added to that subform to indicate the date that the
student completed the course.
The info for the class and who took the class is combined in a table
"Students and Classes", which I added the Date Completed. too.
I have a subquery whuich is the Student Subform Subquery, which I also added
the Date Completed to. The problem is when the student form is opened with
the classes subform, the subform lists only the classes taken by that
student, but I can't get the Date Completed to show.
--
Thanks for your help,
Greg


:

this is not an answer to your question; not clear what you mean when you say
you are adding a "column" to both the Student & Classes tables....since one
would think it could be only appearing in one table....probably the Class
Table.....
--
NTC


:

I'm using classroom template for training database. I've added a column for
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.

"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "

I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.

Any help will be much appreciated.
Click to expand...
Click to expand...
Click to expand...
 
The only other thing I can think of is that your textbox has the same
name as the field. This might give you a circular reference, and the
#Name? error. Have you checked this?

Can you add another textbox (corresponding to the date field) to your
subform using the field list?

HTH,
Daniel
When I run the students and classes query, the date completed shows. But when
I open the student form, the subform for for the classes that student has
taken shows #Name? instead of the date
--
Thanks for your help,
Greg


Daniel said:
Try pasting the recordsource including the DateCompleted field into a
new query statement. When you try and open/run this query, does it
work? If not, what's the error?
I've tried that, but it hasn't worked. No matter where I've put the [Student
Subform Subquery].DateCompleted it doesn't work. I always get a error the
says all the other fields control or record source is in error.
--
Thanks for your help,
Greg


:

The recordsource that you showed for the subform doesn't have a Date
Completed field selected.

Did you try adding the field you want to the recordsource? It would
probably be something like [Student Subform Query].completionDate (and
could be placed after the "SELECT DISTINCTROW " part of the statement).

Daniel

Greg wrote:
Each Class form has a subform for the students that completed the training
course. A colum was added to that subform to indicate the date that the
student completed the course.
The info for the class and who took the class is combined in a table
"Students and Classes", which I added the Date Completed. too.
I have a subquery whuich is the Student Subform Subquery, which I also added
the Date Completed to. The problem is when the student form is opened with
the classes subform, the subform lists only the classes taken by that
student, but I can't get the Date Completed to show.
--
Thanks for your help,
Greg


:

this is not an answer to your question; not clear what you mean when you say
you are adding a "column" to both the Student & Classes tables....since one
would think it could be only appearing in one table....probably the Class
Table.....
--
NTC


:

I'm using classroom template for training database. I've added a column for
date completed in class subform for recording students and when course was
completed.
I've added same column to Students and Classes table.
Under the student subform I can't get the date completed to appear.
Here is the record source for the student subform.

"SELECT DISTINCTROW Classes.ClassName, Departments.DepartmentName,
Instructors.Instructor, Classes.ClassID, [Student Subform
Subquery].StudentID, [Student Subform Subquery].Grade, [Student Subform
Subquery].[Grade (%)] FROM (Departments RIGHT JOIN (Instructors RIGHT JOIN
Classes ON Instructors.InstructorID=Classes.InstructorID) ON
Departments.DepartmentID=Classes.DepartmentID) INNER JOIN [Student Subform
Subquery] ON Classes.ClassID=[Student Subform Subquery].ClassID; "

I've tried everything I can think of to add the date completedto the student
subform, but can't get it to work.

Any help will be much appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top