Have ace deliver!!!!!! I am novice,,,
Private Sub Form_Unload (Cancel As Integer)
Screen. MousePointer=vbDefault
End Sub
Private Sub datPrimaryRS_Error (ByVal ErrorNumber As Long, the Description As String, ByVal Scode As Long, ByVal Source As String, ByVal HelpFile As String, ByVal HelpContext As Long, fCancelDisplay As Boolean)
'error handling code in the
'want to ignore the error, comment out the next row
'want to capture them, in the add code to handle them
MsgBox "Data error event hit err:" & amp; The Description
End Sub
Private Sub datPrimaryRS_MoveComplete (ByVal adReason As ADODB. EventReasonEnum, ByVal pError As the ADODB library Error, adStatus As the ADODB library EventStatusEnum, ByVal pRecordset As the ADODB library you)
"For this you display the current record position
DatPrimaryRS. Caption="Record:" & amp; CStr (datPrimaryRS. You. AbsolutePosition)
End Sub
Private Sub datPrimaryRS_WillChangeRecord (ByVal adReason As ADODB. EventReasonEnum, ByVal cRecords As Long, adStatus As the ADODB library EventStatusEnum, ByVal pRecordset As the ADODB library you)
'validation code in the
The following action occurs when the event is called '
Dim bCancel As Boolean
The Select Case adReason
Case adRsnAddNew
Case adRsnClose
Case adRsnDelete
Case adRsnFirstChange
Case adRsnMove
Case adRsnRequery
Case adRsnResynch
Case adRsnUndoAddNew
Case adRsnUndoDelete
Case adRsnUndoUpdate
Case adRsnUpdate
End the Select
If bCancel Then adStatus=adStatusCancel
End Sub
Private Sub cmdAdd_Click ()
On Error GoTo AddErr
DatPrimaryRS. You. AddNew
The Exit Sub
AddErr:
MsgBox Err. The Description
End Sub
Private Sub cmdDelete_Click ()
On Error GoTo DeleteErr
With datPrimaryRS. You
. Delete
. MoveNext
If. EOF Then. MoveLast
End With
The Exit Sub
DeleteErr:
MsgBox Err. The Description
End Sub
Private Sub cmdRefresh_Click ()
'only multi-user applications need
On Error GoTo RefreshErr
DatPrimaryRS. Refresh
The Exit Sub
RefreshErr:
MsgBox Err. The Description
End Sub
Private Sub cmdUpdate_Click ()
On Error GoTo UpdateErr
DatPrimaryRS. You. UpdateBatch adAffectAll
The Exit Sub
UpdateErr:
MsgBox Err. The Description
End Sub
Private Sub cmdClose_Click ()
Unload Me
End Sub
Download the source code, one of the user control emerged: [Microsoft] [ODBC Microsoft Access driver] parameter is insufficient, 8 is looking forward to?
Have ace deliver!!!!!! I novice,,,
CodePudding user response:
To confirm registration for control?Confirm the correct quote?
The location of the error?
CodePudding user response:
When something goes wrong, click run, or click on the open the user control, file on the right-hand side of the uc suppliers, file suffix for CTL,
Confirm register controls the???????
Confirm the correct quote????? How to operate?
CodePudding user response: