By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,950 Members | 1,005 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,950 IT Pros & Developers. It's quick & easy.

Partial Match with Form Filter

P: 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
Share this Question
Share on Google+
4 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

In the respective field type *John*

And you will see that the expression willchange automatically to :

Like "*John*"

:)
Oct 27 '06 #2

P: 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
Expert 100+
P: 1,418
PEB
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

P: 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.