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...