Its been a hell of a day for reasons other than MS and that damndable
Ribbon.

I have a stored procedure that I'm now able to access via a pass-through
query. How would I go about altering the parameters passed? Do I need to
create a module that creates the querydef on the fly dynamically added the
actual values or are there other ways?

You need to alter the SQL of the query dynamically.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)



"microsoft" <(E-Mail Removed)> wrote in message
news:e3cUHcR$(E-Mail Removed)...
> Its been a hell of a day for reasons other than MS and that damndable
> Ribbon.
>
> I have a stored procedure that I'm now able to access via a pass-through
> query. How would I go about altering the parameters passed? Do I need to
> create a module that creates the querydef on the fly dynamically added the
> actual values or are there other ways?
>

Yeah, I thought so.

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:OHsBmkR$(E-Mail Removed)...
> You need to alter the SQL of the query dynamically.
>
> --
> Doug Steele, Microsoft Access MVP
> http://www.AccessMVP.com/djsteele
> Co-author: Access 2010 Solutions, published by Wiley
> (no e-mails, please!)
>
>
>
> "microsoft" <(E-Mail Removed)> wrote in message
> news:e3cUHcR$(E-Mail Removed)...
>> Its been a hell of a day for reasons other than MS and that damndable
>> Ribbon.
>>
>> I have a stored procedure that I'm now able to access via a pass-through
>> query. How would I go about altering the parameters passed? Do I need to
>> create a module that creates the querydef on the fly dynamically added
>> the actual values or are there other ways?
>>
>

Actually I was surprised at how easy it was to create a create/update sub to
mange it. Quite nice.

"David C. Holley" <David.C.Holley> wrote in message
news:%23oR1DrS$(E-Mail Removed)...
> Yeah, I thought so.
>
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
> news:OHsBmkR$(E-Mail Removed)...
>> You need to alter the SQL of the query dynamically.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://www.AccessMVP.com/djsteele
>> Co-author: Access 2010 Solutions, published by Wiley
>> (no e-mails, please!)
>>
>>
>>
>> "microsoft" <(E-Mail Removed)> wrote in message
>> news:e3cUHcR$(E-Mail Removed)...
>>> Its been a hell of a day for reasons other than MS and that damndable
>>> Ribbon.
>>>
>>> I have a stored procedure that I'm now able to access via a pass-through
>>> query. How would I go about altering the parameters passed? Do I need to
>>> create a module that creates the querydef on the fly dynamically added
>>> the actual values or are there other ways?
>>>
>>
>
>