wildcards are driving me nuts!

[steph]

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_C0 1_BV-C-00003 BV-P-0001_SP1365A3 L1P4 "
"A001082_A1 1_BV-C-00003 BV-P-0018_SP1735B3 L1P5 "
"A000004_D0 1_BV-C-00004 BV-P-0001_SP1271A L1P3 "
"A000004_D0 1_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

[Arno R]

Re: wildcards are driving me nuts!


"steph" <stephan0h@yaho o.de> schreef in bericht news:1142529099 .347924.211010@ u72g2000cwu.goo glegroups.com.. .[color=blue]
> 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_C0 1_BV-C-00003 BV-P-0001_SP1365A3 L1P4 "
> "A001082_A1 1_BV-C-00003 BV-P-0018_SP1735B3 L1P5 "
> "A000004_D0 1_BV-C-00004 BV-P-0001_SP1271A L1P3 "
> "A000004_D0 1_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[/color]

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

Arno R

[inkman04]

Re: wildcards are driving me nuts!

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

[Lyle Fairfield]

Re: wildcards are driving me nuts!

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 .

[Anthony England]

Re: wildcards are driving me nuts!

"steph" <stephan0h@yaho o.de> wrote in message
news:1142529099 .347924.211010@ u72g2000cwu.goo glegroups.com.. .[color=blue]
> 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_C0 1_BV-C-00003 BV-P-0001_SP1365A3 L1P4 "
> "A001082_A1 1_BV-C-00003 BV-P-0018_SP1735B3 L1P5 "
> "A000004_D0 1_BV-C-00004 BV-P-0001_SP1271A L1P3 "
> "A000004_D0 1_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[/color]



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).

[steph]

Re: wildcards are driving me nuts!

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

[Anthony England]

Re: wildcards are driving me nuts!

"steph" <stephan0h@yaho o.de> wrote in message
news:1142586993 .781367.173830@ u72g2000cwu.goo glegroups.com.. .[color=blue]
> 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[/color]


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?