刚才调试了一下应改代码如下
option explicit
dim withevents rs as recordset
Private Sub rs_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, _
ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, _
ByVal pRecordset As ADODB.Recordset)
N = rs.AbsolutePosition
If N = 1 Then
cmdPrevious.Enabled = False
ElseIf N = rs.RecordCount Then
cmdNext.Enabled = False
Else
cmdPrevious.Enabled = True
cmdNext.Enabled = True
End If
试一下:
Dim rst As New ADODB.Recordset
Dim conn As New ADODB.Connection
dim number as integer
conn.Open "dsn=data"
rst.CursorLocation = adUseClient '这句必修有!
rst.Open "select * from weborder", conn
number = rst.AbsolutePosition 'recordset的一个属性