parameter passthrough query

M

Manju

In a pass-through query we are calling a stored procedure. How do we pass
forms data as a parameter to the Stored Procedure.
I tried this
Execute spr_3abcdAddUpdtQueries([Forms]![ProcessDates]![StartDate] ,
[Forms]![ProcessDates]![EndDate])

it is not able to recognize the parameters.
 
D

Duane Hookom

I use some DAO code to modify the sql property of the saved pt query

Dim strSQL as String

strSQL = "Execute spr_3abcdAddUpdtQueries '" &
[Forms]![ProcessDates]![StartDate] & "' ,'" &
[Forms]![ProcessDates]![EndDate] & "'"

CurrentDb.QueryDefs("qsptNameOfPT").SQL = strSQL
 

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 automate update on weekly reports spreadsheet 0
Access pass-through query to Oracle 10g stored procedure - results 1
passthrough query question 1
ODBC Pass-through query with parameter from table 5
Parameter date format 7
Pass Through Quiery 4
Running a stored parameter query from a form without pop up boxes. 6
Pass Parameter to stored procedure in pass thru query 7

Top