Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pass-through criteria (2003 SP2)

    Is it possible for pass-through query criteria to be put into a form control, like an for an Access table? I've had a go, but no joy. The pass-through is to AS400 tables, via ODBC.

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

    Re: Pass-through criteria (2003 SP2)

    The idea is to use VBA to set the SQL of a pass-through query in code. The value of the form control must be concatenated as a literal value.
    See ACC2000: How to Simulate Parameters in an SQL Pass-Through Query (applies to other Access versions too)

  3. #3
    4 Star Lounger
    Join Date
    May 2001
    Location
    Oxfordshire
    Posts
    456
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pass-through criteria (2003 SP2)

    Thanks Hans, that would do the job. But I guess I'll have to leave it till I can understand & write VBA; this is way over my head.

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

    Re: Pass-through criteria (2003 SP2)

    Don't hesitate to ask specific questions if/when you get round to it.

Posting Permissions

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