Re: Passing values from a DAP to an Access Query
From: Ken Snell [MVP] (kthsneisllis9_at_ncoomcastt.renaetl)
Date: 12/29/04
- Next message: Alexandre Saillant: "VbScript - Refresh command"
- Previous message: Ralph Heidecke: "Passing values from a DAP to an Access Query"
- In reply to: Ralph Heidecke: "Passing values from a DAP to an Access Query"
- Next in thread: PaulD: "Re: Passing values from a DAP to an Access Query"
- Reply: PaulD: "Re: Passing values from a DAP to an Access Query"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Dec 2021 15:30:41 -0500
Not sure exactly what you're doing -- are you trying to run a normal ACCESS
report from a DAP? or just trying to display data on a DAP that would serve
as a report?
Assuming that you want to display data on a DAP based on a filtering value
selected by a user, there are a couple of ways to do that. One way is to put
a textbox or combo box on a DAP, let the user enter/select a value, write a
cookie with that value, then read the cookie in the second DAP and use the
ServerFilter property of that DAP to filter the recordset before it's
opened. Another way is to use a hyperlink element on the first DAP to open
the second DAP, and use the ServerFilter property of the hyperlink element
on the first DAP to filter the second DAP's recordset.
Please provide a little more info about what you're trying to do.
--
Ken Snell
<MS ACCESS MVP>
"Ralph Heidecke" <ralph.heidecke@gems.gov.bc> wrote in message
news:41d30f13@obsidian.gov.bc.ca...
>I am new DAPs and not very expereinced with HTML. I have created a DAP
>based
> on a query. In past Access applications ( I have done a few - mostly in
> Access 97) I set up forms for users to input values to the query - in this
> case an employee number and once the user supplied the parameter a report
> was produced.
>
> I have used this approach with the DAP and it works well enough except a
> form (it looks like a list box) is returned entitled "Enter Paramter" in
> the form is a box under a column header "Value". In the second column
> called
> name is the name of the variable txtNumber in the Access Query behind the
> DAP.
>
> I would like either modify the form so it is more user Friendly - ie it
> asks
> the user to supply the employee name or to have a custom form that
> acheives
> the same end. I have looked over the html and Javascript code for the DAP
> and can't find where the default form is produced.
>
> Any help you can offer would be appreciated.
>
> TIA
>
>
- Next message: Alexandre Saillant: "VbScript - Refresh command"
- Previous message: Ralph Heidecke: "Passing values from a DAP to an Access Query"
- In reply to: Ralph Heidecke: "Passing values from a DAP to an Access Query"
- Next in thread: PaulD: "Re: Passing values from a DAP to an Access Query"
- Reply: PaulD: "Re: Passing values from a DAP to an Access Query"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
