我想用vb连接access数据库的表std,然后把记录显示在文本框txtnumber,txtname,txtsex ,txtbirthday,txtpolicy,txtlikeanimal ,txtreward上,当运行后文本框没显示记录,为什么,应如何修改代码?Private Sub Form1_Load()Dim con As New ADODB.ConnectionDim rs As New ADODB.Recordsetcon.open "Provider=Microsoft.Jet.OLEDB.3.51;Data Source=L:\student.mdb;"rs.open "std", con, adcmdtabletxtnumber = rs.field(1)txtname = rs.field(2)txtsex = rs.field(3)txtbirthday = rs.field(4)txtpolicy = rs.field(5)txtlikeanimal = rs.field(6)txtreward = rs.field(7)End Sub
參考答案:提示你“未找到方法”了么?
关键字错误:
rs.field(1)应为:rs.Fields(1)