Help me! - Code

[lecuongama]

Minh dang bi qua, xin cac cao thu ra tay !
Minh co mot table ve QLNS duoc lap bang SQL Server gom cac truong: Manhansu,Ten,Ngayvaocongty,Ngaykyhopdong,Ngayketth uchopdong.
Minh muon co mot cau lech in danh sach nhan su xap het han hop dong(duoc thong bao truoc 10 ngay).
Minh dang can gap, mong duoc su chi bao cua cac cao thu!
Minh cam on!

[langthangIT]

Ban hien thi thong qua cai gi neu qua Listview thi the nay nhung day la kinh nghiem tu lap trinh Access
set rs=db.openrecordset(table)
do while not rs.eof
If now()-rs.Ngaykyhopdong=10 then
set lst=listview.add (manhansu)
lst.add ten
lst.add ngay....
.
.
.
End If
rs.movenext
loop