If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pass Through Query
Hello. I am using a pass through query to return a resultset. I am trying to limit my resultset by using dates entered on a form. I tried to reference the date boxes on my form to accept input to the query, but query refuses to run. SQL Server thrown up on me. My only recourse is to create a connection to the DB under the form and embed my entire SQL statement in VBA, but it is long query. I appreciate any suggestion. My goal is for the passthrough query to accept 2 dates entered on a form so the dataset is limited. Thank you.
-Toco- |
#2
|
|||
|
|||
Pass Through Query
You can use DAO to change the SQL of the pass-through query...
CurrentDb.QueryDefs("qsptYourPT").SQL = "SELECT...." -- Duane Hookom MS Access MVP "Toco" wrote in message ... Hello. I am using a pass through query to return a resultset. I am trying to limit my resultset by using dates entered on a form. I tried to reference the date boxes on my form to accept input to the query, but query refuses to run. SQL Server thrown up on me. My only recourse is to create a connection to the DB under the form and embed my entire SQL statement in VBA, but it is long query. I appreciate any suggestion. My goal is for the passthrough query to accept 2 dates entered on a form so the dataset is limited. Thank you. -Toco- |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hidden files in Ms-Query cause ODBC connect errors or Query is wac | needyourhelp | General Discussion | 4 | July 12th, 2004 09:38 PM |
Pass Through Query Parameters | Stacy | Running & Setting Up Queries | 3 | July 8th, 2004 03:55 PM |
syntax to run PL/SQL stored proc via ms access pass through query | Edwinah63 | General Discussion | 2 | June 23rd, 2004 03:47 AM |
pass parameter from one query to another query? | SWu | General Discussion | 3 | June 10th, 2004 09:49 AM |
pass through parameter query into Oracle | teri | Running & Setting Up Queries | 1 | May 27th, 2004 09:33 PM |