p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   VB Databases Basics (http://p2p.wrox.com/vb-databases-basics-82/)
-   -   ado.recorset.filter "like" trouble (http://p2p.wrox.com/vb-databases-basics/6460-ado-recorset-filter-like-trouble.html)

hamid1345 November 20th, 2003 06:34 PM

ado.recorset.filter "like" trouble
 
If I use this code, Error 3001 is shown.

mystring = "*pub"
Adodc1.Recordset.Filter = "name LIKE '" & mystring & "'"

I know '*' and '%' at the first mke this trouble.
My question is how I can filter this type terms.[^]


pgtips November 21st, 2003 03:53 AM

For ADO you always use % as the wildcard, not *

sunset April 14th, 2017 03:21 PM

rst.Filter = varMyBkmrk() crashes here
 
I have used a bookmark in Access ADO for years using "*" & Me.ProductFilt & "*" and works, I find the products, yet now when I get here it crashes rst.Filter = varMyBkmrk(), yet the bookmarks are assigned. Has never crashed before, have lots of finds just like this and they all crash now


All times are GMT -4. The time now is 09:01 PM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.