I want the user to enter the month into the input box: Example: Nov
My parameter in sql is named: @Commissionsmonth
I know my sp works if ran within sql. Any help with this would be greatly appreciated!
returnvalue=MsgBox ("ARE YOU SURE YOU WANT TO UPDATE COMMISSIONS PAID?",36,"CONFIRM UPDATE!!")
If returnvalue=6 Then
Dim cmd
Dim sp
sp = "asp_update_commissions_paid"
Set cmd = CreateObject("ADODB.Command")
With cmd
.ActiveConnection = "Provider=sqloledb;Data Source=myserver;Initial Catalog=mydatabase;Integrated Security=SSPI"
.CommandType = 4
.CommandText = sp
sInput = InputBox("Enter Month being Paid")
returnvalue=MsgBox ("Commissions Paid has been updated",36,"CONFIRM UPDATE!!")
.Execute
End With
Set cmd = Nothing
End If