What is 'this post' as in "I read this post "?
hermie said:
Jeff Conrad said:
hermie said:
Jeff Conrad said:
hermie said:Hi Jeff
I can see the combobox but not its contents
Here are the steps I did.
1. create unbound form with combo box
2. set combobox row source properties (select
esctarea.IDstudent,esctarea.estudiante FROM esctarea
3. named combo box 'cbofind'
4 set bound column to 1 and column width to 0",1"
5 add an command button with click property me.visible = false
6 saved form as ParamForm
In this fase when I open the form I see the combobox and commandbutton but
the combox not have data
Next step
In the query (esctarea) i put in field IDstduent forms!ParamForm!cbofind
In the reports on open event I put: DoCmd.Openform "ParaForm", , , , ,
acDialog
In the reports on close event I put: DoCmd.Close acForm, "ParaForm"
When I open now the report the form ParamForm opens and cannot selct nothing
in the combobox???
Hope my steps are clear to you
Herman
Jeff Conrad said:
** snipped **Hi Jeff
I can see the combobox but not its contents
Here are the steps I did.
1. create unbound form with combo box
2. set combobox row source properties (select
esctarea.IDstudent,esctarea.estudiante FROM esctarea
3. named combo box 'cbofind'
4 set bound column to 1 and column width to 0",1"
5 add an command button with click property me.visible = false
6 saved form as ParamForm
In this fase when I open the form I see the combobox and commandbutton but
the combox not have data
Next step
In the query (esctarea) i put in field IDstduent forms!ParamForm!cbofind
In the reports on open event I put: DoCmd.Openform "ParaForm", , , , ,
acDialog
In the reports on close event I put: DoCmd.Close acForm, "ParaForm"
When I open now the report the form ParamForm opens and cannot selct nothing
in the combobox???
Hope my steps are clear to you
Herman
fredg said:Hi fred
I changed the column count to 2 but have no effect
Esctarea is a query does this matter?
Here is the SQL view of the query
SELECT Students.IDstudent, [nombre] & " " & [apellidop] & " " & [apellidom]
AS estudiante, [tareas estudiantes].ss, Students.Grupo, Students.Nombre,
Students.ApellidoP, Students.ApellidoM, Students.activo, [tareas
estudiantes].fecha, [tareas estudiantes].esptarea, [tareas
estudiantes].puntos, [tareas estudiantes].valor, ([puntos]/[valor]) AS
[Percent], caltareas([Percent]) AS [Nota test]
FROM Students INNER JOIN [tareas estudiantes] ON (Students.ss = [tareas
estudiantes].ss) AND (Students.ss = [tareas estudiantes].ss)
WHERE (((Students.IDstudent)=[forms]![paramform]![cbofind]) AND
((Students.activo)=True))
ORDER BY [nombre] & " " & [apellidop] & " " & [apellidom], Students.Grupo;
I changed the rowsource with yours but not have effect too?
I made an testdatabase with only the items related If you want i can send a
copy is small
Herman
fredg said:On Wed, 17 Nov 2004 08:38:34 -0400, hermie wrote:
Hi Jeff
I can see the combobox but not its contents
Here are the steps I did.
1. create unbound form with combo box
2. set combobox row source properties (select
esctarea.IDstudent,esctarea.estudiante FROM esctarea
3. named combo box 'cbofind'
4 set bound column to 1 and column width to 0",1"
5 add an command button with click property me.visible = false
6 saved form as ParamForm
In this fase when I open the form I see the combobox and commandbutton but
the combox not have data
Next step
In the query (esctarea) i put in field IDstduent forms!ParamForm!cbofind
In the reports on open event I put: DoCmd.Openform "ParaForm", , , , ,
acDialog
In the reports on close event I put: DoCmd.Close acForm, "ParaForm"
When I open now the report the form ParamForm opens and cannot selct nothing
in the combobox???
Hope my steps are clear to you
Herman
** snipped **
Hermie,
1) Did you also set the Column Count property to 2
2) Is esctarea the name of the table that the fields IDstudent and
estudiante are in?
Change the combo box Row Source to (all on one line):
select esctarea.IDstudent,esctarea.estudiante FROM esctarea Where
esctarea.IDstudent = forms!ParamForm!cbofind;
After you write the above directly on the combo box RowSource line
click on the button with the 3 dots that appears on that line.
Run the query that appears.
You should get prompted for the ID?
After entering a valid ID do you get the correct records returned?
If so, your rowsourse is OK. If not you have improperly written the
SQL, or you have no records to display for that ID.
You'll have to 'fix' it.
Hermie,
The Rowsource data for the combo box should come from the Student
table, not from the Esctarea query.
The Students table was a hidden object.
Here is the rowsource for the [cbofind] combo box:
SELECT Students.IDstudent, [Nombre] & " " & [apellidop] & " " &
[apellidom] AS FullName FROM Students ORDER BY [Nombre] & " " &
[apellidop] & " " & [apellidom];
I kept the student name in the same order you had them in the report.
You can change the order of the names if you wish, for example:
[apellidop] & ", " [Nombre] & " " & [apellidom] AS FullName
(It would be easier to search by family name rather than first name,
but that choice is yours.)
If you do, also change the Order By to reflect the new name
arrangement.
Set the Bound Column property to 1.
Set the Column Count property to 2.
Set Column Widths to 0";1.5" (to show the names in full.)
Set the LimitToList peoperty to Yes.
Run the report. The report opens the ParamForm.
Select the student from the combo box.
Click the command button.
The report displays the selected students data.
If you still have difficulty let me know and I'll email you back your
working database, otherwise I'll delete it in a few days.
Good luck.
fredg said:Hi fred
I changed the column count to 2 but have no effect
Esctarea is a query does this matter?
Here is the SQL view of the query
SELECT Students.IDstudent, [nombre] & " " & [apellidop] & " " & [apellidom]
AS estudiante, [tareas estudiantes].ss, Students.Grupo, Students.Nombre,
Students.ApellidoP, Students.ApellidoM, Students.activo, [tareas
estudiantes].fecha, [tareas estudiantes].esptarea, [tareas
estudiantes].puntos, [tareas estudiantes].valor, ([puntos]/[valor]) AS
[Percent], caltareas([Percent]) AS [Nota test]
FROM Students INNER JOIN [tareas estudiantes] ON (Students.ss = [tareas
estudiantes].ss) AND (Students.ss = [tareas estudiantes].ss)
WHERE (((Students.IDstudent)=[forms]![paramform]![cbofind]) AND
((Students.activo)=True))
ORDER BY [nombre] & " " & [apellidop] & " " & [apellidom], Students.Grupo;
I changed the rowsource with yours but not have effect too?
I made an testdatabase with only the items related If you want i can send a
copy is small
Herman
fredg said:On Wed, 17 Nov 2004 08:38:34 -0400, hermie wrote:
Hi Jeff
I can see the combobox but not its contents
Here are the steps I did.
1. create unbound form with combo box
2. set combobox row source properties (select
esctarea.IDstudent,esctarea.estudiante FROM esctarea
3. named combo box 'cbofind'
4 set bound column to 1 and column width to 0",1"
5 add an command button with click property me.visible = false
6 saved form as ParamForm
In this fase when I open the form I see the combobox and commandbutton but
the combox not have data
Next step
In the query (esctarea) i put in field IDstduent forms!ParamForm!cbofind
In the reports on open event I put: DoCmd.Openform "ParaForm", , , , ,
acDialog
In the reports on close event I put: DoCmd.Close acForm, "ParaForm"
When I open now the report the form ParamForm opens and cannot selct nothing
in the combobox???
Hope my steps are clear to you
Herman
** snipped **
Hermie,
1) Did you also set the Column Count property to 2
2) Is esctarea the name of the table that the fields IDstudent and
estudiante are in?
Change the combo box Row Source to (all on one line):
select esctarea.IDstudent,esctarea.estudiante FROM esctarea Where
esctarea.IDstudent = forms!ParamForm!cbofind;
After you write the above directly on the combo box RowSource line
click on the button with the 3 dots that appears on that line.
Run the query that appears.
You should get prompted for the ID?
After entering a valid ID do you get the correct records returned?
If so, your rowsourse is OK. If not you have improperly written the
SQL, or you have no records to display for that ID.
You'll have to 'fix' it.
Hermie,
The Rowsource data for the combo box should come from the Student
table, not from the Esctarea query.
The Students table was a hidden object.
Here is the rowsource for the [cbofind] combo box:
SELECT Students.IDstudent, [Nombre] & " " & [apellidop] & " " &
[apellidom] AS FullName FROM Students ORDER BY [Nombre] & " " &
[apellidop] & " " & [apellidom];
I kept the student name in the same order you had them in the report.
You can change the order of the names if you wish, for example:
[apellidop] & ", " [Nombre] & " " & [apellidom] AS FullName
(It would be easier to search by family name rather than first name,
but that choice is yours.)
If you do, also change the Order By to reflect the new name
arrangement.
Set the Bound Column property to 1.
Set the Column Count property to 2.
Set Column Widths to 0";1.5" (to show the names in full.)
Set the LimitToList peoperty to Yes.
Run the report. The report opens the ParamForm.
Select the student from the combo box.
Click the command button.
The report displays the selected students data.
If you still have difficulty let me know and I'll email you back your
working database, otherwise I'll delete it in a few days.
Good luck.
Fred
One additional question
Why does the combobox not work with a query? Now I have students in the list
which are not active.
Herman
fredg said:Hi fred
I changed the column count to 2 but have no effect
Esctarea is a query does this matter?
Here is the SQL view of the query
SELECT Students.IDstudent, [nombre] & " " & [apellidop] & " " & [apellidom]
AS estudiante, [tareas estudiantes].ss, Students.Grupo, Students.Nombre,
Students.ApellidoP, Students.ApellidoM, Students.activo, [tareas
estudiantes].fecha, [tareas estudiantes].esptarea, [tareas
estudiantes].puntos, [tareas estudiantes].valor, ([puntos]/[valor]) AS
[Percent], caltareas([Percent]) AS [Nota test]
FROM Students INNER JOIN [tareas estudiantes] ON (Students.ss = [tareas
estudiantes].ss) AND (Students.ss = [tareas estudiantes].ss)
WHERE (((Students.IDstudent)=[forms]![paramform]![cbofind]) AND
((Students.activo)=True))
ORDER BY [nombre] & " " & [apellidop] & " " & [apellidom], Students.Grupo;
I changed the rowsource with yours but not have effect too?
I made an testdatabase with only the items related If you want i can send a
copy is small
Herman
On Wed, 17 Nov 2004 08:38:34 -0400, hermie wrote:
Hi Jeff
I can see the combobox but not its contents
Here are the steps I did.
1. create unbound form with combo box
2. set combobox row source properties (select
esctarea.IDstudent,esctarea.estudiante FROM esctarea
3. named combo box 'cbofind'
4 set bound column to 1 and column width to 0",1"
5 add an command button with click property me.visible = false
6 saved form as ParamForm
In this fase when I open the form I see the combobox and commandbutton
but
the combox not have data
Next step
In the query (esctarea) i put in field IDstduent
forms!ParamForm!cbofind
In the reports on open event I put: DoCmd.Openform "ParaForm", , , , ,
acDialog
In the reports on close event I put: DoCmd.Close acForm, "ParaForm"
When I open now the report the form ParamForm opens and cannot selct
nothing
in the combobox???
Hope my steps are clear to you
Herman
** snipped **
Hermie,
1) Did you also set the Column Count property to 2
2) Is esctarea the name of the table that the fields IDstudent and
estudiante are in?
Change the combo box Row Source to (all on one line):
select esctarea.IDstudent,esctarea.estudiante FROM esctarea Where
esctarea.IDstudent = forms!ParamForm!cbofind;
After you write the above directly on the combo box RowSource line
click on the button with the 3 dots that appears on that line.
Run the query that appears.
You should get prompted for the ID?
After entering a valid ID do you get the correct records returned?
If so, your rowsourse is OK. If not you have improperly written the
SQL, or you have no records to display for that ID.
You'll have to 'fix' it.
Hermie,
The Rowsource data for the combo box should come from the Student
table, not from the Esctarea query.
The Students table was a hidden object.
Here is the rowsource for the [cbofind] combo box:
SELECT Students.IDstudent, [Nombre] & " " & [apellidop] & " " &
[apellidom] AS FullName FROM Students ORDER BY [Nombre] & " " &
[apellidop] & " " & [apellidom];
I kept the student name in the same order you had them in the report.
You can change the order of the names if you wish, for example:
[apellidop] & ", " [Nombre] & " " & [apellidom] AS FullName
(It would be easier to search by family name rather than first name,
but that choice is yours.)
If you do, also change the Order By to reflect the new name
arrangement.
Set the Bound Column property to 1.
Set the Column Count property to 2.
Set Column Widths to 0";1.5" (to show the names in full.)
Set the LimitToList peoperty to Yes.
Run the report. The report opens the ParamForm.
Select the student from the combo box.
Click the command button.
The report displays the selected students data.
If you still have difficulty let me know and I'll email you back your
working database, otherwise I'll delete it in a few days.
Good luck.