资料表在ACCESS库中。 我的VB源码是 Private ADOcn As Connection Private Sub Command1_Click() Dim strSQL As String Dim ADOrs As New Recordset 'ADOrs.ActiveConnection = ADOcn strSQL = "Select * From资料表 Where PartNo=" + " ' " + Text1 + " ' ADOrs.OpenstrSQL" If Not ADOrs.EOF Then Text2 = ADOrs.Fields("PartNo") Text3 = ADOrs.Fields("LotNo") Text4 = ADOrs.Fields("工号") ' Else MsgBox "要查询的PartNo不存在,请重新输入!", vbOKOnly, "信息提示" Text1 = "" Text1.SetFocus End IfEnd SubPrivate Sub Command2_Click() Unload Me End SubPrivate Sub Form_Load() Dim cn As New ADODB.ConnectionADOcn.Open“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\lantest.mdb End Sub
我要查询的是,在文本框输入一个产品名称,按查询按钮,则在其它文本框自动显示LotNo,测试数量,测试人员,工号。
我的VB源码是
Private ADOcn As Connection
Private Sub Command1_Click()
Dim strSQL As String
Dim ADOrs As New Recordset
'ADOrs.ActiveConnection = ADOcn
strSQL = "Select * From资料表 Where PartNo=" + " ' " + Text1 + " ' ADOrs.OpenstrSQL"
If Not ADOrs.EOF Then
Text2 = ADOrs.Fields("PartNo")
Text3 = ADOrs.Fields("LotNo")
Text4 = ADOrs.Fields("工号")
' Else
MsgBox "要查询的PartNo不存在,请重新输入!", vbOKOnly, "信息提示"
Text1 = ""
Text1.SetFocus
End IfEnd SubPrivate Sub Command2_Click()
Unload Me
End SubPrivate Sub Form_Load()
Dim cn As New ADODB.ConnectionADOcn.Open“Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\lantest.mdb
End Sub
我都是通过VB6里面的一个数据工程中新建一个页面
这样在提示下找到数据源
这样可以生成code或控件化地界面