open query or report with docmd

[ben1988]

i define query with parameters
i set them by DoCmd.SetParameter

and after, open the query with DoCmd.OpenQuery

it's not ask to me to supply parameters, so i guess it really past...but,im not convinced it happen properly because the query dont do the expected.
and it happen with different queries

is there different way open query with parameters?

(i do have access 2010)

thanks!!

[Narender Sagar]

Hi Ben
Pl. check following link, it may help you in this regard.
https://msdn.microsoft.com/en-us/lib...or=-2147217396
regards,

[zmbd]

Ben, what are you expecting the setparameters command to do?

Once you run this command the parameter is set and any query executed within the scope of the code is going to be fed the value set.

It might be better if you could do two things:
1) Show us the Query SQL - PLEASE format the posted SQL using the [CODE/] format control.
2) Show us the code you are using to call the query. Once again, PLEASE format the posted SQL using the [CODE/] format control.

Narender Sagar, good link, I think however, maybe too much information for where Ben is currently at...?


Ben, you really need to review the tutorial I PM'd you. It will cover setting up queries and using WHERE conditions, Parameters, etc... in "bite sized chunks" in a systematic method.

[ben1988]

zmbd, like i told i tried it with different queries
and when i open the query directly - it works
so i dont really think it's matter to put here the sql

i just ask u
do u have query with where field1=[par]
when [par] is parameter
how u pass parameter and call it query via vba?? there are other ways to do it apart from my way?
there are any highlights i have to put attention?

thanks

[zmbd]

Ben, that's a non-answer to the questions asked.

1) What did you expect the DoCmd.SetParameter to do?
This command answers the prompts that a direct call to the query would make. Please read thru:
DoCmd.SetParameter Method (Access)

2) Show us the Query SQL - PLEASE format the posted SQL using the [CODE/] format control.
If we have this, then we have a much better chance of pointing you in the correct direction towards a solution

3) Show us the code you are using to call the query. Once again, PLEASE format the posted SQL using the [CODE/] format control.
If we have this, then we have a much better chance of pointing you in the correct direction towards a solution

++ You simply must answer the questions that we the Experts ask of you if you want us to help you help yourself. In this case we do not know how you are getting the information for the parameters, are you pulling from a form, hard coding, what? We don't know if you have typo or something else malformed in the code. Finally, we don't know if you have simply misunderstood the code you are using.

BTW: The link Saga gave you will answer your question; however, it's a lot of information to digest.
https://msdn.microsoft.com/en-us/lib...or=-2147217396

Another version of this can be found at:
Access Tutorial 10: Parameter Queries


A large number of use form controls with parameters within stored queries, there is an example of how to do this in the link.

PLEASE, PLEASE, PLEASE, go thru the tutorial link I PM's you. It will provide you with the hands-on experience you need to answer these questions.