rs.Open " select kind_spec.kind_name 。", db, adOpenStatic, adLockReadOnlyMsgBox "查询完毕", vbCritical
MSHFlexGrid1.ColWidth(1) = 3500
Set MSHFlexGrid1.DataSource = rs
MSHFlexGrid1.Refresh这样在表格里显示的内容我更改不了,能不能我在MSHFLEXGRID的某个格子内可以更改数字然后再点个COMMOND就可以添加进数据库呢?
MSHFlexGrid1.ColWidth(1) = 3500
Set MSHFlexGrid1.DataSource = rs
MSHFlexGrid1.Refresh这样在表格里显示的内容我更改不了,能不能我在MSHFLEXGRID的某个格子内可以更改数字然后再点个COMMOND就可以添加进数据库呢?
MSHFlexGrid1.TextMatrix(2, 2) = "a"还可以改相关联的Rs记录集的内容MSHFlexGrid1表格的内容就会改变的!
With Flex
If (TextObj.Left + TextObj.Width) > (.Left + .Width - 255) Then
TextObj.Move 0, 0
.SetFocus
Exit Function
End If
TextObj.Top = .CellTop + .Top
TextObj.Left = .CellLeft + .Left
TextObj.Width = .CellWidth - 2 * Screen.TwipsPerPixelX
TextObj.Height = .CellHeight - 2 * Screen.TwipsPerPixelY
TextObj.Visible = True
TextObj.Text = .Text
TextObj.SelStart = 0
TextObj.SelLength = Len(TextObj.Text)
TextObj.SetFocus
End With
End Function/调用方法
EditCell MSHFLEXGRIDNAME, TEXTBOXNAME
然后在textbox失去焦点是赋值给单元格就行了
text框只要写意点辅助代码,是可以做到和直接在MSHFLEXGRID里面修改一样的效果的。自己找点资料看看吧