Parameters in a Pass-Through Query?

[programmerbob]

I want a user to input some information.

I was wondering if anyone has done this. I don't mind if it's code or not(I think it does have to be code).

The way the data tables are(I have no control over this), to get my information(using a subquery) I can't do a make table query and then filter that way.

Thanks

 

[Joe4]

Check out Access's help on parameter queries.

 

[Dugantrain]

I have done this and it would have to be code. The way that I've done this is to set up text boxes on a form for the parameters that you want, capture those values in variables, and then use the Querydef object to build an on-the-fly query based off of a combination of whatever SQL you can get away with hard-coding and the SQL from your variables. You'll have to look up the properties and methods of the DAO.QueryDef object, but to answer your question, it is possible to do.

*edit* JMiskey, I think that he specifically needs information on Pass-Through queries with parameters, which is impossible with conventional Access query parameters.

 

[Joe4]

*edit* JMiskey, I think that he specifically needs information on Pass-Through queries with parameters, which is impossible with conventional Access query parameters.

The details were pretty vague in the original post, so I thought I would start there (no need to make things more complicated than they have to be), but if it is a more complex issue, you are correct in that they will have to use code.