1.你可以在模块中用Public 变量
在窗体中都可以调用了Public Rs As New ADODB.Recordset
With Rs
If .State = adStateOpen Then
.Close
End If
.ActiveConnection = adoCN
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockBatchOptimistic
.Source = "SELECT * FROM dm_client "
.Open
End With2.保存
Rs.update
Rs.updateBatch
在窗体中都可以调用了Public Rs As New ADODB.Recordset
With Rs
If .State = adStateOpen Then
.Close
End If
.ActiveConnection = adoCN
.CursorLocation = adUseClient
.CursorType = adOpenDynamic
.LockType = adLockBatchOptimistic
.Source = "SELECT * FROM dm_client "
.Open
End With2.保存
Rs.update
Rs.updateBatch
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货