How can I pass the parameter to a query with Macro

N

new.microsoft.com

I have a query which contains parameters, How can I pass the parameters to
the query by using VBA
 
Y

Yuan Shao

Hello,

Thanks for your post. Based on your description, I understand that you want
to use parameter in a query using VBA. If I have misunderstood, please feel
free to let me know.

Please check and see the suggestions in the following article:
201493 ACC2000: How to Use ADO to Create a Parameterized Jet Stored
Procedure
http://support.microsoft.com/?id=201493

Please feel free to post in the group if this solves your problem or if you
would like further assistance.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top