急,一个辣手问题啊!头疼死了
我写了2个函数
一初始化控件
Dim lvwItem As ListItem
Set lvwItem = listview.ListItems.Add(, , "默认打印机")
lvwItem.SubItems(1) = "0"
lvwItem.SubItems(2) = "0"
lvwItem.SubItems(3) = "0"
二 刷新列表
szSQL = "SELECT NPRINTERID,SUM(NLINENUM) AS SUM_NLINENUM,SUM(NPRINTNUM) AS SUM_NPRINTNUM,SUM(NLINENUM-NPRINTNUM) AS SUM_NNOPRINTNUM FROM PRINTINDEX WHERE NPRINTERID >0 GROUP BY NPRINTERID"
cRecordSet.COpen szSQL, cDBConn, adOpenStatic, adLockReadOnly
Do Until cRecordSet.IsEof
szPrintName = "默认打印机"
listview.FindItem(szPrintName).SubItems(1) = cRecordSet.GetFieldValue("SUM_NLINENUM")
listview.FindItem(szPrintName).SubItems(2) = cRecordSet.GetFieldValue("SUM_NPRINTNUM")
listview.FindItem(szPrintName).SubItems(3) = cRecordSet.GetFieldValue("SUM_NNOPRINTNUM")
cRecordSet.MoveNext
Loop
listview.Refresh
我执行到第二个函数时报错 说with变量为定义
咋回事啊?