p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   VB Databases Basics (http://p2p.wrox.com/forumdisplay.php?f=82)
-   -   ado.recorset.filter "like" trouble (http://p2p.wrox.com/showthread.php?t=6460)

hamid1345 November 20th, 2003 07: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 04: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 03:04 AM.

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