Hello Everyone,
I am facing a problem when I try to export a query to Excel.
This is the Export Query:
Code:
Private Sub Export_To_Excel_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "lstEmployee", "C:\Users\b66sws\Documents\Users\Desktop\TestTOREPORTS.xlsx", True
End Sub
This is the error Message:
This is my query:
Code:
[SELECT Employee_T.UserLogID AS [b66#], Employee_T.EmployeeID, Employee_T.FullName, TaskOrderItems.TaskOderItemStartdate AS [TOI Start Date], TaskOrderItems.TaskOrderItemEndDate AS [TOI End Date], TaskOrderItems.PrimeText AS Prime, TaskOrderItems.SubText AS Sub, TaskOrderItems.TaskOrderText AS TaskOrder, TaskOrderItems.PositionTitleText, TaskOrderItems.ElementText AS Element, TaskOrderItems.Created, TaskOrderItems.IsActive, TaskOrderItems.ContractText
FROM Employee_T LEFT JOIN TaskOrderItems ON Employee_T.UserLogID = TaskOrderItems.TaskOrderStaffID
WHERE (((Employee_T.FullName) Is Not Null And (Employee_T.FullName) Like "*" & IIf([forms]![TaskOrder]![txtSearch]<>"",[forms]![taskOrder]![txtSearch],"") & "*") AND ((TaskOrderItems.TaskOrderItemEndDate)>#10/1/2018#) AND ((Employee_T.Deployed)=True))
ORDER BY Employee_T.FullName, TaskOrderItems.TaskOrderItemEndDate DESC , TaskOrderItems.PrimeText, TaskOrderItems.SubText, TaskOrderItems.PositionTitleText, TaskOrderItems.ElementText, TaskOrderItems.Created DESC;
Can anyone help me with this.