This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
vba:flexiblerfilter [15.01.2016 11:13:11] yaslaw |
vba:flexiblerfilter [29.01.2019 08:36:08] (current) yaslaw [Mittels Array] |
||
---|---|---|---|
Line 61: | Line 61: | ||
If NZ(me!cbxAddressType, -1) > -1 Then | If NZ(me!cbxAddressType, -1) > -1 Then | ||
i = i + 1: Redim Preserve flt(i) | i = i + 1: Redim Preserve flt(i) | ||
- | v = "addressTypeId = " & me!cbxAddressType | + | flt(i) = "addressTypeId = " & me!cbxAddressType |
End If | End If | ||
If Not IsNull(Me!dtFrom) And Not IsNull(Me.dtTo) Then | If Not IsNull(Me!dtFrom) And Not IsNull(Me.dtTo) Then | ||
i = i + 1: Redim Preserve flt(i) | i = i + 1: Redim Preserve flt(i) | ||
- | v = ftl & "createDate BETWEEN " & format(me!dtFrom, "\#MM-DD-YYYY\#") & " AND " & format(me!dtTo, "\#MM-DD-YYYY\#") | + | flt(i) = ftl & "createDate BETWEEN " & format(me!dtFrom, "\#MM-DD-YYYY\#") & " AND " & format(me!dtTo, "\#MM-DD-YYYY\#") |
End If | End If | ||