wildcards are driving me nuts!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

steph - 16 Mar 2006 18:11 GMT

hi everyone,

I've got a form in datasheet mode. Access 2002, English language.
Windows XP in German language. This form gets it's data from an Oracle
View.

I've got a field 'text' on my form, the field's contents looks like
this:

"A000003_C01_BV-C-00003 BV-P-0001_SP1365A3 L1P4 "
"A001082_A11_BV-C-00003 BV-P-0018_SP1735B3 L1P5 "
"A000004_D01_BV-C-00004 BV-P-0001_SP1271A L1P3 "
"A000004_D01_BV-C-00004 BV-P-0001_SP2218B ULP6 "

Now, when I try to filter for *BV-C-00004* the form returns exactly 0
rows. I've tried to filter with different strings, interestingly
sometimes it works - but most of the time it just returns nothing!

Could this be a language-settings issue? Are people out there having
experienced similar behaviour? Solutions?

BTW: i've turned name-auto-correct off.

Thanks for any input,
Stephan

Reply to this Message

Arno R - 16 Mar 2006 19:06 GMT

> hi everyone,
>
[quoted text clipped - 21 lines]
> Thanks for any input,
> Stephan

Maybe you need the 'like' operator also ?
Like *BV-C-00004*

Arno R

Reply to this Message

inkman04 - 16 Mar 2006 21:18 GMT

Perhaps what is needed is an expression that looks
like the following:

Like "*" & [Enter Code] & "*"

What this does it to put the wild card characters
in correct format with and expression, "Enter Code",
that will display what the user is to do when the dialog
window pops up.

This expression will be put into the Criteria row of
the required field.

Hope this answers your question.

Regards

Reply to this Message

Lyle Fairfield - 16 Mar 2006 23:49 GMT

Is it possible that you are applying the filter at the Server level and
therefore need Oracle WildCard Characters?

"_" - Match to any single character in this position;

"%" - Match to any number of characters in this position .

Reply to this Message

Anthony England - 17 Mar 2006 06:41 GMT

> hi everyone,
>
[quoted text clipped - 21 lines]
> Thanks for any input,
> Stephan

This doesn't exactly match what you describe, but there was certainly a bug
that would cause this if the table had an indexed field containing dashes.
The problem is described here: http://support.microsoft.com/kb/271661/en-us

It might be worth noting that the fix was a jet service pack, so you could
try this first, or at least let us know what version of jet you are using
(the article shows you how to do this).

Reply to this Message

steph - 17 Mar 2006 10:16 GMT

Hi,

My version of msjet40.dll is 4.0.8618.0. According to the article this
is the latest version for windows xp sp2 which i have.

Furthermore the table on wich the form goes is a linked table, which
comes from an oracle database. I think this index-issue cannot be
applied then.

Regarding the other proposals: I enter the filter string directly in
the datasheet-form after clicking on the filter-by-form icon in the
tool bar. so the like-operator is supplied automatically, or?
furthermore i have also tried with oracle-style wild-cards.

Thanks,
stephan

Reply to this Message

Anthony England - 17 Mar 2006 10:53 GMT

> Hi,
>
[quoted text clipped - 12 lines]
> Thanks,
> stephan

I'm afraid I don't really know - nor do I have an Oracle database to test
on.
I know some people here do use Oracle, so you might post with a new topic
asking an Oracle user to confirm your results. In the meantime you could do
some other tests such as if you write a saved query in access, do you always
get the correct results?

Reply to this Message