Re: Indexs and seek need help
- From: "Anthony England" <aengland@xxxxxxxxxx>
- Date: Tue, 31 Jan 2006 14:37:31 +0000 (UTC)
"Art Chadbourne" <art@xxxxxxxxxxxxxx> wrote in message
news:ZSJDf.3893$b%2.3200@xxxxxxxxxxx
> Here is the scenario.
> Access XP using VBA.
>
> I have a text field. The text that I have in the field is m-1234.
> I am running a >= seek.
> My first seek is m and it returns m-1234.
> My second seek is m- and it does not find it.
> My third seek is m-12 and it does not find it.
> My last seek is m-1234 and it finds it.
>
> Why does it not find m-1234 when I am doing a >= seek and my text is m- or
> m-12?
>
> This works with an Access 97 database not with an Access XP database.
I think I got caught by this bug before:
http://support.microsoft.com/kb/271661/en-us
.
- References:
- Indexs and seek need help
- From: Art Chadbourne
- Indexs and seek need help
- Prev by Date: Re: How call procedure?
- Next by Date: select from a table the highest revision number
- Previous by thread: Indexs and seek need help
- Next by thread: select from a table the highest revision number
- Index(es):
Relevant Pages
|
