Search results

I got it!!!!!! I made it work!!!! 'Dim xlApp as Object 'Dim xlBook as Object 'Dim xlSheet as Object Dim XlApp As Excel.Application Dim XLBook As Excel.Workbook Dim Xlsheet As Excel.Worksheet Dim SQL As String 'Dim SQL2 As String Dim rs1 As DAO.Recordset 'Dim RS2 As DAO.Recordset Dim...

Hi CJ Apologies, the error is on Set PayrollMonthFilter = me.payrollMonth.value The SQL i am using is not a cross tab but the query i am building it from is a cross tab. Although i thought you made an interesting point so i thought i would change my SQL in the VBA to the CrossTab to see if i...

Okay, so i tried to do something with the parameters. Working within Access just seemed to give me that same problems with not fielding the field so i tried it in the SQL code within my VBA. This is what i came up with 'Dim xlApp as Object 'Dim xlBook as Object 'Dim xlSheet as Object Dim XlApp...

Hi All Apologies for the missing Code tags. I did try but i obviously used the wrong thing. 'Dim xlApp as Object 'Dim xlBook as Object 'Dim xlSheet as Object Dim XlApp As Excel.Application Dim XLBook As Excel.Workbook Dim Xlsheet As Excel.Worksheet Dim SQL As String 'Dim rs1 As DAO.Recordset...

Hi All I have tried everything i can think of to get around this but i am at a dead end. I have a report which, for reasons that are annoying and too long to go into, has to be exported into excel as a recordset. The query i am using has gone through many queries in order to get to the...