Re: Parameter quires in Data access pages

The script in the first DAP contains the code for doing that. Essentially,
you call a subroutine that is in the DAP's module that writes the cookie
with the parameter name and the parameter value.

Take a look at the VBScript and then post back with specific questions.

--

Ken Snell
<MS ACCESS MVP>

"Ramon" <Ramon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0963CCE9-21E8-4ACE-B61C-3949DFB66C35@xxxxxxxxxxxxxxxx
Thanks ken for the info I looked into your sample DB and I was unable to
view
how to complete the process of writing the parameters into the cookies.
can
you please explain how it is done. Thanks in advance for all of your help

"Ken Snell (MVP)" wrote:

You can write the parameter values into cookies and pass them to the
other
page that way. I have a sample database that uses cookies to pass a
parameter from one page to another:
http://www.cadellsoftware.org/SampleDBs.htm#FilterDAP

--

Ken Snell
<MS ACCESS MVP>



"Ramon" <Ramon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0A81C809-A331-4770-9C3F-788B3804F55A@xxxxxxxxxxxxxxxx
I am currently building a database within ms access that display data
based
on parameter quires within access. When I open a data access page it
asks
me
for the parameter "enter start date" and "enter end date". I have
several
pages based on the same parameter. Is it possible to move from one data
access page to another without having to retype the parameter again?

Example:

Page one GC Monthly Summary links to Call center SLA. via hyperlink.
Once
I
open GC Monthly summary I enter the parameter when I click the
hyperlink
for
Call center SLA I would like the page to use the same dates I entered
for
the
GC Monthly summary page.

Please assist






.

Relevant Pages

  • Re: Parameter quires in Data access pages
    ... Im sorry i looked into the code on thr DAP, and since i have never writing ... "Ken Snell " wrote: ... <MS ACCESS MVP> ... how to complete the process of writing the parameters into the cookies. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Create Hyperlink Macro
    ... "Ken Snell " wrote: ... Is the field where you want to put the filename a hyperlink field, ... <MS ACCESS MVP> ... The monthly reports are in an excel format and ...
    (microsoft.public.access.macros)
  • Re: Report Images
    ... <MS ACCESS MVP> ... image appear in a report to add code into the Report Detail OnFormat event ... but if txtImageName is a hyperlink defined table field, ... "Ken Snell " wrote: ...
    (microsoft.public.access.reports)
  • Re: IE issue - issue solved
    ... For about the last month I was having issues with IE randomly freezing ... when clicking on a hyperlink. ... meant that I lost all my cookies, ... another 5 minutes to reset the home page and a few web sites that use ...
    (comp.sys.mac.advocacy)
  • Re: IE issue - issue solved
    ... when clicking on a hyperlink. ... Aggravating ... meant that I lost all my cookies, ... A Linux setup is a walk in the park? ...
    (comp.sys.mac.advocacy)
Loading