Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Passing parameters to stored procedures in code
The declarations I have made in the Access program are: Dim startdate As Date Dim enddate As Date Dim con As New ADODB.connection Dim cmd As New ADODB.Command Dim rs As New ADODB.Recordset Dim param1 As Parameter Dim param2 As Parameter My connection is made using: strcon = "driver={sql...- pskettle
- Post #10
- Forum: Microsoft: Access Project (ADP)
-
Passing parameters to stored procedures in code
I have been using the code explained in this article to pass some date parameters to my SQL stored procedure however I get the error data ype mismatch on the following line Set param1 = cmd.CreateParameter("startdate", adDBDate, adParamInput) The code is in a MS Access 2000 database...- pskettle
- Post #8
- Forum: Microsoft: Access Project (ADP)
