I just took a glance at your project. There's a TON of forms there. On which form is the error appearing?
BTW. You don't have a control array of data controls, do you? If so, your events would need to include the index number.
FYI: data controls are not kind to your database- by default, they each open their own separate connection to the database (very inefficient) and they are inflexible. I would recommend that you change over to data objects. Remember, friends don't let friends use data controls...
Last edited by loquin; 05-25-07 at 13:56.
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert
this reply is 2 years late for the original user marooned
But I found his post because I have the same problem 2009-10-08
He had this problem
Private Sub Adodc1_MoveComplete(ByVal dReason As ADODB.EventReasonEnum,
ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As
Procedure declaration does not match description of event or procedure having the same name
so do I.
I found a solution or work around
1- I declared in my form
Dim WithEvents db As ADODB.Recordset
2- then so that the form reseives event from Adodc I did this
Private Sub Form_Load()
Set db = Adodc1.Recordset
Now when i select db in forms object i can see the events and they are generated automatic
Private Sub db_MoveComplete(ByVal adReason As ADODB.EventReasonEnum,
ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
MsgBox "It works"
So I had this same problem a few years ago but I abandoned.
I hope that this will help the next one that gets the same error message