Pass thru query help

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a reporting system I created that links to a SQL
server 2000 database. I would like to start using SQL
stored procedures to run some very complex reports.

I can create a pass thru query that will run the SP. But I
have 2 issues.
1) I can not pass parameters from a form (start and end
dates for example) to it.
2) when I hit the button to run it, it asks for an ODBC
connection. (I need this Automatic)
The tables are linked already thru an ODBC connection but
the pass thru does not seem to see it.

Any help would be greatly appreciated.
Joe
 
Hi,
If you build your sql for the pass-thru in your form,
(on click event when you hit the button?), you should be
able to add your parameters.
If you open your pass thru query in design view, then
click on properties, you should be able to put your odbc
connection info in there.

HTH
 
Back
Top