Data Access Page from parameter Query

Data Access Page from parameter Query

Post by amFja2x » Sun, 19 Jun 2005 05:38:01

I need to link a parameter field on a html Data Access Page (created in
Access 2002) to a sql Query. Or maybe a filter, but prefer to execute the
filter/query before it looks up the data from the server. In a nutshell, i
want a user to enter a date at the top of the web page to limit the last date
of a query than show the retrieved records. Then either a GO button or hit
enter to send the thing into orbit. So if someone types 18 Jun 05, it will
show all records up to and including that date.

I can make a parameter query that will fire a pop-up parameter form, but i
think others in the company will be confused or balk at using this web Data
Access Page ( the MS form looks *** ). Can someone point me in the right
direction, or give me a good website for this info.

any help is much appreciated!!

Data Access Page from parameter Query

Post by Sylvain La » Mon, 20 Jun 2005 13:01:49

You can collect this value (or these values) into a cookie and then set the
parameters before the recordset is opened. See for an example:

Instead of cookies, you can also look at the possibility of using the
window.location.href property but I never tried myself.

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC