Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217

    Unanswered: Query with parameters in Access Projects

    I am working with Access Project with SQL server as backend.

    In Access 97, we can create queries with parameters.
    How can we do the same in Access Projects ??

    Stored procedures ? But I thought we cannot join stored procedures in the way we join tables/queries.

    Please help.

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    What is it more exactly that your looking for?

    Yes you can create queries with parameters... but what do you want to do?

    Regards

  3. #3
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217
    Thanks for the reply.

    I started this with an mdb file. I created 2 queries with parameters, which are references to a form date range.

    Query1:
    Select * From table1 where Date between forms!x!date1 and forms!x!date2 and blah, blah...

    Query2:
    Select * From Query1 where Date between forms!x!date1 and forms!x!date2 and blah, blah...

    >>Now I am converting these queries to an Access Data Project.

  4. #4
    Join Date
    Jun 2004
    Posts
    96
    in Access project, you cannot create view as a parameter query.. it can only be done in the queries that are lying behind forms as recordsource..

  5. #5
    Join Date
    Jul 2003
    Location
    Australia
    Posts
    217
    I think they CANNOT be used even in the "recordsource" property of a form.

Posting Permissions

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