Hello,
I'm trying to run a Do.Cmd open stored procedure that takes two arguments. The arguments are global variables that were set in Access during an Event procedure. I can't seem to get the syntax of this method. The SQL Server arguments are named the same as VBA Globals. Without the arguments it runs just fine, but with it's a different story. Thank you in advance

DoCmd.OpenStoredProcedure "spEVA_Export @EndDate='" & EndDate & "', @Account1='" & Account1 & "'"

The problem probably has to do with taking the values into the string at run time. SQL Server doesn't like this. Try this:


Dim dtEnd As Date
Dim sAccount As String
Dim sSQL As String

dtEnd = Me.EndDate
sAccount = Me.Account

sSQL = "spEVA_Export @EndDate='" & EndDate & "', @Account1='" & Account1 & "'"

DoCmd.OpenStoredProcedure sSQL

This might work. Sorry for the duplicate code.




mmcdonal