技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 33
|
[:28]請(qǐng) fans 職教一下,我剛好也碰到類(lèi)是問(wèn)題:我建立一個(gè) 部門(mén)樹(shù),希望 點(diǎn)擊部門(mén)后,在下級(jí)節(jié)點(diǎn) 添加 該部門(mén)內(nèi)的人員, 已基本實(shí)現(xiàn),但是如果重新點(diǎn)擊 該部門(mén)后,提示錯(cuò)誤: key 不是唯一
Private Sub Form_Load()
Me.Trv.Nodes.Clear '清除Treeview控件中的所有節(jié)點(diǎn)
Call AddMyTree(Trv, "usysDepartment", "Dept_ParentID", "Dept_ID", "Dept_Name")
Me.Trv.SetFocus
End Sub
Private Sub Trv_NodeClick(ByVal Node As Object)
'MsgBox Node.Index & "****" & Node.Tag
Rec.Open "select * from EmploymentInfo where EMP_Units='" & Node & "'", CurrentProject.Connection, adOpenKeyset, adLockOptimistic
If Rec.RecordCount > 0 Then
For i = 0 To Rec.RecordCount - 1
Set Nodeindex = Trv.Nodes.Add(Node, tvwChild, "e" & Rec.Fields("EMP_ID"), Rec.Fields("EMP_Name"), 1, 2)
Node.Tag = Rec.Fields("EMP_ID")
Node.Sorted = True
Rec.MoveNext
Next
End If
Rec.Close
Me.Trv.Refresh
[ 本帖最后由 mopems 于 2008-8-28 14:51 編輯 ] |
|