我把以下这段程序写在command.click()里
If rs.State = adStateOpen Then rs.Close
rs.Open "SELECT 物品名称,分类名称,数量 FROM 物品表 where 物品名称 = '" & DBCombo1.Text & "'", cn, adOpenDynamic, adLockOptimistic
Set MSFlexGrid1.DataSource = rs可是一运行,它就提示出错:
实时错误“91”
对象变量或with块变量未设置然后看见
Set MSFlexGrid1.DataSource = rs
这一句反黄色了请问我是错在哪里呢?
If rs.State = adStateOpen Then rs.Close
rs.Open "SELECT 物品名称,分类名称,数量 FROM 物品表 where 物品名称 = '" & DBCombo1.Text & "'", cn, adOpenDynamic, adLockOptimistic
Set MSFlexGrid1.DataSource = rs可是一运行,它就提示出错:
实时错误“91”
对象变量或with块变量未设置然后看见
Set MSFlexGrid1.DataSource = rs
这一句反黄色了请问我是错在哪里呢?
请问如果使在MSHFlexGrid的表格里信息居中显示呢?
如何使在MSHFlexGrid的表格里信息居中显示呢?
MSHFlexGrid.Col = c
MSHFlexGrid.CellAlignment = 1看它的帮助,指定行,指定列的对齐方式
因为我按msdn里的帮助 MSHFlexGrid1.CellAlignment 这个属性设置对齐方式 可是不管用
用.ColAlignment(0) = 4也不管用
郁闷!
不知道到底应该怎么做
====================================
MSFlexGrid根本不支持ADO的,何来Set MSFlexGrid1.DataSource = rs 啊?
MSHFlexGrid1.ColAlignmentFixed = 4
MSHFlexGrid1.ColAlignment = 4
MSHFlexGrid1.ColAlignment(1) = 4
MSHFlexGrid1.ColAlignmentFixed = 4
MSHFlexGrid1.ColAlignment = 4
MSHFlexGrid1.ColAlignment(1) = 4
这几句啊?
MSHFlexGrid1.ColAlignmentFixed = 4 (作用于表头)
MSHFlexGrid1.ColAlignment = 4 (作用于表中内容)
MSHFlexGrid1.ColAlignment(1) = 4 (作用于指定列)
End SubPrivate Sub Form_Load()
MSHFlexGrid1.Cols = 10
MSHFlexGrid1.Rows = 10
MSHFlexGrid1.TextMatrix(0, 2) = "A"
MSHFlexGrid1.TextMatrix(1, 2) = "B"
MSHFlexGrid1.TextMatrix(2, 2) = "C"
MSHFlexGrid1.TextMatrix(4, 5) = "D"End Sub
先付记录集然后居中