Dim sql, a As String
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\bxd\data.mdb;Persist Security Info=False"
sql = "select TxtPicPath from picture where id='1' "
rs.Open sql, conn
a = rs.Fields(0)
提示说标准表达试中数据类型不匹配,取不出TxtPicPath字段的值,请问什么原因啊?是不是a的类型不对啊?该怎么改呢?谢谢
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\bxd\data.mdb;Persist Security Info=False"
sql = "select TxtPicPath from picture where id='1' "
rs.Open sql, conn
a = rs.Fields(0)
提示说标准表达试中数据类型不匹配,取不出TxtPicPath字段的值,请问什么原因啊?是不是a的类型不对啊?该怎么改呢?谢谢
Private Sub Form_Load()
Dim sql, a As String
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\bxd\data.mdb;Persist Security Info=False"
sql = "select TxtPicPath from picture where id='1' "
rs.Open sql, conn, 3, 3
a = Trim(rs(0) & "")
ImgPicture.Picture = LoadPicture(a)
End Sub
我想使图片框显示a路径对应的照片
Private Sub Form_Load()
Dim sql, a As String
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\bxd\data.mdb;Persist Security Info=False"
sql = "select TxtPicPath from picture where id='1' " '这里id='1' 改变为id =1 试试
rs.Open sql, conn, 3, 3
a = Trim(rs(0) & "")
ImgPicture.Picture = LoadPicture(a)
End Sub
我想使图片框显示a路径对应的照片
如果是数字格式,不用加单引号的!!
2、你的TxtPicPath字段是能够转换为字符型的数据类型吗?如不是就要修改