Student Progress Database Application

I don't understand it because Ii see no error in the code nor do I see any reason for it.

What is the SQL for qryStudentProgress_FIRST_SIMPLE_QUERY?

Here's the code behind the generate report button:

Private Sub Command41_Click()

Dim strSQL As String

         strSQL = "DELETE * FROM tmpProgress;"

                  CurrentDb.Execute strSQL, dbFailOnError

         strSQL = "INSERT INTO tmpProgress (CenterCode, StudentID, GradeScore, CourseName) " & _

                         "SELECT CenterCode, StudentID, GradeScore, CourseName " & _

                         "FROM qryStudentProgress_FIRST_SIMPLE_QUERY; "

                CurrentDb.Execute strSQL, dbFailOnError

         DoCmd.OpenReport "frmSimpleUsingCrosstabasSource", acViewPreview, , "CenterCode= " & Me.Combo15

End Sub

I'm having a lot of trouble with this code behind the generate report button. If I put the Debug.Print command right before the second execute statement, the immediate window points to the strSQL statement with :

                         "INSERT INTO tmpProgress (CenterCode, StudentID, GradeScore, CourseName) " & _

                         "SELECT CenterCode, StudentID, GradeScore, CourseName " & _

                         "FROM qryStudentProgress_FIRST_SIMPLE_QUERY; "

If I put the cursor over the dbFailOnError it looks like this:

I fail to understand the error.

Show me the code behind the Generate Report button. I can't understand why this doesn't work for you. It works fine for me.

Okay, now I get it, the Query1 was just used as an example while the code snippet does the deleting and inserting into the tmpProgress table. Okay, so now I wish to run the report from the main form without opening all the queries.  Just by selecting the generate report button. But once I do, it gives me this error, which should not be. It should just open the report based on the center code. Here's the error:

I get this error repeatedly whenever I press the generate button.

***Personal information deleted by the moderator. Please see the Microsoft Community Frequently Asked Questions for more information on how you can protect your privacy.***

Query 1 was just an example. Its the query that is generated in the code snippet I gave you. You really have to follow what I have told you, don't forget previous instructions.

So, AGAIN, the Generate Report code does the following:

1. Deletes all records from tmpProgress
2. Appends records to tmpProgress that meet the selected criteria of CenterCode and GradeMonth.
3. Opens the Report which is based on the second query I outlined. So you have a crosstab query based on tmpProgress as an interim query and a second query to bring in the Student name and calculate the percentage.

This was all laid out in detail in my response on Jan 3.

The reason for tmpProgress was because for some reason the second query that was based on the original crosstab was not working as it should. So I created the temp table as a workaround.