index and seek need help

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Art Chadbourne" <art@xxxxxxxxxxxxxx>
Date: Tue, 31 Jan 2006 13:28:13 GMT

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.

.

Prev by Date: RE: Problem reading data into Dataset
Next by Date: RE: How to Open Separate Browser Window with Server Controls?
Previous by thread: showmodaldialog issues
Next by thread: Script Alternative: Client-Site Controls by Custom .NET Assemblies ?
Index(es):
- Date
- Thread

Relevant Pages

Indexs and seek need help
... Here is the scenario. ... Access XP using VBA. ... My third seek is m-12 and it does not find it. ... This works with an Access 97 database not with an Access XP database. ...
(comp.databases.ms-access)
Re: Indexs and seek need help
... > Here is the scenario. ... > Access XP using VBA. ... > This works with an Access 97 database not with an Access XP database. ... Prev by Date: ...
(comp.databases.ms-access)
Re: Merging content from access
... My hunch at the moment is that this is a problem in my access query. ... I agree with you that Word VBA is a more elegent solution. ... The other field-based technique requires you to have a "parent" table as ... the mail merge data source and a child table inserted using a DATABASE ...
(microsoft.public.word.docmanagement)
Re: Possible Project Bug: All Projects in Database are Deleted upon Save
... best practices and Project VBA ... > Only Project1 is saved into the database. ... >> prompts with Append or overwrite message. ... >> For Microsoft Project companion projects, ...
(microsoft.public.project.vba)
Re: What happens when data in control is updated
... When I developed my concept database file I tended to look at what ... changes expected appearing on the form itself) and not going through the VBA ... > if the primary key field is Text data type, rather than numeric, the ... >>> make sure that a requery is necessary to achieve whatever your aim is. ...
(microsoft.public.access.formscoding)