Re: Customizing Parameters to data access page

From: Paul D (pdspam_at_highstream.net)
Date: 07/28/04

  • Next message: RobertoA: "How debug Data Access Page ?" 
    Date: Wed, 28 Jul 2004 14:00:48 -0400

    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

    "SimpleTechie" <anonymous@discussions.microsoft.com> wrote in message
    news:45d901c47331$27e7c930$a501280a@phx.gbl...
    > 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
    > >-----Original Message-----
    > >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
    > >
    > >"SimpleTechie" <anonymous@discussions.microsoft.com>
    > wrote in message
    > >news:222601c47009$c5eb1130$a601280a@phx.gbl...
    > >> 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.
    > >
    > >
    > >.
    > >

  • Next message: RobertoA: "How debug Data Access Page ?"

    Relevant Pages

    • Re: Access 2000 ADP - error when applying form filter - error message "The column prefix XXX do
      ... maybe it is the caracter # in the Cluster# that gives DAP a hiccup. ... with DAP; even if they are perfectly valid under T-SQL. ... you don't give us what is the form filter that you are using and how ... > name used in the query" ...
      (microsoft.public.sqlserver.odbc)
    • Re: Access 2000 ADP - error when applying form filter - error message "The column prefix XXX do
      ... maybe it is the caracter # in the Cluster# that gives DAP a hiccup. ... with DAP; even if they are perfectly valid under T-SQL. ... you don't give us what is the form filter that you are using and how ... > name used in the query" ...
      (microsoft.public.access.forms)
    • RE: Creating query to produce report
      ... "Paul" wrote: ... > able to print this info in a report and i presume creating a query would be ... > it can reference the Variable IDs and give the text description rather than ... > I also have trouble with Access telling me changes or deletions cant be done ...
      (microsoft.public.access.queries)
    • Re: From Date x to Date y (Query table data)
      ... > Criteria of the date field in the query, ... The query we are creating will pull data ... and several queries for all the different time frames. ...
      (microsoft.public.access.queries)
    • RE: Top 10 Percent / Top 10 Values
      ... Yes use your table name instead of Paul. ... If I create a new query would I need to write this code in a SQL view of the ... "KARL DEWEY" wrote: ... I have already worked out how many records there are per client, ...
      (microsoft.public.access.queries)