Data Access Page from parameter Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 nasty). Can someone point me in the right
direction, or give me a good website for this info.

any help is much appreciated!!
 
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:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_DSCOM.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/programdap.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/ODC_acc10_DSCOM.asp

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