Pass through query to SQL Stored Proc, pass parameter

[urir10]

Hi all,

First post here and i have a question.

I currently have a pass through query the run a stored proc from sql.
The Stored proc take 1 parameter which is the timeid. In our access DB file we have a table called DateStamp that holds the time is for the current period.

How do i call the stored proc from sql while passing it the value from the date stamp table (which is only 1 row and hold the time id value)?

my current code is :

Exec  p_TMIreport @iTimeId=201208

 

[mdlueck]

To run a Stored Procedure (SP) via a DAO.QueryDef object use the following example:

Replace pass-through DAO.QueryDef with DAO execution of Stored Procedure Q's - NoCount and SQL EXEC method
http://www.access-programmers.co.uk/forums/showthread.php?t=223414#post1140657


To run a SP with ADO.Command / .Parameters objects use the following example:

Using VBA ADO objects to execute a Stored Procedure (INSERT)
http://www.access-programmers.co.uk/forums/showthread.php?t=216860#post1104120