استخدم البارامتر بالطريقة التالية
daAnalysisSearch = New OleDbDataAdapter("select * from Analysis_Table where RegistrationDate BETWEEN @date1 AND @date2", connAccess2007)
daAnalysisSearch.selectcommand.parameters.addwithvalue("@date1",DateTimePicker1.Value.Date)
daAnalysisSearch.selectcommand.parameters.addwithvalue("@date2",DateTimePicker2.Value.Date)
daAnalysisSearch = New OleDbDataAdapter("select * from Analysis_Table where RegistrationDate BETWEEN @date1 AND @date2", connAccess2007)
daAnalysisSearch.selectcommand.parameters.addwithvalue("@date1",DateTimePicker1.Value.Date)
daAnalysisSearch.selectcommand.parameters.addwithvalue("@date2",DateTimePicker2.Value.Date)