26/01/08 23:54
gantonio
Inserisci in un form una listbox e un pulsante e usa questo codice. In questa versione pero', il tabellone viene mostrato "al contrario" ... vedi tu di adattarlo ...
Option Explicit Private cn As Connection Private Sub Command1_Click() Dim rs As ADODB.Recordset Dim RU(1 To 10) As String Dim R As Integer Dim N As Integer Dim RN(1 To 10, 1 To 90) Dim C(1 To 10) Dim NN As Integer Dim NS As String * 150 Dim v As Integer RU(1) = "BA" RU(2) = "CA" RU(3) = "FI" RU(4) = "GE" RU(5) = "MI" RU(6) = "NA" RU(7) = "PA" RU(8) = "RO" RU(9) = "TO" RU(10) = "VE" With List1 .Font.Name = "Terminal" .Font.Size = 9 .Clear NS = Space$(150) For R = 1 To 10 Mid$(NS, (R - 1) * 15 + 1) = "----- " & RU(R) & " ----- " Next R .AddItem NS .AddItem "" End With For R = 1 To 10 C(R) = 0 For N = 1 To 90 RN(R, N) = -1 Next N Next R Set rs = New ADODB.Recordset rs.Open "SELECT * FROM Archivio ORDER BY Id DESC", cn, adOpenForwardOnly Do While Not rs.EOF NS = Space$(150) For R = 1 To 10 If C(R) < 90 Then For NN = 1 To 5 v = Val(rs.Fields(RU(R) & CStr(NN)).Value) If RN(R, v) = -1 Then RN(R, v) = v C(R) = C(R) + 1 Mid$(NS, (R - 1) * 15 + (NN - 1) * 3 + 1) = Format$(v, "00") Else Mid$(NS, (R - 1) * 15 + (NN - 1) * 3 + 1) = "--" End If Next NN End If Next R List1.AddItem NS rs.MoveNext Loop rs.Close Set rs = Nothing End Sub Private Sub Form_Load() Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\estrazioni.mdb;Persist Security Info=False" End Sub Private Sub Form_Unload(Cancel As Integer) cn.Close Set cn = Nothing End Sub
aaa