hello!

first I want to thank everybody for answering my questions. I found this forum very helpful.

New problem I ran into:

When I am trying to execute store procedures with optional parameters i am getting run time error:

"Prepared statement '(@P1 int output, @P1 int) EXEC
@P1 = dbo.spSeect' expects parameter @P2,
which was not supplied"

Error handling doesn't help. even if I specify exact Err.Number

In the end of the following code is the place where error executes:

With oDeVe.Commands ("dbo_RptGEN_SelectTransactionList").Parameters
.Refresh

If Not oReport.Batch = 0 Then
.Item("@Batch") = oReport.Batch
End If

End With

oDeVe.Commands("dbo_RptGEN_SelectTransactionList").Execute

---------

mybe somebody had the same issue or can refer me into right direction or (even better) fix it. :-))
Thanks