how to get query criteria in access vba
Now I am trying to create customize query design view form with Access VBA. I want to show fields name and criteria of saved query.
For example, SQL statement that executed by QueryDef.sql is
SELECT AllCars.ID, AllCars.CarName
FROM AllCars
WHERE (((AllCars.ID) Between 15 And 25) AND ((AllCars.MinPay)<1000)) ;
I would like to get criteria expressions( ID = Between 15 And 25, MinPay = <1000) and field names(ID , CarName) from it. I can get field name but I am not sure how to get query criteria expression in Access VBA. I tried to split sql statement but I think this is not a best way for multiple开发者_JAVA百科 criteria expressions. If getting criteria in access vba may be possible, could someone help me?
Thanks in advance.
精彩评论