SQL Server Stored Procedure

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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial