Microsoft Access Office VB VBA Help and Examples
 HOME     MS ACCESS     MS OUTLOOK     MS EXCEL     VB and VBA     FREE PROGRAMS     iPAQ     PERSONAL 
 ACCESS     GENERAL     QUERIES     FORMS     REPORTS     MODULES     RANTS     TUTORIALS 

Finding Data Entry Typos

The link below contains a database with one form. This form will help you find one character data entry typos in the same field. It's another in progress thing so it's a little slow. But what it does can save a lot of manual searching.

If you have a field that contains the following records

Anne  Annte Ane Anme 

they will all be returned by this form  as typos of each other. Just import the form into your database and select a table and field and run.

Please note it could take quite a while if the recordset is huge.

TyposChecker.mdb 140Kb Version 1.0

 
HOME   SEARCH SITE   PRIVACY POLICY   CONTACT
The code and application content of this site is copyright of Smiley I.T. and as such reproduction in any form which is for commercial use requires the permission of the Webmaster. Any use of this code for non-commercial use only requires a link or comment back to the original page you took the code from.