为什么类型不匹配??
有这样一段代码:
Option Explicit
Dim db As Database
Dim rs As Recordset
Dim full As String
Dim cn As New ADODB.Connection
Private Sub Combo1_Click()
Set rs = db.OpenRecordset("select 朋友 from 联系 where 城市='" & Combo1.Text & "'")
Combo2.Clear '由于要重新加入成员,所以把之前的成员清除
Do While Not rs.EOF
Combo2.AddItem rs.Fields("朋友")
rs.MoveNext
Loop
Label3.Caption = Combo1.Text
End Sub
Private Sub Command1_Click()
If Combo1 = full Or Combo2 = full Or Text1 = full Then '检测是否未选择信息
MsgBox "信息不完整,请重新选择完整信息"
Else
cn.Execute "INSERT INTO 纪录(城市,朋友,备注) valueS('" + Combo1.Text + "','" + Combo2.Text + "','" + Text1.Text + "')"
End If
Combo2.Clear
Text1.Text = ""
Label3.Caption = ""
Label4.Caption = ""
Label5.Caption = ""
End Sub
'++++++++++++++++++以下是出问题地方!!!!!!!!!!!
Private Sub Form_Load()
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;Persist Security Info=False" '连接字符串的数据库路径可能有错,最好用相对路径
cn.Open
Set db = OpenDatabase(App.Path + "\db.mdb")
Set rs = db.OpenRecordset("select 城市 from 联系 group by 城市") '++++就是这句!!!
Do While Not rs.EOF
Combo1.AddItem rs.Fields("城市")
rs.MoveNext
Loop
End Sub
'++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
'以上是录入的例子
问题是当这个Form单独运行的时候,没有一点毛病,很正常!,但是当我把整个表单插入另外一个工程中的时候:Set rs = db.OpenRecordset("select 城市 from 联系 group by 城市") 这句就出现“类型不匹配”的错误,很奇怪?诸位高手帮我解答一下吧,谢谢!!