Search results for query: *

Thanks Remou! Sorry I have not tried it as of yet I was busy with other work requests but I will try it today and hopefully fixes the errors.

Hi Remou, Below is how I have set the code, would it be correct to run it all or just run the query first? Sub exportspreadsheet() On Error GoTo HandleError Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim strSQL2 As String Dim strFileName As String Dim objXLApp As...

Remou, I think that MyQuery has not populated yet due to Error 31532, stating that Access was not able to export the data

Thanks PHV that solved that problem but now I get Error 31532, stating that Access was not able to export the data. Why would this be?

Thank you! I have set the code as follows but now I amm getting an error saying 'Error 3129 - Invalid SQL Statement; expected 'INSERT', 'DELETE', 'UPDATE', 'PROCEDURE' or 'SELECT' strSQL2 = "SELECT * FROM Final_all " _ & "WHERE Final_all.Store_ID =" & rs!Store_ID _ & " ORDER BY Final_all.ID...

so would I insert that command after I have declared strSQL2? and then refer to Sheet3 as the exporting table? Sub exportspreadsheet() On Error GoTo HandleError Dim db As DAO.Database Dim rs As DAO.Recordset Dim strSQL As String Dim strSQL2 As String Dim strFileName As String Dim objXLApp...

Hi, I am trying to create a module that exports data for every store ID in an Access database to individual store excel files. I have come close, so I think, to solving the problem; however, the export string table is not being allowed to export to excel. May someone help me solve my mistake...