Customizing Parameters to data access page

Customizing Parameters to data access page

Post by SimpleTech » Sat, 24 Jul 2004 01:34:35


I have saved a query as a data access page. The parameters
to be filled are Name, Start Date and End Date. This is
tedious coz it has to be typed in manually.

My question: Can I have a list of names(menu kind) and 2
calendars for the users to select quickly??


Please suggest.
Thank you.
 
 
 

Customizing Parameters to data access page

Post by Paul » Sun, 25 Jul 2004 00:55:13

why yes you can...
The list is relatively easy, just link a list box to the field you want to
chose from.

The calendars are a little more difficult. If you search msdn you can find
an example of a calendar used for parameters (start and end dates)
Paul D

 
 
 

Customizing Parameters to data access page

Post by SimpleTech » Wed, 28 Jul 2004 01:54:03

Hmm, I am quite sure you didnt get my question. The
parameters are embedded in the query and hence show up
crudely when I invoke the Data Access page.
Thanks
field you want to
msdn you can find
end dates)


parameters
 
 
 

Customizing Parameters to data access page

Post by Paul » Fri, 30 Jul 2004 03:00:48

I still don't get your question...
why not take the parameters out of the query and put them in the DAP then
filter based on the answers?
Paul D
 
 
 

Customizing Parameters to data access page

Post by SimpleTech » Sat, 31 Jul 2004 02:10:38

Can you tell me how to define parameters to a DAP? I only
know of the group filter control. Are there others???
Looking for your reply.

in the DAP then


the
search


is
and 2
 
 
 

Customizing Parameters to data access page

Post by Paul » Wed, 04 Aug 2004 02:09:29

currently I have used two ways. The first way I use a popup dialog or DAP
with a click link to feed the parameter to the second page which uses a
group filter control. I have only used the filter for single parameters but
I would imagine you could send more than one parameter for the filter. I am
not programmer by nature so I'm not sure.
The second way is use a popup or DAP to get the parameters then write the
query based on those parameters (i.e. use a client side query rather than
server side). while client side queries are slower, this may not be a big
deal if the data set is small or time is not that critical. Let me know
which way you are interested in.
Paul D