kusha313
دوشنبه 26 تیر 1391, 12:46 عصر
با سلام خدمت اساتيد محترم
من فرمي ساختم كه ميخوام كاربر با پركردن هركدام از فيلدها وقتي روي دكمه جستجو كليك مي كند اطلاعات نشان داده شود كدهاي مربوط به 2 تا از فيلدهام رو نوشتم ولي در هنگام ديباگ به من ارور ميده اگه ممكنه اشكالش رو به من بگيد
Private Sub Command16_Click()
Dim strSearch1 As String
Dim strSearch2 As String
Dim strSearch3 As String
If Not IsNull(term_code) Then
strSearch = "([term_code]='" & term_code & "') AND "
Else: strSearch = " "
End If
If Not IsNull(term_name) Then strSearch = strSearch & "([term_name]='" & term_name & "')AND"
SQL = "select * from term where" & strSearch
'If Not IsNull(gavahi_type) Then strSearch = strSearch & "([gavahi_type]='" & gavahi_type & "' ) AND "
'If Not IsNull(term_amount) Then strSearch = strSearch & "([dateofresive]>= #" & Text0 & "# ) AND "
'If Not IsNull(start_date) Then strSearch = strSearch & "([start_date]='" & start_date & "' ) AND "
'If Not IsNull(teacher) Then stLinkCriteria = stLinkCriteria & "([teacher]='" & teacher & "') AND "
'If Not IsNull(day) Then stLinkCriteria = stLinkCriteria & "([day]='" & day & "') AND "
'If Not IsNull(time) Then stLinkCriteria = stLinkCriteria & "([time]='" & time & "') "
n = Len(SQL)
If n > 0 Then strSearch = Left(SQL, n - 4)
DoCmd.OpenReport 1, acViewPreview, , strSearch, acWindowNormal
End Sub
[/LTR_INLINE]
[/LTR_INLINE]
من فرمي ساختم كه ميخوام كاربر با پركردن هركدام از فيلدها وقتي روي دكمه جستجو كليك مي كند اطلاعات نشان داده شود كدهاي مربوط به 2 تا از فيلدهام رو نوشتم ولي در هنگام ديباگ به من ارور ميده اگه ممكنه اشكالش رو به من بگيد
Private Sub Command16_Click()
Dim strSearch1 As String
Dim strSearch2 As String
Dim strSearch3 As String
If Not IsNull(term_code) Then
strSearch = "([term_code]='" & term_code & "') AND "
Else: strSearch = " "
End If
If Not IsNull(term_name) Then strSearch = strSearch & "([term_name]='" & term_name & "')AND"
SQL = "select * from term where" & strSearch
'If Not IsNull(gavahi_type) Then strSearch = strSearch & "([gavahi_type]='" & gavahi_type & "' ) AND "
'If Not IsNull(term_amount) Then strSearch = strSearch & "([dateofresive]>= #" & Text0 & "# ) AND "
'If Not IsNull(start_date) Then strSearch = strSearch & "([start_date]='" & start_date & "' ) AND "
'If Not IsNull(teacher) Then stLinkCriteria = stLinkCriteria & "([teacher]='" & teacher & "') AND "
'If Not IsNull(day) Then stLinkCriteria = stLinkCriteria & "([day]='" & day & "') AND "
'If Not IsNull(time) Then stLinkCriteria = stLinkCriteria & "([time]='" & time & "') "
n = Len(SQL)
If n > 0 Then strSearch = Left(SQL, n - 4)
DoCmd.OpenReport 1, acViewPreview, , strSearch, acWindowNormal
End Sub
[/LTR_INLINE]
[/LTR_INLINE]