我用dao控件做了个通讯录,在access2000中我设置姓名为主键,当“添加”->“保存”时,怎样来判断输入的姓名与以前的数据是否重复?
我用查找:
Data1.Recordset.FindFirst "Name='" & Text1.Text & "'"
If Form1.Data1.Recordset.NoMatch Then
......endif
可是不行,请高手指点!谢谢!
我用查找:
Data1.Recordset.FindFirst "Name='" & Text1.Text & "'"
If Form1.Data1.Recordset.NoMatch Then
......endif
可是不行,请高手指点!谢谢!
Dim mrec As Recordset
Dim lsstr, sqlstr As String
Set mrec = ClassData.Recordset
lsstr = ClassDBCombo.Text
If lsstr = "" Then GoTo mend
mrec.MoveFirst
mrec.FindFirst ("班级 = '" & lsstr & "'")
If mrec.NoMatch Then GoTo mend
mend: