1,216
社区成员
发帖
与我相关
我的任务
分享
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\jsyxxgl.mdb"
rs.Open "select * from Main_User", conn, 2, 2
Private Sub Command3_Click()
If rs.EOF Then
MsgBox "已到末记录", 48, "记录浏览"
Else
rs.MoveNext
Call display
End If
End Sub
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.CursorLocation = adUseClient '<-
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\jsyxxgl.mdb"
rs.Open "select * from Main_User", conn, 2, 2
2)rs.Open 之后判断一下记录是否为空,如果为空 Command3 就不能操作。Private Sub Command3_Click()
rs.MoveNext
If rs.EOF Then
MsgBox "已到末记录", 48, "记录浏览"
Else
Call display
End If
End Sub