Subform

[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.

 

[Guest]

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.....

 

[Guest]

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.

 

[Daniel]

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.

 

[Guest]

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

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.

 

[Daniel]

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

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.

 

[Guest]

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

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.

 

[Daniel]

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

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.