Klos, Susan
Susan.Klos at fldoe.org
Tue Jun 10 08:28:03 CDT 2003
It worked yesterday. '------------------------------------------------------------ ' mcrSaveReading ' '------------------------------------------------------------ Function mcrSaveReading() On Error GoTo mcrSaveReading_Err Dim school As String Dim strFileName As String Dim mysql As String Dim qdf As QueryDef Dim db As Database Dim rs As DAO.Recordset Set db = CurrentDb Set rs = db.OpenRecordset("GradedSchools") Do Until (rs.EOF) school = rs.Fields("DistSchNo") 'school = InputBox("What School Number") 'school = "[GradedSchools.DistSchNo]" 'MsgBox school 'DoCmd.TransferSpreadsheet acExport, 8, "Reading", "T:\2002-2003\SchoolGrades\Data\Reading" & school & ".xls", True, "" mysql = "SELECT ReadingGrade.DistSchNo, ReadingGrade.Grade, ReadingGrade.LName, ReadingGrade.FName, " & _ "ReadingGrade.IDSS, ReadingGrade.Curr03, ReadingGrade.MatchFCAT02, ReadingGrade.LevelR03, " & _ "ReadingGrade.LevelR02, ReadingGrade.DSS03R, ReadingGrade.DSSR02, ReadingGrade.SSR02, ReadingGrade.Lo25 FROM ReadingGrade " & _ "WHERE (((ReadingGrade.DistSchNo)='" & school & "'))" Set qdf = db.QueryDefs("Reading") strFileName = "T:\2002-2003\SchoolGrades\Data\Reading" & school & ".xls" qdf.SQL = mysql 'MsgBox "tablename = " & strFileName DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, qdf.Name, strFileName, True rs.MoveNext Loop mcrSaveReading_Exit: Exit Function mcrSaveReading_Err: MsgBox Error$ Resume mcrSaveReading_Exit End Function