Pass Through Query - Parameters?

[ssecca]

I have a pass-through query that has two dates as parameters. The problem is those dates need to be changeable. I thought it would be a simple VBA statement to just delete the old query and create a new one as and when needed. It appears it is not, or I am missing a key point. Is there a simple way to call a SQL procedure with changing parameters. I want this pass-through to be available for a report.

Thanks

 

[padinka]

Have you looked at this?

http://support.microsoft.com/kb/q131534/

Also, if your report runs at specific intervals, weekly, monthly, etc you can caluclate the dates in the stored procedure instead of manually entering the dates.


Trisha
padinka@yahoo.com

 

[dhookom]

I create a basic pass-through query and then use DAO to change the SQL property.

Dim strSQL as String
strSQL = "EXEC stpMySP '" & Me.txtStartDate & "', '"& _
    Me.txtEndDate & "'"
CurrentDb.QueryDefs("qsptMyPT").SQL = strSQL

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]