469,648 Members | 1,172 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,648 developers. It's quick & easy.

Partial Match with Form Filter

8
Hello All,

Does any one know how to use the form filter in Access to provide partial match?
When you choose to "form filter," all text boxes will convert to combo boxes where you can choose from the already stored data in the corresponding tables. But for example I want to match all records containing the word John (assume it is a name field).
If there is a way to do this, it will save my life from having to write a big chunck of SQL code to achieve the mission especially with many fields on the form being matched against.

Appreciated.

- Hany
Oct 27 '06 #1
4 6021
PEB
1,418 Expert 1GB
Hi,

In the respective field type *John*

And you will see that the expression willchange automatically to :

Like "*John*"

:)
Oct 27 '06 #2
wecka
8
Thanks PEB,

That seems a straight forward and good solution, but what do you think will be the best way to present that to the user, especially those of low working knowledge?

Shall I create a little macro that will change the field value (adding the two astrics) before going the search?

I also think of a simpler way in adding a note or a help tip about the search.

Anyways, I am just brainstorming with you if you have something to share. Thanks :)

- Hany

Hi,

In the respective field type *John*

And you will see that the expression willchange automatically to :

Like "*John*"

:)
Oct 28 '06 #3
PEB
1,418 Expert 1GB
Hi

:)

In fact in my work i'm working just with this kind of autofilters and my users just use expressions like "*BEN*" when they search on a part of the field and when they search for full matching they omit the asterix...

Maybe it's better to write a help on how to use the asteriks...

At least I've done it...

The wilcards give a lot of potential to ssek the datbase without problems... And resolve a lot of problems for developping...

In fact I've never tried to change a value in a form filter... So I don't know if it's possible...

Hey people... Good question for a thread???? Is it possible? Changes a value in a form filter?

In queries, Forms, Tables... Yeah but formfilter??? In fact Yeah...Coz it goes stright to the filter property and you need to retreate the filter property of your form or query...

So it's possible with a lot of programming... But more knowledge for your users it should more easier to you! :)
Oct 28 '06 #4
wecka
8
Thanks PEB. Appreciate your prompt responses.

I agree that the help note will be good :)

- Hany
Oct 28 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

17 posts views Thread by Paul MG | last post: by
1 post views Thread by Stuart E. Wugalter | last post: by
2 posts views Thread by Christian Staffe | last post: by
4 posts views Thread by diego.sala | last post: by
20 posts views Thread by arnimavidyarthy | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.