how to pass parameter values to stored proc using cmd btn on form

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.
 

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

pass user entered values to stored procedure with parameters 0
Using Stored Procedures With Access Data Project 2
how to pass parameters from forms to stored procedures 21
DoCmd.TransferDatabase - how to remove stored logins 0
Stored Proc. Parameters 1
DoCmd.OpenStoredProcedure won't display altered proc 4
getting error in ADO in stored proc with two calls 0
Setting Connection Property to pass 3 parameters to an SQL Proc. 2

Top