Student Progress Database Application

Anonymous
2016-11-08T11:25:10+00:00

Hello everyone!

I want to make an application for keeping track of students’ progress marks each month of the year using Access 2010. Suppose I have 10 literacy centers in 10 different locations each with 35-40 students enrolled. I want to generate a monthly Access  report showing the progress of each student in each of the subjects taught.

I have designed forms for entering details of each center, instructor and student saved in separate tables. All I need to do is find a way to generate month-wise students’ progress reports for each of the 10 literacy centers to be handed over to the center manager.

What would be the best way this could be done using Access 2010?

Thank you.

~~Maneesh

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

139 answers

Sort by: Newest
Most helpful Newest Oldest
  1. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-06T03:12:08+00:00

    Copy and paste from the Immediate Window into SQL View of a query. Then switch to Design View. That may give you a clue or copy and paste it into a rep0ly and let me test it.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-01-06T02:27:38+00:00

    Here's the Local and Watch window:

    And the watch window:

    From the above Watch window, the error is pointing to the INSERT statement. I checked again and again but everything seems to be fine, no typos either in the INSERT statement. So. where's the problem?

    Was this answer helpful?

    0 comments
  3. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-05T17:24:03+00:00

    Yes, that is the problem. Put a 

    Debug.Print strSQL

    before the second Execute statement and see what shows in the Immediate window. I believe we went over how to debug a problem like this. You need to see what strSQL is evaluating to.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-01-05T16:15:37+00:00

    I don't know why my tmpProgress table is not populating with the records from the main form filtered for the center code and month. As soon as I press the generate report button, it gives me this error:

    And when I debug, it points out the following code:

    Maybe this error is the issue responsible for not populating the tmpProgress table. The error number is "Error: 3061: Too few parameters" I don't have any idea what the error means.

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

    Was this answer helpful?

    0 comments
  5. ScottGem 68,840 Reputation points Volunteer Moderator
    2017-01-05T15:01:04+00:00

    Nope you did NOT follow my instructions. This is from my post on 1/3:

    However, there is a work around. 

    What I would do is create a table to be used temporarily to store the data used for the crosstab. 

    You will then need to expand the code behind your Generate Report button:

    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

    You need to create the Temp table as I described. You need to populate that table using the code shown above. You also need to create a new crosstab query based on the Temp table and then use that to create a table that can be used as the Recordsource of your report.

    So the process steps are:

    1. delete all the records from the temp table
    2. populate the temp table with the records filtered for the Center Code and Month
    3. Run the report which will be based on a query that reads from the NEW crosstab query (based on the temp table)

    Was this answer helpful?

    0 comments