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: Insert Hyperlink > Browsed Pages -- how to clear list??
    ... > Word 2000; Windows XP Personal ... > How can I clear the list of Browsed Pages in the Insert Hyperlink dialog? ... > In IE, I've cleared History, Files, Content, Cookies, but the list in Word ... > persists. ...
    (microsoft.public.word.docmanagement)
  • Re: Parameter quires in Data access pages
    ... You can write the parameter values into cookies and pass them to the other ... When I open a data access page it asks ... Page one GC Monthly Summary links to Call center SLA. ... open GC Monthly summary I enter the parameter when I click the hyperlink ...
    (microsoft.public.access.dataaccess.pages)