User Tools

Site Tools


vba:flexiblerfilter

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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)
-        ​= "​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)
-        ​= 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
  
vba/flexiblerfilter.1452852791.txt.gz · Last modified: 15.01.2016 11:13:11 by yaslaw