RE: not check accents

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kjell (anonymous_at_discussions.microsoft.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 12:01:10 -0700

Hi

I had such a problem once, but I had a VB application with a search function on a database.

anyway, I solved it by creating a sub that replaces all this strange letters with question mark (?) before leaving it over to the sub doing the search, I made the replace function in such way it replaces all characters not found within the regular
Ascii codes a-z and A-Z respectively.

And it works superb

Kjell

Relevant Pages

  • Searching Records Using a (Global?) Module
    ... The search function works as follows: ... Option Compare Database ... Public strFindDirection As String ... Private Sub fldName_Enter ...
    (microsoft.public.access.gettingstarted)
  • Re: Is this possible with a Macro
    ... got it did a bit of flinging thru the search function found paste ... Here is the amended code that works, lots of thanks to Madiya and ... Sub testbaby() ...
    (microsoft.public.excel.programming)
  • OU GPO search
    ... It there a product to view GPO setting without having to ... drill down thru all the menu's and sub menu's? ... A search function would be great, also a way to view the ...
    (microsoft.public.win2000.active_directory)