DoCmd.OpenQuery

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SteveG - 28 Dec 2005 14:10 GMT

Does anyone have an easy method to pass parameters to the stored proc name in
the DoCmd.OpenQuery?

I know I can use a QueryDef and pass parameters that way but was wondering
if there was an easy way using DoCmd.OpenQuery.

Reply to this Message

Douglas J. Steele - 28 Dec 2005 14:19 GMT

AFAIK, it can't be done.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Does anyone have an easy method to pass parameters to the stored proc name
> in
> the DoCmd.OpenQuery?
>
> I know I can use a QueryDef and pass parameters that way but was wondering
> if there was an easy way using DoCmd.OpenQuery.

Reply to this Message