Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
135
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. Private Sub Remover_Click()
  2.  
  3. Dim con As ADODB.Connection
  4. Set con = CurrentProject.Connection
  5. Dim rst As ADODB.Recordset
  6. Set rst = New ADODB.Recordset
  7.  
  8.  
  9. Dim i As Integer
  10.  
  11. For i = 0 To Lista_eventos.ListCount - 1
  12. If Lista_eventos.Selected(i) Then
  13. rst.Open "Eventos", con, adOpenForwardOnly, adLockOptimistic
  14. rst.Find "Nome = '" & Ev & "'", , adSearchForward
  15. idevento = rst.Fields("ID")
  16. rst.Delete
  17. rst.MoveFirst
  18. rst.Close
  19. End If
  20. Next i
  21.  
  22.  
  23.  
  24. query3 = "SELECT ID,Tipo,Nome FROM Eventos"
  25.  
  26.  
  27. With Lista_eventos
  28. .ColumnCount = 3
  29. .RowSourceType = "Table/Query"
  30. .ColumnHeads = False
  31. .RowSource = query3
  32. .ColumnWidths = "0cm; 3 cm;3cm"
  33. End With
  34.  
  35.  
  36. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement