How to run Stored Procedure from a Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just a simple question

How to run Stored Procedure from a Form

I am new to Access Project.
My Access Project is connected to SQL Server.

Any answer is highly appreciated.

Rgds,
Agus Budianto
 
Hi,

if you are trying to run a stored procedure without returning data.

1. docmd.runSQL("EXEC storedprocedurename")

2. currentproject.connection.execute("EXEC storedprocedurename")

if you are trying to return records then

adoTable.open "myStoredProcedureName", currentproject.connection,
cursortype, locktype

Hope it helps.
 
You must log in or register to reply here.

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

Referring Form Control in Access Project View 4
SELECT . . . INTO in SQL 16
Stored Procedure, Forms and Input Parameters 3
Prevent User from editing record directly in the table 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
how to pass parameters from forms to stored procedures 21
From Access how to create stored procedure in SQL server 4

Back
Top