A
Alejandro
I have write this code in form of access ADP file:
Private Sub Comando10_Click()
Dim pasa As Variant
Dim SQLt As String
Dim conta, fornec As Integer
conta = Me.conter
fornec = Me.forter
SQLt = "exec inse1 @conta='" & conta & "', @forne= '" & fornec & "' "
DoCmd.RunSQL SQLt
i have the message
incorrect synatx near '47' when i click teh buttom , if write this code
with one parameter in the store procedure the code works but when i include
the second dont work.
Thanks in advance
Alejandro Carnero
Private Sub Comando10_Click()
Dim pasa As Variant
Dim SQLt As String
Dim conta, fornec As Integer
conta = Me.conter
fornec = Me.forter
SQLt = "exec inse1 @conta='" & conta & "', @forne= '" & fornec & "' "
DoCmd.RunSQL SQLt
i have the message
incorrect synatx near '47' when i click teh buttom , if write this code
with one parameter in the store procedure the code works but when i include
the second dont work.
Thanks in advance
Alejandro Carnero