MS Access getting data from SQL server databases using stored proc

G

Guest

Hi,

I am trying to use a stored procedure created in MZ Access to retieve data
from an SLQ server databse.

I have the query working fine with parameters, but I need it to get the
input parameter from a user form with a combo box on it.

Stored Procedure:ALTER PROCEDURE dbo.StoredProcedure1
(@Assignee varchar(25))
AS SELECT Call, Status, Assignee, LoggedBy, DateRaised, DateCompleted,
Request, Action, SysDateChanged
FROM dbo.SKYSQL02_Envisage_dbo_HD_Call
WHERE (Assignee = @Assignee) AND (NOT (Status IN ('completed',
'Decline/Cancel')))
ORDER BY DateRaised DESC
 
D

Duane Hookom

You create a pass-through query with the parameter. Then use code to modify
the SQL property of the saved query to update the parameter.

CurrentDb.QueryDefs("qsptYourPT").SQL = "EXEC StoredProcedure1 " &
Me.txtAssignee
or
CurrentDb.QueryDefs("qsptYourPT").SQL = "EXEC StoredProcedure1 '" &
Me.txtAssignee & "'"
 

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

Access data from SQL Server 1
returning data from a Stored Procedure 2
Accessing SQL Server Stored Procedure from Access 1
Critique my LINQ to SQL strategy using stored procs, please 5
Parameter mismatch between ACCESS and SQL server 3
Calling SQL Stored Proc from Access (with Parameters) 9
Execute SQL Server 2000 stored procedure from Access 2000 1
How to call a stored procedure with paramters in SQL Server Express 2008, using code 3

Top