O
opal
I have built a simple form used to filter data that has worked for several
years but now have problems. I need to filter a string by using a wildcard. I
used this statement:
Like "*" & [Forms]![frmMainForm]![txtMessage] & "*"
The underlying problem is I recently migrated the data to Oracle and use
Access as a front end. I now find that searching in the text box using a *
does not work. What can I use to filter data?
years but now have problems. I need to filter a string by using a wildcard. I
used this statement:
Like "*" & [Forms]![frmMainForm]![txtMessage] & "*"
The underlying problem is I recently migrated the data to Oracle and use
Access as a front end. I now find that searching in the text box using a *
does not work. What can I use to filter data?