parameter query from data access page

A

Alice Dawson

I am trying to create a data access page which will allow a simple parameter
query. I found an explanation and example on the Microsoft website:

http://office.microsoft.com/assista...ID=HA010562821033&CTT=4&Origin=CH010713831033

I can just about follow most of the code; unfortunately I am stumped by the
part where the actual query takes place in the VBScript

"' This is the Jet syntax for adding the parameter values to the data source
control.
MSODSC.RecordsetDefs("Employee Sales by Country").parametervalues.Add
"[Starting Date]", pStartingDate
MSODSC.RecordsetDefs("Employee Sales by Country").parametervalues.Add
"[Ending Date]", pEndingDate
"
I don't understand what any of this means. pStartingDate and pEndingDate
are the criteria that have been entered in a previous page and stored in
cookies but I can't follow how they are being used in a query. Is anyone
willing to decipher this for me?

Alice
 

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

Parameter query in dap 1
Creating a Chart on form from selected data in query. 0
passing parameters to a web page 0
passing parameter to stored procedure 2
Data Access Page filtered table update 0
ParameterValues.add ..., ... is Ignored in Access 2003? 0
Problem with filtering query recordset from Data Access Page 1
Union Query requesting parameter 12

Top