Error message with Calling Stored procedure with parameter

[hedgracer]

I have the following VBA code:

Dim strMonth As String

strMonth = Me.cboOnyxAllocationHistoryMonth.Value


strCnxn = set_connection()
Set cnxn = New ADODB.Connection
cnxn.Open strCnxn
strSQL_Execute = "dbnyx_Allocation_Report_Creation " & strMonth

MsgBox strSQL_Execute
cnxn.Execute strSQL_Execute, , adExecuteNoRecords

The parameter being passed in strMonth is "02/28/2010". When I run the stored procedure in SQL Server 2005 the procedure runs just fine. The error message I get is as follows:

Incorrect syntax near '/'.

This error message is coming from the following line:

cnxn.Execute strSQL_Execute, , adExecuteNoRecords

I have never run into this before and have googled this to death. Any help on this is greatly appreciated. Thanks.

Dave

 

[SkipVought]

Please post the string value in strSQL_Execute (your SQL).



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[hedgracer]

The complete strSQL_Execute is as follows:

dbnyx_Allocation_Report_Creation 02/28/2010

 

[SkipVought]

That is NOT your SQL!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}