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 6 1217
"steph" <st*******@yahoo.de> schreef in bericht news:11**********************@u72g2000cwu.googlegr oups.com... 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
Maybe you need the 'like' operator also ?
Like *BV-C-00004*
Arno R
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
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 .
"steph" <st*******@yahoo.de> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com... 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
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).
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
"steph" <st*******@yahoo.de> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com... 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
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? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Keiron Waites |
last post by:
Please see the problem in action here: http://www.leadbullet.biz/contact.php
If you mouse over the fields, you will see that text is shown on the right.
The text makes the other fields move when...
|
by: Marty |
last post by:
It seems all of the sudden that user controls that
contain images are referencing image sources relative to
the document that I drop the control on. This obviously
does not work beacuase the...
|
by: Simon Harris |
last post by:
Ok, this really is driving me nuts!!! :(
'All' I am trying to do is get the value of a named element. My XML doc
is:
<?xml version="1.0" encoding="utf-16" standalone="yes" ?>
- <Page>...
|
by: ipmccun |
last post by:
Hello all:
Perhaps someone can shed some light on this: I'm trying to create a
situation, while debugging, where a long running request (sleeps for
15s) and a short running request execute...
|
by: trond |
last post by:
Hello all,
Before I start I'd like to point out that I am a complete novice when
it comes to asp.net - My background is in network and operating
systems, and although I have been doing a bit of...
|
by: mitsura |
last post by:
Hi,
I need to read a simle XML file. For this I use the SAX parser. So far
so good.
The XML file consist out of number of "Service" object with each object
a set of attributes.
I read...
|
by: jason.neo |
last post by:
Hi all experts,
I am going nuts with this Invalid postback or callback argument thingy
with .Net 2.0
I am building a file attachment module which relays on a Datatable
stored in session (yeah...
|
by: mattlightbourn |
last post by:
Hi all,
I have a problem which has been driving me nuts. Crosstab queries!
I have a database witch a few different tables to do with garment manufacturing.
I have a table for a client...
|
by: DuncanIdaho |
last post by:
Hello experts
IE 7.0.5730.11
Opera 9.27
Firefox 2.0.0.14
This problem only occurs in Opera and Firefox (amazing, IE does
something right, or maybe not)
Anyway, the problem is that when I...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
| |