往GRID對應的RECORDSET插入數據。回車,在文本框之間跳轉,就不用說了吧。
解决方案 »
- 如何用API得到和修改某个文件的属性摘要(例如:主题、作者、关键字、备注等)
- 求简洁易用的商业进销存软件
- 采集数据的刷新问题?
- 如何去掉command上的虚线框阿?
- 请问处理事务时,connection的Cursorlocation一定要用adUseServer,不能用adUerClient吗?
- grid控件在哪儿?我找不到
- 如何去掉excel中的回车符号??
- 没有人回答么 还请大家回答按一下
- 小弟有一个存图片的问题,请各位大哥帮忙!!
- 不会吧,这种问题也没人来....
- HAP_SetupFactory7 那里有能用的下载?汉化新世纪那里下的卡巴斯基检测有病毒。。。
- 请问调用DTpicker是部件的哪个工具?
if keycode=13 then
text1(1).setfocus
endif
Private Sub MSHF1_DblClick()
On Error Resume Next
Dim Response As String
CurRow = MSHF1.Row - 1
CurCol = MSHF1.Col - 1
DE.rstd.MoveFirst
DE.rstd.Move (CurRow)
If CurCol = 3 Or CurCol = 4 Then
Response = InputBox("请输入" & MSHF1.TextMatrix(0, CurCol + 1), "黄花菜", MSHF1.TextMatrix(CurRow + 1, CurCol + 1))
If Len(Response) = 0 Then
DE.rstd.Fields(CurCol) = MSHF1.TextMatrix(CurRow + 1, CurCol + 1)
Else
DE.rsutd.Fields(CurCol) = Response
End If
Else
Response = InputBox("请输入" & MSHF1.TextMatrix(0, CurCol + 1), "黄花菜", MSHF1.TextMatrix(CurRow + 1, CurCol + 1))
If Len(Response) = 0 Then
DE.rstd.Fields(CurCol) = MSHF1.TextMatrix(CurRow + 1, CurCol + 1)
Else
DE.rstd.Fields(CurCol) = Val(Response)
End If
End If
DE.rstd.Update
Call Conn
End SubSub Conn()
MSHF1.Clear
Set MSHF1.DataSource = DE.rstd
End SubPrivate Sub MSHF1_EnterCell()
'单击某一单元时,改变该行颜色
Dim i_Col As Integer
Dim c_col As Integer
c_col = MSHF1.Col
If c_col > 0 Then
For i_Col = 0 To MSHF1.Cols - 1
MSHF1.Col = i_Col
MSHF1.CellBackColor = &HC0FFFF
Next i_Col
MSHF1.Col = c_col
End If
End Sub
Private Sub MSHF1_LeaveCell()
'当某一行失去焦点时,改变该行颜色
Dim i_Col As Integer
Dim c_col As Integer
c_col = MSHF1.Col
For i_Col = 0 To MSHF1.Cols - 1
MSHF1.Col = i_Col
MSHF1.CellBackColor = vbWhite
Next i_Col
MSHF1.Col = c_col
End Sub