Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    View Passed Parameter (2003)

    I've setup a form to pass a parameter to my query. I can't get the darn thing to work. Is it possible to popup an alert to view the passed parameter? I know my query is accurate. Any insight would be greatly appreciated. Thanks beforehand!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: View Passed Parameter (2003)

    The parameter in the Criteria row should look like

    [Forms]![FormName]![ControlName]

    with the appropriate names for the form and control substituted.

    In some situations, it is necessary to declare the parameter explicitly:
    - Select Query | Parameters...
    - Enter the parameter exactly as used in the Criteria (copy & paste is handy)
    - Select the appropriate data type.
    - Click OK.

    The form must be open, otherwise the query will prompt you for the parameter.

  3. #3
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Passed Parameter (2003)

    Hi Hans,

    I gave that a shot with no luck. Here is my criteria...

    Like "[Forms]![Aging Detail Query Prompt]![Condo]*"

  4. #4
    Star Lounger
    Join Date
    Nov 2005
    Location
    Edmonton, Alberta, Canada
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Passed Parameter (2003)

    Try
    Like [Forms]![Aging Detail Query Prompt]![Condo] & "*"

  5. #5
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Passed Parameter (2003)

    I decided I'd try it on my tables that were not linked tables and it worked fine. Unfortunately, everytime I try the code in a query searching a linked table, it crashes Access. Any clues? Thanks again!

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: View Passed Parameter (2003)

    Are those tables linked to another Access database, or to a SQL Server database, or to something else?

  7. #7
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Passed Parameter (2003)

    Actually, they're linked to a pervasive database. We use an accounting program called Timberline, in which I use Access to generate reports.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: View Passed Parameter (2003)

    I'm afraid I have no experience whatsoever with Pervasive or Timberline.

  9. #9
    2 Star Lounger
    Join Date
    Mar 2002
    Posts
    164
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: View Passed Parameter (2003)

    Hans,

    I appreciate the feedback. Thanks again for the great assistance! Best regards!

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: View Passed Parameter (2003)

    If the tables are not too big, why don't you import them into Access and do the work from there?

  11. #11
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: View Passed Parameter (2003)

    How are you linking to the Pervasive SQL tables - with an ODBC driver? It that's the case, the driver is probably suspect - I have no experience with trying to link to Timberline either, but have seen that behavior with other kinds of sources. Patt's suggestion that you import the tables and then work with them may be the best approach.
    Wendell

Posting Permissions

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