Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Aug 2002
    Wichita, Kansas, USA
    Thanked 0 Times in 0 Posts

    Data Access Pages (Access 2000)

    I have 2 tables in my database that are joined by a "question id".
    I have a query pulling the fields from both tables. The query contains a parameter to ask the user for criteria to pull a certain group of records.
    When I use that query as the basis for a data access page, I am prompted to input the criteria information, but no records are displayed on the page.
    If I take the parameter question out of the query and create a data access page, I get all of the data displayed.
    I'm wanting to use the data access page on our intranet for users to input data into the database.

    Any ideas why the criteria part doesn't work with data access pages?
    Thanks for any and all help!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Data Access Pages (Access 2000)

    I know virtually nothing about Data Access Pages, but it seems that you have to pass parameters in a special way - see Passing Parameters to a Data Access Page. This is for Access 2002, but I assume it holds for Access 2000 as well; there used to be an Access 2000 version but it isn't available any more.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts