Execute and Open stored Procedure in vba

Asked Dec 05 '14 at 08:48

Active Dec 05 '14 at 11:00

Viewed 678 times

I have a question, I have a form with a button that loads a Stored procedure in VBA access, I implemented code to execute this stored procedure with one parameter, how can I open it immediately when I execute. I wrote some code but it doesn't work:

 Dim strSQL As String
 Dim stDocName As String
 Dim rst As New ADODB.Recordset

    strSQL = "EXEC Verificare_amenzi_firma '" & Me.CodF & "'"

       Call AttServ(strSQL, rst) 'Execute query

stDocName = "Verificare_amenzi_firma"
DoCmd.OpenStoredProcedure stDocName, acViewNormal, acEdit

edited Dec 05 '14 at 11:00

Wouter

asked Dec 05 '14 at 08:48

SoftSergios

What exactly do you mean by `Stored Procedure`? Access doesn't necessarily have them. – Mark C. Dec 05 '14 at 13:27
i have an Access interface connected to SQL tables – SoftSergios Dec 05 '14 at 14:37
1

http://stackoverflow.com/questions/18800727/ms-access-call-sql-server-stored-procedure – Mark C. Dec 05 '14 at 15:31

Execute and Open stored Procedure in vba

0 Answers0