Data Access Pages in Microsoft Access

[Joannatang]

I have created a Data Access Page for one of my web pages and I inserted a pivot table. It has parameters, say to enable the user to add a date between 01/01/2004 and 01/07/2004, and then all the results will be displayed between those specified dates. It works fine with one table.

But, if I want to add another pivot table with the same parameters, the user has to insert the parameters twice but I just want to show it once, is there a way to avoid this???? I really want to add 7 pivot tables on the same page and I think the user will get a bit annoyed at having to do enter the parameters over and over again.....

Please help! Thanks!
:wave:

[Joannatang]

Still having the same problem and thinking of another way round it....still need your help though!!!!!!

From an ASP page...with two variable text fields named date1 and date2 as the two dates to enable the user to enter the two dates....
How do you pass the variables entered from the ASP Page to the Data Access Page??????

I know that I need to change the following code from the Data Access Page to read in the variables from the ASP Page:

<a:SchemaParameter id=&quot;[Date1]&quot; datatype=&quot;202&quot;/>

<a:SchemaParameter id=&quot;[Date2]&quot; datatype=&quot;202&quot;/>

Thx

:wave:

[degsy]

You can use javascript to duplicate the parameters entered in the first field into the others.

[Joannatang]

How??

I am not familiar with Javascript

:wave:

[degsy]

Here is a simple version


<input type="text" name="textfield" onchange="textfield2.value = this.value"/>
<input type="text" name="textfield2" />