ListView CheckBoxes [RESOLVIDO].

JorgeI

09-12-2013 11:13:47

Caros,

Apesar do projeto "Financeiro" do Leandro Alves ter o que eu preciso na linha de código, não estou conseguindo
adaptar ao meu projeto. Trata-se do "CheckBoxes" no Listview. Agradeço qq ajuda, segue abaixo o código:
Obs: "Checkboxes" já salvei "True" nas Propriedades do "ListView".

Private Sub CommandButton4_Click()
On Error Resume Next

ListView1.Enabled = True

Set rst = New ADODB.Recordset
rst.CursorLocation = adUseServer

If OptionButton1.Value = True Then
rst.Open "select * from Ctr_Geral_Mats order by CODIGO", cnn
rst.MoveFirst

End If

With ListView1
.ColumnHeaders.Clear
.Gridlines = True
.View = lvwReport
.ColumnHeaders.Add Text:="", Width:=0
.ColumnHeaders.Add Text:="Código", Width:=50, Alignment:=0
.ColumnHeaders.Add Text:="Discip", Width:=40, Alignment:=0
.ColumnHeaders.Add Text:="Descrição", Width:=200, Alignment:=0
.ColumnHeaders.Add Text:="DN", Width:=60, Alignment:=1
.ColumnHeaders.Add Text:="UN", Width:=30, Alignment:=1
.ColumnHeaders.Add Text:="Fornecedor", Width:=70, Alignment:=0
.ColumnHeaders.Add Text:="PC", Width:=65, Alignment:=2
.ColumnHeaders.Add Text:="It PC", Width:=50, Alignment:=1
.ColumnHeaders.Add Text:="Qt PC", Width:=50, Alignment:=1
.ColumnHeaders.Add Text:="Kgm", Width:=50, Alignment:=1
.ColumnHeaders.Add Text:="Peso", Width:=50, Alignment:=1
.ColumnHeaders.Add Text:="Vr Unit", Width:=75, Alignment:=1
.ColumnHeaders.Add Text:="Vr Total", Width:=75, Alignment:=1
.ColumnHeaders.Add Text:="NF", Width:=50, Alignment:=1
.ColumnHeaders.Add Text:="Data NF", Width:=80, Alignment:=1
.ColumnHeaders.Add Text:="Qt NF", Width:=50, Alignment:=0
.ColumnHeaders.Add Text:="RIR", Width:=80, Alignment:=0
.ColumnHeaders.Add Text:="RDR", Width:=80, Alignment:=0
.ColumnHeaders.Add Text:="No Migo", Width:=90, Alignment:=0
.ColumnHeaders.Add Text:="Status", Width:=50, Alignment:=0
.ColumnHeaders.Add Text:="Localiz.", Width:=50, Alignment:=0
.ColumnHeaders.Add Text:="Obs", Width:=50, Alignment:=0
.ColumnHeaders.Add Text:="Ident", Width:=50, Alignment:=0
End With

Dim strSQL As String
Dim objCurrLI As ListItem



rst.Open "SELECT * FROM Ctr_Geral_Mats ORDER BY CODIGO", _
cnn, adOpenKeyset, adLockOptimistic

rst.MoveFirst

cmd.CommandText = strSQL
Set rst = cmd.Execute
ListView1.ListItems.Clear

With rst
Do Until .EOF
Set objCurrLI = ListView1.ListItems.Add

objCurrLI.SubItems(1) = !CODIGO
objCurrLI.SubItems(2) = !Disc
objCurrLI.SubItems(3) = !DESCRICAO
objCurrLI.SubItems(4) = !DN & ""
objCurrLI.SubItems(5) = !UN
objCurrLI.SubItems(6) = !FORNECEDOR
objCurrLI.SubItems(7) = !PC
objCurrLI.SubItems(8) = !IT_PC
objCurrLI.SubItems(9) = Format(CCur(!QT_PC), "###,###,##0.00")
objCurrLI.SubItems(10) = Format(CCur(!KGM), "###,###,##0.00")
objCurrLI.SubItems(11) = Format(CCur(!Peso), "###,###,##0.00")
objCurrLI.SubItems(12) = Format(CCur(!Vr_Unit), "###,###,##0.00")
objCurrLI.SubItems(13) = Format(CCur(!Vr_Total), "###,###,##0.00")
objCurrLI.SubItems(14) = !NF
objCurrLI.SubItems(15) = Format(!Data_NF, "dd/mm/yyyy")
objCurrLI.SubItems(16) = Format(CCur(!Qtd_NF), "###,###,##0.00")
objCurrLI.SubItems(17) = !RIR
objCurrLI.SubItems(18) = !RDR
objCurrLI.SubItems(19) = !No_MIGO
objCurrLI.SubItems(20) = !Status
objCurrLI.SubItems(21) = !Loc_TAGs
objCurrLI.SubItems(22) = !Obs
objCurrLI.SubItems(23) = !IDENT
.MoveNext
Loop
End With

With ListView1
If .ListItems.Count > 0 Then
Set .SelectedItem = .ListItems(1)
End If
End With

ListView1.FullRowSelect = True

Set objCurrLI = Nothing
Set rst = Nothing

Set rst = cnn.Execute("SELECT COUNT(*) AS total FROM Ctr_Geral_Mats")
If Not rst.EOF Then

TextCount.Text = Format(rst("total"), "###,###,###")
Else
MsgBox "Não há nenhum registro!"
End If

Set rst = Nothing

End Sub

JorgeI

19-12-2013 15:52:25

Resolvido.