小弟想写First、Previous、Next、Last四个按钮,来移动MSHFlexGrid的记录
时间:2011-07-25
来源:互联网
请问是如何实现的啊?
作者: xiaoniuyou 发布时间: 2011-07-25
数据怎么上的?
作者: patrickkong 发布时间: 2011-07-25
自己看看吧。
Option Explicit
Private Sub cmdFirst_Click()
MSFlexGrid1.Row = MSFlexGrid1.FixedRows
FixRest
End Sub
Private Sub cmdLast_Click()
MSFlexGrid1.Row = MSFlexGrid1.Rows - 1
FixRest
End Sub
Private Sub cmdNext_Click()
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
FixRest
End Sub
Private Sub cmdPrevious_Click()
MSFlexGrid1.Row = MSFlexGrid1.Row - 1
FixRest
End Sub
Private Sub Form_Load()
Dim i As Integer
MSFlexGrid1.Rows = MSFlexGrid1.FixedRows
MSFlexGrid1.AllowBigSelection = False
MSFlexGrid1.RowSel = MSFlexGrid1.Row
MSFlexGrid1.FocusRect = flexFocusNone
For i = 1 To 20
MSFlexGrid1.AddItem i & vbTab & "Item " & i
Next
cmdFirst_Click
MSFlexGrid1_RowColChange
End Sub
Sub FixRest()
MSFlexGrid1.Col = 0
MSFlexGrid1.ColSel = MSFlexGrid1.Cols - 1
MSFlexGrid1.RowSel = MSFlexGrid1.Row
MSFlexGrid1.TopRow = MSFlexGrid1.Row
End Sub
Private Sub MSFlexGrid1_RowColChange()
cmdFirst.Enabled = (MSFlexGrid1.Row > MSFlexGrid1.FixedRows)
cmdPrevious.Enabled = cmdFirst.Enabled
cmdLast.Enabled = (MSFlexGrid1.Row < MSFlexGrid1.Rows - 1)
cmdNext.Enabled = cmdLast.Enabled
End Sub
Option Explicit
Private Sub cmdFirst_Click()
MSFlexGrid1.Row = MSFlexGrid1.FixedRows
FixRest
End Sub
Private Sub cmdLast_Click()
MSFlexGrid1.Row = MSFlexGrid1.Rows - 1
FixRest
End Sub
Private Sub cmdNext_Click()
MSFlexGrid1.Row = MSFlexGrid1.Row + 1
FixRest
End Sub
Private Sub cmdPrevious_Click()
MSFlexGrid1.Row = MSFlexGrid1.Row - 1
FixRest
End Sub
Private Sub Form_Load()
Dim i As Integer
MSFlexGrid1.Rows = MSFlexGrid1.FixedRows
MSFlexGrid1.AllowBigSelection = False
MSFlexGrid1.RowSel = MSFlexGrid1.Row
MSFlexGrid1.FocusRect = flexFocusNone
For i = 1 To 20
MSFlexGrid1.AddItem i & vbTab & "Item " & i
Next
cmdFirst_Click
MSFlexGrid1_RowColChange
End Sub
Sub FixRest()
MSFlexGrid1.Col = 0
MSFlexGrid1.ColSel = MSFlexGrid1.Cols - 1
MSFlexGrid1.RowSel = MSFlexGrid1.Row
MSFlexGrid1.TopRow = MSFlexGrid1.Row
End Sub
Private Sub MSFlexGrid1_RowColChange()
cmdFirst.Enabled = (MSFlexGrid1.Row > MSFlexGrid1.FixedRows)
cmdPrevious.Enabled = cmdFirst.Enabled
cmdLast.Enabled = (MSFlexGrid1.Row < MSFlexGrid1.Rows - 1)
cmdNext.Enabled = cmdLast.Enabled
End Sub
作者: patrickkong 发布时间: 2011-07-25
相关阅读 更多
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28