Very Computer

Hello all,

I declare a connection object in a class module.
However, the willexecute event of the connection failed to load.

Sub cnn_WillExecute(ByVal Source As String, CursorType As
ADODB.CursorTypeEnum, LockType As ADODB.LockTypeEnum, ByVal Options As Long,
adStatus As ADODB.EventStatusEnum, pCommand As ADODB.Command, pRecordset As
ADODB.Recordset, pConnection As ADODB.Connection)

The system return
Procedure declaration does not match description of event or procedure
having the same name.
I get the above function parameter list from MSDN, so it couldn't go wrong.

Can anyone please help.

regards,
Steve

Hi,

Your ByVal and ByRef statements are incorrect in some
event's parameters. Make a copy of you event code. Delete
current declaration of that event procedure. Redefine it
again and place code back to event procrdure.

Val

Quote:>-----Original Message-----
>Hello all,

>I declare a connection object in a class module.
>However, the willexecute event of the connection failed
to load.

>Sub cnn_WillExecute(ByVal Source As String, CursorType As
>ADODB.CursorTypeEnum, LockType As ADODB.LockTypeEnum,

ByVal Options As Long,

Quote:>adStatus As ADODB.EventStatusEnum, pCommand As

ADODB.Command, pRecordset As

Quote:>ADODB.Recordset, pConnection As ADODB.Connection)

>The system return
>Procedure declaration does not match description of event
or procedure
>having the same name.
>I get the above function parameter list from MSDN, so it
couldn't go wrong.

>Can anyone please help.

>regards,
>Steve

>.