带字符串的VBA LIKE运算符 [英] VBA LIKE operator with string

问题描述

我有此代码:

Private Sub Item_AfterUpdate()
Me.SApp.Form.RecordSource = "SELECT * FROM Application WHERE Item = '" & Me.Item.Value & "';"
End Sub

现在，它可以正常工作，因此它会根据组合框Item中的值过滤SApp(子窗体). 我想做类似的事情，但是不平等，却喜欢. 因此，类似:

Now , this works so it filters SApp (a subform) base on the value in the combobox Item. I wanna do something similar however not with equal but with like. So , something like:

Private Sub Item_AfterUpdate()
Me.SApp.Form.RecordSource = "SELECT * FROM Application WHERE Item LIKE '" & Me.Item.Value & "';"
End Sub

我尝试过:

'% Me.Item.Value %'

'% '" & Me.Item.Value & "' %'

'% s %' with (Dim s as string ; s = Me.Item.Value)

此解决方案均无效，对如何解决此问题有任何想法吗?

None of this solutions works , any idea on how to fix this?

推荐答案

在MsAccess中使用*通配符，在其他数据库中通常为％.

Use the * wildcard in MsAccess, in other dbs it's usually %.

引用: https://msdn.microsoft .com/en-us/library/bb208897(v = office.12).aspx

这篇关于带字符串的VBA LIKE运算符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！