A
Art Chadbourne
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.
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.