Dim rs3 As ADODB.Recordset
Private Sub Form_Load()
Set rs3 = cnn.Execute("select * from 销售单")
If Not rs3.EOF Then
Text1.Text = rs3.Fields("购货单位")
End If
End Sub
执行时提示“424要求对象”是怎么回事,望哪位高手能够帮忙解决,不胜感激!
cnn 在模块中已定义
Public cnn As New ADODB.Connection
cnn.open "Provider = MSDASQL.1; Persist Security Info=True; Initial Catalog=过磅信息; Data Source=B8C4A837C3544F8