pass user entered values to stored procedure with parameters

M

mevert

My working environment is: SQL Server 7.0, Microsoft Access 2000 Project

I want text boxs on the form to supply the necessary parameters for a stored
procedure. This procedure inserts the supplied values into a table.

The users enter the required values into a text box, and then I want to be
able to have them click a command button which will run the stored procedure
and supply the user entered values to the stored procedure.

Help! I am new to this environment and need help. All I need is the vb
code which will allow the user entered values to be passed to the stored
procedure and run the procedure.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to pass parameter values to stored proc using cmd btn on form 0
Shell command produces a "Run-time error '5': Invalid procedure call or argumen 0
Stored Procedure in Access 4
How to call a stored procedure with paramters in SQL Server Express 2008, using code 3
Using Stored Procedures With Access Data Project 2
From Access how to create stored procedure in SQL server 4
Word macro that can call cells out of Excel for a find and replace 0
Getting a Return Value from a Stored Procedure in VBA 2

Top