Good morning,
I have a stored procedure in Sql Server 2000 that accepts 2 input parameters. It is linked to an Access 97 DB as a pass through query, which is named qryCompanies. I am attempting to call this query from a button on a form where the user will input the parameters in 2 text boxes, which will be called forms!frmReportMenu!txtBeginDate and frmReportMenu!txtEndDateDate, and then click the button. After the user clicks this button, the form will be filtered by the pass through filter.
I have attempted to use QueryDef and parameters in VBA, but I haven't had any success. Any help or ideas with this issue would be greatly appreciated.
Thanks in advance for your help.
Sydney
I have a stored procedure in Sql Server 2000 that accepts 2 input parameters. It is linked to an Access 97 DB as a pass through query, which is named qryCompanies. I am attempting to call this query from a button on a form where the user will input the parameters in 2 text boxes, which will be called forms!frmReportMenu!txtBeginDate and frmReportMenu!txtEndDateDate, and then click the button. After the user clicks this button, the form will be filtered by the pass through filter.
I have attempted to use QueryDef and parameters in VBA, but I haven't had any success. Any help or ideas with this issue would be greatly appreciated.
Thanks in advance for your help.
Sydney