1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51
|
Private Sub Command122_Click()
Dim oRst As DAO.Recordset
Dim colonnes As Single
Dim i As Single
Dim nul As Boolean, exist As Boolean
Dim sql As String, osql As String
colonnes = CurrentDb.QueryDefs("ZeroQuery").Fields.count
Set oRst = CurrentDb.OpenRecordset("SELECT * FROM ZeroQuery")
i = 0
sql = ""
osql = ""
exist = False
For Each qry In CurrentDb.QueryDefs
If qry.Name = "TestQuery" Then
exist = True
End If
Next
If exist = True Then
DoCmd.DeleteObject acQuery, "TestQuery"
End If
Do Until (i + 1 >= colonnes)
sql = sql & oRst.Fields(i + 1).Name & " <> 0 AND "
osql = osql & oRst.Fields(i + 1).Name & " = 0 AND "
i = i + 1
Loop
sql = "SELECT * FROM ZeroQuery Where " & sql
sql = Left(sql, Len(sql) - 4) & ";"
osql = "SELECT * FROM ZeroQuery Where " & osql
osql = Left(osql, Len(osql) - 4) & ";"
DoCmd.DeleteObject acQuery, "FinalQuery"
CurrentDb.CreateQueryDef "TestQuery", osql
sql = "SELECT zeroquery.* FROM zeroquery WHERE zeroquery.tagtimestamp Not In (Select testquery.tagtimestamp From testquery);"
CurrentDb.CreateQueryDef "FinalQuery", sql
'Me.lst_resultat.RowSource = "select * from finalquery"
strSql = sql
'Me.lst_resultat.Requery
'Me.RcdLines = Me.lst_resultat.ListCount |
Partager