Loading...

Access Utilities: Simil Fuzzy String Matching by Tom van Stiphout, VBA (cc) English, Dutch, French

8,331 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jun 11, 2011

Tom van Stiphout, a Microsoft MVP for Access, demonstrates how to use Simil, an algorithm implemented in Access using VBA for comparing strings that are not exactly the same.

Download all the code and a sample Northwind database showing how Simil is used here:

Tom van Stiphout's blog and website:
http://www.AccessMVP.com/TomVanStiphout

After Tom's presentation, there is a code wrap-up discussing some clever programming that was done. ~ 0:25, pip (picture-in-picture) of Tom presenting Simil at the Global Microsoft MVP Summit, footage by Gina Whipp, http://www.access-diva.com/

~ 9:30, the video discusses finding a record.
This also works without needing to go to a bookmark:

Me.Recordset.FindFirst "[Fieldname]=" & numberValue

...thanks to John Viescas for pointing out Bill Mosca pointed this out ;)

*** Captions ***
To toggle Captions on or off, click "cc" under the video. If captions are on, you can choose a translation by hovering over "cc". It is a good idea to watch the video both ways, with and without captions. If you are fortunate to hear, then also watch without volume -- different perspectives give you deeper understanding.

to toggle caption background ON/off:
click .. cc... Other option ... Background
caption background needs to be ON to read all the captions

*** TRANSLATIONS *** VERTALINGEN *** TRADUCTIONS ***
Dutch - Tom van Stiphout http://www.kinetik-it.com
French - John Viescas http://www.Viescas.com

*** Links ***

Northwind Traders Sample Database
Microsoft Download Center
http://www.microsoft.com/downloads/en...

~~~
Crystal's website with Access Basics, a free book covering foundations of Access
http://www.AccessMVP.com/strive4peace

Access video tutorials and articles on EverythingAccess
http://www.EverythingAccess.com/Tutor...

more Access links:
http://www.AccessMVP.com
http://AllenBrowne.com/Tips.html
http://www.UtterAccess.com
http://www.MVPs.org

Warm Regards,
Crystal

*
(: have an awesome day :)
*

***********************************
produced with Camtasia

Camtasia Studio 7 Learning Center
http://www.Techsmith.com/Learn/Camtas...

*********************************************************

~

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...