出错代码:
rs.Open "select email from shift where shift='" & lblShift.Caption & "' ", cn
If Not rs.BOF Then
If rs("email") <> "" Then strEmail1 = rs("email")
End If
rs.Close
错误
run-time error '424'
object required
rs.Open "select email from shift where shift='" & lblShift.Caption & "' ", cn
If Not rs.BOF Then
If rs("email") <> "" Then strEmail1 = rs("email")
End If
rs.Close
错误
run-time error '424'
object required
set Cnn = new ADODB.Connection
set Rs = new ADODB.Recordset
if not isnull(rs("email")) then strEmail1 = rs("email")
或者:
Dim rs As ADODB.Recordset
然后
Set Rs = new ADODB.Recordset
If Not rs.BOF Then
If rs("email") & "" <> "" Then strEmail1 = rs("email")
End If
rs.Close