开发者

how to get query criteria in access vba

开发者 https://www.devze.com 2022-12-07 17:44 出处:网络
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.

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号