Set Query Criteria thru Function
in [Form]
|
From: Abe Katz on 26 May 2010 12:48 Hi, I'm setting a query criteria thru a function, i.e. V1="RED": SetCriteria(V1) (setting global variable) and then I use in the Query Criteria another function to get the global variable i.e. GetCriteria(). It works fine. Now I want to set a criteria with multiple selections i.e.. V2="BLUE": V3=V1 & " or " & V2 and SetCriteria(V3) but it doesn't work. I tried with adding (wrap around with) quotes to V1 and V2 but it doesn't work. I can make V3 looks like this ""RED" or "BLUE"". or "RED or BLUE" Any suggestions? Thanks
From: PieterLinden via AccessMonster.com on 26 May 2010 14:41 Abe Katz wrote: >Hi, >I'm setting a query criteria thru a function, i.e. V1="RED": SetCriteria(V1) >(setting global variable) and then I use in the Query Criteria another >function to get the global variable i.e. GetCriteria(). >It works fine. >Now I want to set a criteria with multiple selections i.e.. V2="BLUE": V3=V1 >& " or " & V2 >and SetCriteria(V3) but it doesn't work. >I tried with adding (wrap around with) quotes to V1 and V2 but it doesn't >work. >I can make V3 looks like this ""RED" or "BLUE"". or "RED or BLUE" >Any suggestions? >Thanks global variables... <shudder> You could do this with a form-level variable... Why not just save the core structure of the SQL statement in a querydef and then append the WHERE and ORDER BY clauses at runtime? Just save the original (unmodified) .SQL property of the query into a string variable, modify the SQL property and run the query, and then revert the SQL property back to the saved variable. You can do all this through your form... should be simple... -- Message posted via http://www.accessmonster.com
From: Abe Katz on 27 May 2010 13:25 Thanks for your response, Can you give me an example how to do this. Thanks "PieterLinden via AccessMonster.com" <u49887(a)uwe> wrote in message news:a897d397502d7(a)uwe... > Abe Katz wrote: >>Hi, >>I'm setting a query criteria thru a function, i.e. V1="RED": >>SetCriteria(V1) >>(setting global variable) and then I use in the Query Criteria another >>function to get the global variable i.e. GetCriteria(). >>It works fine. >>Now I want to set a criteria with multiple selections i.e.. V2="BLUE": >>V3=V1 >>& " or " & V2 >>and SetCriteria(V3) but it doesn't work. >>I tried with adding (wrap around with) quotes to V1 and V2 but it doesn't >>work. >>I can make V3 looks like this ""RED" or "BLUE"". or "RED or BLUE" >>Any suggestions? >>Thanks > > global variables... <shudder> > You could do this with a form-level variable... Why not just save the core > structure of the SQL statement in a querydef and then append the WHERE and > ORDER BY clauses at runtime? Just save the original (unmodified) .SQL > property of the query into a string variable, modify the SQL property and > run > the query, and then revert the SQL property back to the saved variable. > You > can do all this through your form... should be simple... > > -- > Message posted via http://www.accessmonster.com >
|
Pages: 1 Prev: get data from a table not in a query Next: Opening a dialog in a more helpful position |