我用文本框来显示数据库里的记录,由于记录太多而我只在窗口放了九个文本框,现在想实现翻页的功能,怎么办呀?我想每按一次PAGEDOWN就让记录往下读九个记录并将其值赋给文本框.而每按PAGEUP就让记录集往回走九个记录并赋给文本框,其间文本框通过重写TEXT对象来实现.我想通过RS.FIND来定位记录,也就是RS.FIND TEXT1(8).TEXT,来捕捉当前记录所在位置,可是老是实现不了哪位大哥能帮帮我忙啊不胜感激.如果能告诉我你的QQ更是很高兴和你交个朋友,我的QQ是50066427.
调试欢乐多
dim i as integerfor i=0 to 8
currentrec = currentrec + 1
if currentrec <= rs.recordcount then
rs.absoluteposition = currentrec - 1
text1(i) = rs.fileds(0)
else
text1(i) = ""
PAGEDOWN.Enabled = false
end if
next
end subprivate sub PAGEUP_click()
dim i as integercurrentrec = currentrec - 9
if currentrec <= 1 then
currentrec = 1
PAGEUP.enabled = false
end if
for i=0 to 8
currentrec = currentrec + 1
rs.absoluteposition = currentrec - 1
text1(i) = rs.fileds(0)
nextend sub