I am using VS2010 and Microsoft Access Database 2013. I have a query to search the action start data. Depending on which date I select on the datetimepicker I get no results or limited results without any error message during application debugging.
My code is below.
Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click
Dim Search As Date = ActionStartDateDateTimePicker.Value
Me.ActionsLogTableAdapter.FilterBYActionStartDate(Me.GSKactionsDBDataSet.ActionsLog, Search)
Form48.MdiParent = Form27
Form48.Show()
Form48.ActionsLogTableAdapter.FilterBYActionStartDate(Form48.GSKactionsDBDataSet.ActionsLog, Search)
End Sub
And my Query is as follows:
Method Name: FilterBYActionStartDate
SELECT ID, ActionReferance, ActionDescription, ActionSite, ActionCategory, ActionImportance, ActionAccountability, ActionProgressStatus, ActionClosurestatus, ActionDoneBy,
ActionComment, ActionYear, ActionStartDate, PlannedClosureDate, RealClosureDate, ActualClosureDuration, PlannedClosureDuration
FROM ActionsLog
WHERE (ActionStartDate LIKE ?)
Thanks for any help.