Case sensitive seek using an Access database 
Author Message
 Case sensitive seek using an Access database

I have an indexed field containing records with lowercase and uppercase. Eg:
Rs/1998/0001 and RS/1998/0001,  which are two different items.  When I seek
the recordset as follows:

   cStock = InputBox("Please enter Stock Key to find", "Find Stock Key", "")
   If cStock <> "" Then
      dbStock.Recordset.Index = "stockkey"
      dbStock.Recordset.Seek "=", cStock
      If dbStock.Recordset.NoMatch Then...

If the user enters RS/1998/0001 or Rs/1998/0001, the seek always finds the
RS/1998/0001.  I need to know how to make the search case sensitive so that
the correct item is found.

I'm opening an ACCESS MDB V.7 database.

Any help will be appreciated.


Thu, 28 Dec 2000 03:00:00 GMT  
 Case sensitive seek using an Access database
SELECT * FROM MyMaster WHERE PartNumber = RS/1998/0001

do while MyTbl.eof=false
  if PartNumber="Rs/1998/0001" then goto FoundItem

Thu, 28 Dec 2000 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Making the access database case sensitive

2. How to search Case Sensitive in Access Database?

3. Case-sensitive SEEK

4. How to make database case sensitive?

5. Trouble with case-sensitive database.

6. Make case-sensitive SQL queries against Jet database

7. Case sensitive selection using VB4 Jet Engine

8. Need help, CR is using case sensitive

9. Case sensitive values in Access unique Indexs

10. Help Crystal DTC Form Field Access case sensitive

11. Case sensitive primary key

12. Case sensitive


Powered by phpBB® Forum Software