Access Utilities: Simil Fuzzy String Matching by Tom van Stiphout, VBA
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 free Access Basics book covering foundations of Access
http://www.accessmvp.com/strive4peace
Access video tutorials and articles on EverythingAccess
http://www.EverythingAccess.com/Tutor...
let's connect *
Do you need help? You know your business. I know how to teach, write programs, and develop applications. If you have a budget and want control of your project, let's connect and build it together!
visit MsAccessGurus and contact me today!
http://msaccessgurus.com
I look forward to hearing from you ~
warm regards,
crystal
Remote Programming & Training -- connect to me, let's built it together
~ have an awesome day ~