Public Sub loadinput(lst As ListBox, cb As ComboBox, cnn As ADODB.Connection, rst As ADODB.Recordset, rst2 As ADODB.Recordset, zd As Dictionary, txt2 As TextBox, txt3 As TextBox, lst2 As ListBox)
'On Error Resume Next
lst.Clear
If cnn.State = 0 Then
cnn.Open "provider=Microsoft.jet.OLEDB.4.0;data source=" & mdbpath & ";Jet.OLEDB:"
End If
Sql = "select * from 录入设置"
rst.Open Sql, cnn, 1, 3
rst.MoveFirst
cb.Text = rst.Fields(3).Value
txt2 = rst.Fields(4).Value
vs1.Value = rst.Fields(4).Value
txt3 = Val(rst.Fields(5).Value)
vs2.Value = Val(rst.Fields(5).Value)
Do While Not rst.EOF
lst.AddItem rst.Fields(0).Value
zd.Add rst.Fields(0).Value, ""
rst.MoveNext
Loop
For Each c In zd.Keys
If Not zd.Exists(rst.Fields(3).Value) Then cb.AddItem c
Next
For i = 0 To lst.ListCount - 1
lst.Selected(i) = True
Next i
Set rst = Nothing
Sql = "select * from 基础信息"
rst2.Open Sql, cnn, 1, 3
rst2.MoveFirst
For i = 0 To rst2.Fields.Count
If Not zd.Exists(rst2.Fields(i).Name) Then lst.AddItem rst2.Fields(i).Name
Next i
Set rst2 = Nothing
cnn.Close
End Sub
'On Error Resume Next
lst.Clear
If cnn.State = 0 Then
cnn.Open "provider=Microsoft.jet.OLEDB.4.0;data source=" & mdbpath & ";Jet.OLEDB:"
End If
Sql = "select * from 录入设置"
rst.Open Sql, cnn, 1, 3
rst.MoveFirst
cb.Text = rst.Fields(3).Value
txt2 = rst.Fields(4).Value
vs1.Value = rst.Fields(4).Value
txt3 = Val(rst.Fields(5).Value)
vs2.Value = Val(rst.Fields(5).Value)
Do While Not rst.EOF
lst.AddItem rst.Fields(0).Value
zd.Add rst.Fields(0).Value, ""
rst.MoveNext
Loop
For Each c In zd.Keys
If Not zd.Exists(rst.Fields(3).Value) Then cb.AddItem c
Next
For i = 0 To lst.ListCount - 1
lst.Selected(i) = True
Next i
Set rst = Nothing
Sql = "select * from 基础信息"
rst2.Open Sql, cnn, 1, 3
rst2.MoveFirst
For i = 0 To rst2.Fields.Count
If Not zd.Exists(rst2.Fields(i).Name) Then lst.AddItem rst2.Fields(i).Name
Next i
Set rst2 = Nothing
cnn.Close
End Sub
解决方案 »
- 望高手进来看看,谢谢了。(在线等待,满意给分)
- 求麦中凡《计算机软件技术基础》(第二版)书中147页开始的10页的那个程序
- Provider=MSDAORA.1 连接失败,帮忙帮忙
- 一个问题,给点意见
- 小弟写的报警软件程序一报警就死机,请求各位大哥哥,大姐姐帮忙!
- 谁写过天干地支的纪年法,年月日时分别怎么算呢?
- 如何找到一个变量的地址?
- vb 能实现在excel上画柱状图吗? 求大神指点
- 一个奇怪的问题:coolbar绑定text,为什么设定text1.locked=true后,text1.backcolor就不能改了
- 急急急:vb6中,怎样得到指定打印机所支持的纸张类型和其尺寸?
- 请问为什么我关闭窗体(执行完Unload me)后,任务管理器中这个程序还在运行?
- 关于光盘程序的问题,看似简单,却很重要,急问
scrrun.dll给禁了。重新注册就好了,谢谢。