Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / January 2006

Tip: Looking for answers? Try searching our database.

Indexs and seek need help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Art Chadbourne - 31 Jan 2006 13:46 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.
Anthony England - 31 Jan 2006 14:37 GMT
> Here is the scenario.
> Access XP using VBA.
[quoted text clipped - 10 lines]
>
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.