We help IT Professionals succeed at work.

SQL Server Stored Procedure

Need to call a field name  from a form textbox in Access within my SS Stored Procedure.  How can I do this?
Watch Question

The stored procedure has no knowledge of anything in access. The approach is usually to pass it as a parameter to the stored procedure
Dim SQL as string
SQL = "EXEC     [dbo].[usp_myStoredProc] " & _
                    "@MyNamedInputParameter = " & Me.txt_amount & "'"

Open in new window

ste5anSenior Developer

What Access version? What kind of Access project?


Version 10