Hi guys,
I cant see where my code is incorrect, but obviously it is ats Im getting the error type mismatch:
Code:
Case "Current User"
MySQL = "SELECT TimesheetTable.sUser, TimesheetTable.Activity, TimesheetTable.Hours, TimesheetTable.Project, TimesheetTable.[Task Date], TimesheetTable.Description FROM TimesheetTable "
MySQL = MySQL & "WHERE (((TimesheetTable.sUser)=[Forms]![TotalHours_Frm]![CurrentUser]) AND ((TimesheetTable.Project) Like " * " & [Forms]![TotalHours_Frm]![ProjectRef_txtbox] & " * ")"
Will someone put me out of my misery please?